Hello All,
I've been using hibernate with mysql for a while now with great success. I searched everywhere and could not find a solution to this problem, so thanks for any support you can provide.

I'm currently storing some data as a byte[] in an object and stored in the mysql database as a blob. This was seamless with hibernate and had no issues. I need to now deal with the data as a stream as it's bad form to carry a 5mb byte[].

I added the methods to the object :
java.sql.Blob getBlob() and setBlob( java.jql.Blob)
and added the :
<property name="blob" type="binary" /> (tested with and without the type="binary")

I get the following error if I don't set the blob (would be null)
And I recreate the DB each time. I get the following error when inserting the object:
Hibernate: insert into AUDIO (bytes, name, contentType, blob) values (?, ?, ?, ?)
Exception in thread "main" org.hibernate.exception

.SQLGrammarException: could not insert: [com.polling.Audio]
Caused by: java.sql.SQLException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'blob) values (_binary'\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0\0', null, null, nul' at line 1

And I get the following error if I do set the blob with a simple: audio1.setBlob( Hibernate.createBlob( new byte[1] ) );
Exception in thread "main" java.lang.ClassCastException: org.hibernate.lob.SerializableBlob

Environment:
Windows Xp sp2
java 1.5.0_04
Mysql 5.0.20-nt
Hibernate 3.2

Thanks again for any help.

-james