I'm managing a webapp project using Adobe Coldfusion 9.0.1 as the middleware and SA 11 (18.104.22.1681) as the database backend.
The recently released Coldfusion 9 introduced Hibernate-based ORM. It can be configured to a 'SybaseAnywhere' dialect. We are essentially using ORM for CRUD operations, not for fancy schema generation, etc.
Having read through Glenn Pauley's Differences between jConnect and the iAnywhere JDBC driver series (thanks Glenn!) we are using the latter, which we tried over odbc and without (
After much googling and asking around I still have no idea what Adobe are calling their SybaseAnywhere Hibernate dialect. They are definitely using
Now, the ORM cookie started to crumble on very basic stuff. With the initial release of Coldfusion 9, you could not map a
Then, with the new Coldfusion 9.0.1, ORM entity files failed to load altogether where SQL
To add insult to injury, SQL
As Coldfusion-based 'SybaseAnywhere' Hibernate is temperamental to say the least, we've recently tried out the Hibernate classes provided by Sybase themselves for SA 11. The good thing is that all problems seem to be gone, but we've only just started testing it.
However, as Sybase say themselves, the classes are BETA.
So, is there an authoritative Hibernate dialect for SA 11, and if yes, where?
Bonus question: Is this a good excuse to move right away to SA 12?
My apologies, I misread your original post and thought you were asking about an official NHibernate dialect (i.e. one for use with .NET); but obviously, you are requesting a Hibernate dialect (i.e. one for use with JAVA/JDBC). The SQL Anywhere Hibernate dialect that you downloaded from Sybase is authoritative and is definitely the recommended dialect for Hibernate applications connecting to SQL Anywhere.
answered 26 Jul '10, 19:05
Since you are already familiar with Glenn's blog entries, I would suggest you check out his entries on NHibernate. Have a look at:
answered 26 Jul '10, 15:32