how to store java bean object as a clob in DB column(using Hibernate)

Question

My Java bean looks like below public class AuditRptDTO {

private Date timestamp;
private String userId;
private String stName;
private String userType;
private String code;
private Clob oldRecord;
private Clob newRecord;
private String serverIp;

} here in place of oldRecord and newRecord i need to save another bean object. how can i achieve this in hibernate using an XML mapping.

There are two things here, saving days with Hibernate xml mappings and saving an object in a clob. Both are perfectly possible. Which one is causing you a problem? — MartinByers
– MartinByers, Commented Oct 30, 2017 at 8:34

MartinByers · Accepted Answer · 2017-10-31 09:39:23Z

1

A Simple approach is:

serialize your Object:

ByteArrayOutputStream bos = new ByteArrayOutputStream() ;
ObjectOutput out  = new ObjectOutputStream(bos) ;
out.writeObject(object);
out.close();

byte[] dataArray = bos.toByteArray();

Base 64 encode the data to get a String.

String dataString = Base64.encodeBase64String(dataArray);

Then all that s needed is to convert the String to an instance of the Clob interface, you could create your own or use an existing one.

Clob clobData = SerialClob(dataString.toCharArray());

There may be a simpler way to instantiate your Clob object, but you will definitely need to serialize your object first. I will leave t to you to see if you can improve on this.

answered Oct 31, 2017 at 9:39

MartinByers

1,2301 gold badge9 silver badges15 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Dipanshu Over a year ago

Thanks Martin for your comment on it.

Dipanshu Over a year ago

During retrieval of Clob object from DB and then when we deserialize do we need to have the type of object(class).? or This approach doesn't require to worry about actual object type while getting the data back from DB.

MartinByers Over a year ago

You will need the type in scope, but you don't have to specify it while you deserialze it. It's probably worth reading up about java serialisation, there are a few things which you may need to be aware of.

Collectives™ on Stack Overflow

how to store java bean object as a clob in DB column(using Hibernate)

1 Answer 1

3 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

3 Comments

Your Answer

Sign up or log in

Post as a guest

Related