[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: >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@jboss.org] >Sent: Sunday, December 03, 2006 6:18 AM >To: hibernate-dev(a)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. > > > >