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 asked 26 Sep '12, 06:17 Arthur Hefti |
If this is urgent for you, I think you can extend Java version of SQLAnywhere10Dialect to work with SA 12. For the NHibernate side, there's a dialect Glenn Pauley has written, and here is a modified version that solves LIMIT/OFFSET problems and maps TINYINT to .NET System.Byte, if it helps. answered 28 Sep '12, 07:48 henginy |
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. answered 28 Aug '13, 15:48 Jeff Albion |
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