[hibernate-dev] Re: [Fwd: hibernate-mysql50-testsuite Build Completed With Testsuite Errors]
Aleksandar Kostadinov
akostadinov at jboss.org
Tue Dec 5 15:50:12 EST 2006
jtds guys say their driver is recommended for hibernate ;)
Only this one hangs.
It's not a problem to use the MS jdbc driver but is it necessary to run
on 2005. We now have only 2000.
Steve Ebersole wrote:
>Yes, you should use the MySQL5Dialect...
>
>For SQLServer you must:
>1) use 2005 and the correspnding MS driver (no jTDS!)
>2) use the snapshot isolation level (hibernate.connection.isolation
>4096)
>Otherwise, yes that (and others, I believe) will hang.
>
>Here are my local settings for SQLServer (2005 Express):
>hibernate.dialect org.hibernate.dialect.SQLServerDialect
>hibernate.connection.url jdbc:sqlserver://localhost:1681
>hibernate.connection.driver_class
>com.microsoft.sqlserver.jdbc.SQLServerDriver
>hibernate.connection.isolation 4096
>hibernate.connection.username hibernate
>hibernate.connection.password hibernate
>
>
>
>-----Original Message-----
>From: Aleksandar Kostadinov [mailto:akostadinov at jboss.org]
>Sent: Tuesday, December 05, 2006 2:04 PM
>To: Steve Ebersole; hibernate-dev at lists.jboss.org
>Subject: Re: [Fwd: hibernate-mysql50-testsuite Build Completed With
>Testsuite Errors]
>
>Yes. The tests run with the innodb dialect. Prabhat mentioned that there
>is a separate dialect for mysql5. Should I set it for tests on mysql
>5.0?
>
>There is a problem with the SQL server tests. EJB3LockTest freezes
>things until build timeout comes. Is it possible to set per test
>timeouts so a single test cannot break the whole build? Or say if any
>test/testcase takes longer than a minute then fail it and continue?
>
>EJB3LockTest should be disabled or repaired so I can enable regular
>SQLserver tests.
>
>Thanks.
>
>Steve Ebersole wrote:
>
>
>
>>Another question. Did you create this with InnoDB as the default
>>engine? If not, please do so. Running with MyISAM is not an accurate
>>representation of a valid production environment.
>>
>>Thanks.
>>
>>-----Original Message-----
>>From: Aleksandar Kostadinov [mailto:akostadinov at jboss.org]
>>Sent: Sunday, December 03, 2006 6:18 AM
>>To: hibernate-dev at lists.jboss.org; Steve Ebersole
>>Subject: [Fwd: hibernate-mysql50-testsuite Build Completed With
>>Testsuite Errors]
>>
>>As failings with mysql 5.0.27 are similar to these of 4.1.22 I consider
>>results are consistent.
>>
>>Please contact me if you don't agree.
>>
>>
>>
>>
More information about the hibernate-dev
mailing list