I want to store an Object in a mysql database as a blob. The table row will have 2 columns one for the PK and one for the Object. Is it a simple matter of storing the object in the database as long as the O/R mapping specifies the column to be a blob.? Or do I need to convert the Object into a java.sql.Blob type?

I have searched the forum and looked through the manual but I haven't seen anything that points me in the right direction. I will continue looking, but I would appreciate any help.

Thanks

sorry for not giving the entire syntax. i am not work. did you try SQL-TYPE attribute in mapping ?

I haven't tried anything yet. I'm trying to understand how it works first. Basically I have an object of any type. I want to store it as a blob.

I noticed that there is a Hiberbate.createBlob method but it is unclear as to when one would call this, before the insert or after the retrieve.

I found out my answer so never mind.