Hi we're looking for the SQL Anywhere 12 Java Hibernate Dialect implementation. We found the beta for 10 & 11 at (http://www.sybase.com/detail?id=1057826&siteId=1). We can't use the native Hibernate implementation because of memory issues and limitations in e.g. select with limit (needed for paging). We're using Hibernate 4.1.1 final. Please advise Arthur |
We have now released 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. |
Hi Arthur,
I'm currently investigating options for you on this. For now, "LIMIT" is still implemented as
TOP
/START AT
as of the "SQLAnywhere10Dialect" and should still work for SQL Anywhere 12.Currently, sequences are not supported in the SQL Anywhere 11 dialect but are supported in the SQL Anywhere 12 database server.
Hi Jeff
we found these to links, that lead to beta versions:
http://iablog.sybase.com/paulley/2009/06/sql-anywhere-11-hibernate-dialect/#more-904
http://www.sybase.com/detail?id=1057826&siteId=1
They're for V 10 & V11 and might need changes in Hibernate 3.x code. However we want to use SA 12 and Hibernate 4.x.
Regards Arthur