Hibernate Dialect for SQL Anywhere 12

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

hibernate sa-12

asked 26 Sep '12, 06:17

Arthur Hefti
166●8●8●16
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

flat view

2 Answers:

active answers oldest answers newest answers popular answers

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
406●15●18●27
accept rate: 0%

edited 17 Oct '12, 07:04

flat view

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/

permanent link

answered 28 Aug '13, 15:48

Jeff Albion
10.8k●1●71●175
accept rate: 24%

flat view

Your answer

toggle preview

community wiki:

Follow this question

By Email:

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

By RSS:

Answers

Answers and Comments

Markdown Basics

*italic* or _italic_
**bold** or __bold__
link:[text](http://url.com/ "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

learn more about Markdown

Question tags:

sa-12 ×438
hibernate ×7

question asked: 26 Sep '12, 06:17

question was seen: 4,239 times

last updated: 09 Feb '15, 05:48

SAP SQL Anywhere

Hibernate Dialect for SQL Anywhere 12

Follow this question

Related questions