RE: [hibernate-dev] sybase
by Steve Ebersole
That or we could get these DB instances externally accessible rather
than needing VPN + tunneling + black-voodoo-magic ;)
Well, I'd need to know the test that locks up the DB (and the results
are not pushing to the CC site). The strange part is that neither of
these tests is even testing concurrent access; they (should) deal with a
single connection at a time. Is locking in Sybase so good that a
connection can block itself ;)
-----Original Message-----
From: Aleksandar Kostadinov [mailto:akostadinov@jboss.org]
Sent: Wednesday, January 24, 2007 2:21 PM
To: Steve Ebersole
Cc: hibernate-dev(a)lists.jboss.org
Subject: Re: [hibernate-dev] sybase
See answers below. btw if you are inside jboss VPN, you could run the
testsuite on the sybase db from your local computer or from one of the
QA machines.
Steve Ebersole wrote:
> Which specific test methods in the two tests you mention fail with
locking issues?
Don't know.
> Also what is the exact Sybase product and version you are using?
Adaptive Server Enterprise/12.5.2/EBF
> What is the isolation of the Sybase JDBC connections?
Default? We can add this to hibernate.properties
> -----Original Message-----
> From: Aleksandar Kostadinov [mailto:akostadinov@jboss.org]
> Sent: Wednesday, January 24, 2007 9:21 AM
> To: Steve Ebersole
> Cc: hibernate-dev(a)lists.jboss.org
> Subject: Re: [hibernate-dev] sybase
>
> Are you going to do something about sybase or leave it at least for
now?
>
> Thanks,
> Aleksandar
>
> ---------------------------------------------
> I cleaned up database again and ran the following command:
> ./build.sh
> -Djar.driver=/opt/jdbc-drivers/jConnect-6_0/classes/jconn3.jar
> -Dhibernate.test.validatefailureexpected=true junitreport
>
> The testsuite locked on these testsuites:
> org.hibernate.test.connections.SuppliedConnectionTest
> org.hibernate.test.connections.ThreadLocalCurrentSessionTest
>
> hibernate.properties contains:
> hibernate.dialect org.hibernate.dialect.SybaseDialect
> hibernate.connection.driver_class com.sybase.jdbc3.jdbc.SybDriver
> hibernate.connection.username <user>
> hibernate.connection.password <pass>
> hibernate.connection.url jdbc:sybase:Tds:dev01:4100/<db>
>
> btw. there were many failing tests
>
> Aleksandar Kostadinov wrote:
>
>
>>In the new year I could do more investigations about that. For now I
>>can only tell there are more than one.
>>
>>Steve Ebersole wrote:
>>
>>
>>>I do not have a local Sybase install against which to test. However,
>>>that would not surprise me. Can you tell me the tests during which
it
>>>locks up?
>>>
>>>-----Original Message-----
>>>From: Aleksandar Kostadinov [mailto:akostadinov@jboss.org]
>>>Sent: Friday, December 22, 2006 1:13 PM
>>>To: Steve Ebersole
>>>Cc: hibernate-dev(a)lists.jboss.org
>>>Subject: Re: [hibernate-dev] sybase
>>>
>>>Using either 6.05 or 5.5 results in locks.
>>>Are you able to run the testsuite against sybase at all?
>>>
>>>Aleksandar Kostadinov wrote:
>>>
>>>
>>>
>>>
>>>>Should I use the latest jconnect6.05 for sybase tests?
>>>>
>>>>Thanks,
>>>>Aleksandar
>>>>_______________________________________________
>>>>hibernate-dev mailing list
>>>>hibernate-dev(a)lists.jboss.org
>>>>https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>>>
>>>>
>>>>
>>>>
>>>
>>>
>>>
>>
>>----------------------------------------------------------------------
-
>
> -
>
>>_______________________________________________
>>hibernate-dev mailing list
>>hibernate-dev(a)lists.jboss.org
>>https://lists.jboss.org/mailman/listinfo/hibernate-dev
>>
>>
>
>
17 years, 10 months