Patches item #686507, was opened at 2003-02-14 13:05 You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=686507&group_id=40712
Category: None Group: None Status: Open Resolution: None Priority: 5 Submitted By: Lorenzo (nicus) Assigned to: Nobody/Anonymous (nobody) Summary: Sybase Anywhere support (v. 1.2.x only) Initial Comment: The attached Dialect (for Hibernate 1.2.3) supports Sybase Adaptive Server Anywhere database engine. This engine is similar to his brother Sybase Adaptive Server Enterprise, but not identical. ------8<----------------8<----------------8<---------- Connection properties ## Sybase Anywhere hibernate.dialect cirrus.hibernate.sql.SybaseAnywhereDialect hibernate.connection.driver_class com.sybase.jdbc2.jdbc.SybDriver hibernate.connection.username DBA hibernate.connection.password SQL hibernate.connection.url jdbc:sybase:Tds:127.0.0.1:2638 hibernate.connection.literal_params true ------8<----------------8<----------------8<---------- Timestamp compatibility If you want a compatible behavior using timestamp fields you have to set these Database Options (in ASA DB): default_timestamp_increment = 10000 truncate_timestamp_values = On This is due to a known Sybase JDBC strange behavior truncating timestamps. If you are not using timestamp based optimistic locking (recommended) you do NOT need setting any special option. ------8<----------------8<----------------8<---------- Passing JUnit test set With the new Dialec and setting db options it will pass all 1.2.3 JUnits except FooBarTest. In this test there is a query using multiple distinct aggregate SQL functions not sypported by ASA. If you comment out the single query... "select count(distinct child.id), count(distinct parent.id) from parent in class cirrus.hibernate.test.Foo, child in class cirrus.hibernate.test.Foo where parent.foo = child" ..it will pass this test too. ------8<----------------8<----------------8<---------- Hibernate 2 support I'm trying to make it work under Hibernate2, but I've a problem with generated SQL using the same alias more than one time (any suggestion is welcome). ------8<----------------8<----------------8<---------- Sybase Anyhwere versions I've tested it using Sybase ASA 8.0.3 under Win32, using JConnect 5.5 jdbc driver, latest EBF) There should be no reason for not working under ASA v.7.x but beware of earlier buggy JConnect versions :-) ---------------------------------------------------------------------- You can respond by visiting: https://sourceforge.net/tracker/?func=detail&atid=428710&aid=686507&group_id=40712 ------------------------------------------------------- This SF.NET email is sponsored by: FREE SSL Guide from Thawte are you planning your Web Server Security? Click here to get a FREE Thawte SSL guide and find the answers to all your SSL security issues. http://ads.sourceforge.net/cgi-bin/redirect.pl?thaw0026en _______________________________________________ hibernate-devel mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/hibernate-devel
