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

ALTER DATABASE is OK. We just need to make sure this shows up in your setup guide in case we need to recreate this db instance or setup another. As for the driver, I would prefer the use of the mssql driver. What's the possibility of running with both? -----Original Message----- From: Aleksandar Kostadinov [mailto:akostadinov@jboss.org] Sent: Tuesday, December 12, 2006 3:27 AM To: Steve Ebersole; hibernate-dev(a)lists.jboss.org Subject: [Fwd: hibernate-sqlserver-jtds-testsuite Build Completed With Testsuite Errors] Hi Again. I haven't received confirmation about the sql server tests from you. At the moment hibernate tests fail due to some changes not related to sqlserver so I send you a reference to the last good build: http://cruisecontrol.jboss.com/cc/buildresults/hibernate-sqlserver-jtds- testsuite?log=log20061207220047 Here is my last message again. ---------------------------------------------------- Hi. As you see I used jtds driver for this one. It doesn't support setting the transaction isolation level to snapshot, but I tunned the database this way: ALTER DATABASE cruisecontrol SET ALLOW_SNAPSHOT_ISOLATION ON; ALTER DATABASE cruisecontrol SET READ_COMMITTED_SNAPSHOT ON; This should set the default isolation level to snapshot. When I ran the tests with the MS jdbc driver I got one more error than with the jdts driver. It is org.hibernate.test.legacy.MasterDetailTest.testCachedCollectionRefresh. But I'm not sure in the results as the cruisecontrol builds give half the errors of these I've got from the mentioned tests. So to conclude see if you see the results consistent with your local tests. I'll modify the build if you do not like the jtds driver or something else.