I am in the process of migrating from JBoss 4.2.2 with Hibernate 3 to JBoss 7 with Hibernate 4.
I use MySQL 5

The following code used to work:


where the column type is TINYBLOB

but now I get the error:

Caused by: org.hibernate.exception.DataException: Data truncation: Data too long for column 'timezone' at row 1
Caused by: com.mysql.jdbc.MysqlDataTruncation: Data truncation: Data too long for column 'timezone' at row 1

Does anyone know how to avoid this error?

As a workaround I am converting all my TINYBLOB fields to BLOB and annotating all my Number fields with:


This problem certainly seems to be a bug in hibernate as it by default chooses a field type which does not work - although it might have been caused by a change in the MySQL driver (I am now using mysql-connector-java-5.1.22-bin.jar).