[hibernate-dev] RE: [Fwd: hibernate-mysql50-testsuite Build Completed With Testsuite Errors]

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@jboss.org] Sent: Tuesday, December 05, 2006 2:04 PM To: Steve Ebersole; hibernate-dev(a)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: