When using @Lob on a String-typed attribute, with a column of type text in database, I get this while fetching data (the french exception message says something like "the SybResultSet.getClob(String) method is not supported and should not have been called."):
Note: I'm currently migrating from Hibernate 3.5.3-Final to 4.1.9.Final, and everything was working fine before the upgrade. Migration guides didn't tell much about LOBs, so I changed nothing @Lob-related in my code/mapping.
As the HibernateCoreMigrationGuide36 wiki page suggested for other database systems, I tried leveraging the hibernate.jdbc.use_streams_for_binary configuration parameter, but to no avail.
This issue may be related to HHH-3691 or HHH-3892.