help!

My databaes field is varchar(2048) in length. Everything work excepting when I retrieve. The value of the string is truncated to 255 characters though the value in the database is more than 255 characters.

Is there any particulare settings that I need to do to retrieve fields that have more than 255 characters.

I tried adding the length, sql-type attributes to the properties/column tags. Still get the 255 characters max. Not sure how to proceed.

Hibernate version:
Hibernate 2.x

Mapping documents:
<property name="description">
<column name="DESCRIPTION" />
</property>

Name and version of the database you are using:
Sybsae 12.5

try:

<property name="description">
<column name="DESCRIPTION" />
<type="string"/>
</property>

I tried your suggetion in hibernate 3.1 and 2.x both complains of invalid syntax. Expectation is <type name="description"/>

All right, found the solution.

This is nothing to do with Hibernate. I am using sybsae jconnect5.5.jar and looks like by default the data returned is only 255 characters for a string. To fix this add the "?JCONNECT_VERSION=6" to the connection URL.

Example : jdbc:sybase:Tds:hostname:3105?JCONNECT_VERSION=6

This solved my issue.