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

[Steve Ebersole]

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 at jboss.org] 
Sent: Tuesday, December 12, 2006 3:27 AM
To: Steve Ebersole; hibernate-dev at 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.