Hibernate version: 2.1.8

Name and version of the database you are using:
MySQL 4.1.8-nt
JDBC Connector: 3.1.7

Hi,
I'm not sure whether this is a bug, and I think this is a settings problem, but I couldn't find the reason,

When I try to insert a large byte[] (which is a property of a hibernate mapped entity) only first 64k is inserted, and the rest is lost!

max_allowed_packet setting in MySQL serer is 1MB, but even a 100k file is truncated! :(

in DDL query for creating the table I've used BLOB for creating the property.

could anyone help me solve the problem!?

regards,
Amir

What is mysql type of the blob field in the db? Sounds to me like its BLOB rather than MEDIUMBLOB or LONGBLOB.
http://dev.mysql.com/doc/mysql/en/stora ... ments.html