Hi,
I am using hibernate 3.2.6.ga and SYBASE ASE 5.5 server. I have declared a field IniConfig as VARCHAR(1000) in my table. The hibernate mapping for the same is as follows:
<property
name="iniConfig"
type="java.lang.String"
column="IniConfig"
length="1000"
/>

Now if I store a string with 300 characters in DB, hibernate fetches only the first 255 characters in POJO.
However if i enter a 300 character string in my GUI, hibernate saves it completely.
This works fine if I use TEXT type for IniConfig in in my SYBASE table instead of a VARCHAR(1000). But I want to know why hibernate does this and also want to know a workaround for this instead of using text because text field has performance issues.

Thanks,
Ayush

It could also be a problem of the jdbcdriver.
To detect this, I suggest you to log the result set (when fetching the data from database)
using p6spy.
Se we can see if it is the jdbc-driver truncing the String to 255 characters or if it is Hibernate which does if afterwards.

Hi using p6spy I can see the string bring truncated in the resultset itself.
So this does confirm that the JDBC driver needs to be upgraded right?
Right now I am using jconnect 2.5.5 (com.sybase.jdbc2.jdbc.SybDriver).

Thanks,
Ayush

Yes, at least it demonstrates, that hibernate is not the cause of the problem/
As first I would look for the most recent driver.
If the problem persists, I suggest to look at the specific jdbc documentation
if there are specific parameters which can be set in relation to this limitation.

Well, yes this was solved by setting the JCONNECT_VERSION property to value "6".
As our application maintains a jdbc.properties file for jdbc configuration all i had to do is modify this line:

DB_URL=jdbc:sybase:Tds:<serverName>:<port>?JCONNECT_VERSION=6

Thanks a lot for the help mate!

Regards,
Ayush