cancel
Showing results for 
Search instead for 
Did you mean: 

Hibernate Dialect for SQL Anywhere 12

ArthurHCH
Explorer
4,990

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

jeff_albion
Advisor
Advisor
0 Kudos

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.

ArthurHCH
Explorer
0 Kudos

Hi Jeff

we found these to links, that lead to beta versions:

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

Accepted Solutions (0)

Answers (2)

Answers (2)

Former Member

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.

jeff_albion
Advisor
Advisor
0 Kudos

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.

See: https://github.com/sqlanywhere/hibernate/