In our application we were using Sybase 16 along with hibernate anf jconn3.jar for JDBC connectivity. we got some update issues, so we thought of migrating the jconn3.jar to jconn4.jar. Now we are facing an issue in creating tables with column type as boolean. Can anyone help us to resolve this issue. |
"Facing an issue" doesn't tell us much that might help solve the problem. Can you edit the question to show the code you're trying to use and what error code/message you are getting?
There are known issues with the Hibernate framework and jConnect (and the SQL Anywhere JDBC driver), but all known compatibility issues have been fixed in the latest versions of the software.
We have recently released the newest copies of the SQL Anywhere Hibernate dialects on to GitHub. There is a separate download for Hibernate 3.x or 4.x, and separate dialect classes provided for each SQL Anywhere version (10, 11, 12 and 16). Be sure to read the included README information on how to use the dialects (and for the version compatibility notes).
See: https://github.com/sqlanywhere/hibernate/
As Graeme mentions, we'll need a lot more information on what you're doing here in order to help more:
java -jar jconn4.jar
)dbsrv16 -v
orSELECT @@version
)org.hibernate.dialect.SQLAnywhere16Dialect
)org.hibernate.type
defined for the column?hibernate.hbm2ddl.auto
or something else?