Hi,

I am trying to map a "byte[]" property under Hibernate with MySQL running under the hood. I tried mapping the byte[] to type "blob" but I would get the following exception:

java.lang.ClassCastException: [B
net.sf.hibernate.type.BlobType.set(BlobType.java:27)
net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:48)
net.sf.hibernate.type.NullableType.nullSafeSet(NullableType.java:35)
net.sf.hibernate.persister.EntityPersister.dehydrate(EntityPersister.java:393)
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:527)
net.sf.hibernate.persister.EntityPersister.insert(EntityPersister.java:432)
net.sf.hibernate.impl.ScheduledIdentityInsertion.execute(ScheduledIdentityInsertion.java:29)
net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:932)
net.sf.hibernate.impl.SessionImpl.doSave(SessionImpl.java:857)
net.sf.hibernate.impl.SessionImpl.saveWithGeneratedIdentifier(SessionImpl.java:775)
net.sf.hibernate.impl.SessionImpl.save(SessionImpl.java:738)
com.tog.desktopbeautifier.AddImage.processRequest(AddImage.java:79)
com.tog.desktopbeautifier.AddImage.doGet(AddImage.java:110)
javax.servlet.http.HttpServlet.service(HttpServlet.java:743)
javax.servlet.http.HttpServlet.service(HttpServlet.java:856)

So then I mapped the property to "binary" and that worked except that I noticed it is being saved as a "varchar(255) binary" type in the database. Is that correct? Is there 255-character limit artificial? I need to store large amounts of data in this property, definately over 255 characters.

Please clarify what is the appropriate mapping to be used for byte[] under MySQL or any other database (if there is a general solution).

Thank you,
Gili

Thank you!