Please be aware that the content in SAP SQL Anywhere Forum will be migrated to the SAP Community in August and this forum will be retired.


we're looking for the SQL Anywhere 12 Java Hibernate Dialect implementation. We found the beta for 10 & 11 at ( 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%20Hefti's gravatar image

Arthur Hefti
accept rate: 0%

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.

(26 Sep '12, 16:14) Jeff Albion

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

(27 Sep '12, 01:33) 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.

permanent link

answered 28 Sep '12, 07:48

henginy's gravatar image

accept rate: 0%

edited 17 Oct '12, 07:04

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.


permanent link

answered 28 Aug '13, 15:48

Jeff%20Albion's gravatar image

Jeff Albion
accept rate: 25%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text]( "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported

Question tags:


question asked: 26 Sep '12, 06:17

question was seen: 4,631 times

last updated: 09 Feb '15, 05:48