Hello, I'm developing an application using JBoss 4.2.3. I have to store some
XML documents in a database and I have to read, and update them. These
documents will be encrypted eventually so I have defined an entity like this:
@Entity
public abstract class Document implements Serializable {
@Id
@GeneratedValue
protected long id;
@Lob
protected byte[] content;
protected String username;
....................
getters and setters
....................
}
I'm using PostgreSQL 8.3 as my backend.
Hibernate generates a table for this entity with a field of type 'oid' for the
row content and it stores the real content in the common table pg_largeobjects.
The problem is that, everytime that I update the field content, it generates a
new entry in pg_largeobjects and updates the oid field but it does not delete
the old object, so in every update to my document, I get a new copy of all the
content in the database.
Is this the normal behavior? I'd like to either, use the same record for the
update or to generate a new one, but delete the old one, since it's no longer
needed.
View the original post :
http://www.jboss.com/index.html?module=bb&op=viewtopic&p=4198226#4198226
Reply to the post :
http://www.jboss.com/index.html?module=bb&op=posting&mode=reply&p=4198226
_______________________________________________
jboss-user mailing list
[email protected]
https://lists.jboss.org/mailman/listinfo/jboss-user
