Hi all,

I am using hibernate2.1.x+jboss3.0.8 with tomcat4.1.x+jdk1.4.2 in my project, but i meet a serious problem when get data from Sybase ASE 12.5.

Details:

1,Table has a column named contents, type is varchar(2048), generated from the HBM file.

...
<property column="contents" insert="true" length="2048" name="contents" not-null="false" type="string" update="true"/>
...

2,When insert a string into Sybase via hibernate, and if the length of the string is larger than 255/256bytes, only 255/256 bytes stored into DB.

3,When retrive data from that table, and if the length of the contents larger than 255/256(insert a string directly via isql console.), only 255/256 bytes retrived.

4,If I switch from Sybase to Oracle/MySQL, it works fine.

How can I solve this problem? Many thanks.

Problem has not been solved yet. Anybody suffered this problem? Is this a bug of hibernate?

had you tried using type="text" instead of "string" and remove the lenght to see what happends....