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: Gavin King (oneovthafew)
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 :-)
----------------------------------------------------------------------
>Comment By: Lorenzo (nicus)
Date: 2003-02-17 10:35
Message:
Logged In: YES
user_id=378537
>>> 'm trying to make it work under Hibernate2, but I've a
problem with generated SQL using the same alias more
than one time <<
>What do you mean by this?
I mean, runing Junits, Hibernate generate SQL like...
SELECT Glarc0_.tha_key as tha_key,
Glarc0_.version as version,
Glarc0_.namecvbnmasdf as namecvbnma3_, Glarc0_.next_ as
next_, Glarc0_.order_ as order_, Glarc0_.foo as foo,
Glarc0_.bar as bar, Glarc0_.immutable as immutable,
Glarc0_.version as version
FROM glarchez Glarc0_
WHERE Glarc0_.tha_key=?
.using more than one time the same alias ("version" in this
case).
After getting a burst of exceptions (the same problem with
different queries) it hangs in a db deadlock, after opening
all available connections (I'm using internal connection pool).
----------------------------------------------------------------------
Comment By: Gavin King (oneovthafew)
Date: 2003-02-15 01:24
Message:
Logged In: YES
user_id=384580
>> '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). <<
What do you mean by this?
----------------------------------------------------------------------
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:ThinkGeek
Welcome to geek heaven.
http://thinkgeek.com/sf
_______________________________________________
hibernate-devel mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/hibernate-devel
