java String longer than 255 chars converts to varchar(255)

loester · **Joined:** Tue May 08, 2007 10:55 am **Posts:** 5

When persisting an EJB3 entity bean "PageResult" containing a variable of type String called "pageText", the most recent version of Hibernate first creates the table "PageResult" with the column "pageText" of sql data type VARCHAR(255).

Hibernate then tries to persist a "PageResult" EJB containing a "pageText" of _more_ than 255 characters, throwing the error:

Code:

ERROR [org.hibernate.util.JDBCExceptionReporter] Data truncation: Data too long for column 'pageText' at row 1

The database used is MySql 5.0 .
The JDBC driver used is mysql-connector-java-5.0.5-bin.jar .

Any ideas on how to store a String greater than 255 chars?

Thanks in advance.

himawan · **Joined:** Sat Aug 19, 2006 6:31 pm **Posts:** 139

You can specify the length you want the column to have.

Look at this

http://www.hibernate.org/hib_docs/annot ... rty-column

loester · **Joined:** Tue May 08, 2007 10:55 am **Posts:** 5

I already tried adding the annotation @Column(lenght=5000), but a MySql column VARCHAR(255) was created.

Today I added the annotation @Column(columnDefinition="TEXT"), which indeed created the MySql pageText column with the data type TEXT. However, even with the data type TEXT, I still get the Hibernate exception

Code:

WARN [org.hibernate.util.JDBCExceptionReporter] SQL Error: 0, SQLState: 22001
09 mei 13:57 ERROR [org.hibernate.util.JDBCExceptionReporter] Data truncation: Data too long for column 'pageText' at row 1

loester · **Joined:** Tue May 08, 2007 10:55 am **Posts:** 5

Fixed the problem myself. Added the annotation @Column(columnDefinition="LONGTEXT").