Can anyone tell me how to insert a BLOB into a table using hibernate?

Thanks,
Shrimon.

Please Refer the same. U will find comfortable

http://www.theserverside.com/discussion ... d_id=20386

Within a Java program you can retrieve or set data from a BLOB or CLOB using the standard JDBC BLOB and CLOB interfaces. For example

Statement st = conn.createStatement();
ResultSet rs = st.executeQuery("SELECT MyCLOB,MyBLOB FROM MyTable");
rs.next(); // fetch the Blob/Clob

java.sql.Clob clob = rs.getClob(1);
java.sql.Blob blob = rs.getBlob(2);

// Length
System.out.println("Clob length = " + clob.length());
System.out.println("Blob length = " + blob.length());


------------------------------------------

Please Refer the same. U will find comfortable

http://www.theserverside.com/discussion ... d_id=20386[/quote]

Thanks for your reply.

But how do you insert a blob using hibernate?


Thanks
Shrimon.

You need to create a CustomUserType - try looking at how Spring does it (www.springframework.org) - you can take or reimplement the Blob user type from there to work in your project. Note also if you're using Oracle that Oracle has some special considerations wrt Blobs.