Hi. As you see I used jtds driver for this one. It doesn't support setting the transaction isolation level to snapshot, but I tuned 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 runned 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 cruesecintrol 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.
--- Begin Message --- View results here -> http://cruisecontrol.jboss.com/cc/buildresults/hibernate-sqlserver-jtds-testsuite?log=log20061207113515
TESTS FAILED Ant Error Message: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:120: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-hibernate-db-matrix.xml:83: The following error occurred while executing this line: /home/cruisecontrol/work/scripts/build-common-targets.xml:11: Build Successful - Tests completed with errors or failures. Date of build: 12/07/2006 11:35:15 Time to build: 10 minutes 39 seconds Last changed: 12/31/2005 20:44:14 Last log entry: less noisy
Unit Tests: (953) Total Errors and Failures: (8)
testOnCascadeDelete org.hibernate.test.legacy.FooBarTest testReturnPropertyComponentRename org.hibernate.test.legacy.SQLLoaderTest testManyToManyPropertyRef org.hibernate.test.propertyref.basic.PropertyRefTest testUnionSubclass org.hibernate.test.unionsubclass2.UnionSubclassTest testImplicitJoinsInDifferentClauses org.hibernate.test.hql.ASTParserLoadingTest testExpressionWithParamInFunction org.hibernate.test.hql.HQLTest testConcatenation org.hibernate.test.hql.HQLTest testJoinFetchPropertyRef org.hibernate.test.propertyref.basic.PropertyRefTest
Modifications since last build: (first 50 of 2384) 10945 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/WithClauseTest.java specialized InvalidWithClauseException 10945 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/HqlSqlWalker.java specialized InvalidWithClauseException 10945 added [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/InvalidWithClauseException.java specialized InvalidWithClauseException 10943 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/ASTParserLoadingTest.java removed FailureExpected 10941 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/CrazyIdFieldNames.hbm.xml test failures - shallow + implicit joins 10941 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/ASTParserLoadingTest.java test failures - shallow + implicit joins 10941 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/HQLTest.java test failures - shallow + implicit joins 10941 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/tree/DotNode.java test failures - shallow + implicit joins 10939 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/jdbc/ConnectionManager.java bug in borrowed connection releasing 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/dialect/Dialect.java HHH-2221 : MySQL and temporary table creation 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/dialect/MySQLDialect.java HHH-2221 : MySQL and temporary table creation 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/TestCase.java HHH-2221 : MySQL and temporary table creation 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/dialect/Cache71Dialect.java HHH-2221 : MySQL and temporary table creation 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/exec/AbstractStatementExecutor.java HHH-2221 : MySQL and temporary table creation 10936 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/BulkManipulationTest.java HHH-2221 : MySQL and temporary table creation 10933 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/tree/DotNode.java (follow-on) HHH-2257 : implicit joins and shallow queries 10932 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/HQLTest.java HHH-2284 : HQL + sub-component references 10932 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/ComponentContainer.java HHH-2284 : HQL + sub-component references 10932 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/ComponentContainer.hbm.xml HHH-2284 : HQL + sub-component references 10932 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/tree/DotNode.java HHH-2284 : HQL + sub-component references 10932 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/QueryTranslatorTestCase.java HHH-2284 : HQL + sub-component references 10930 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/ASTParserLoadingTest.java HHH-2257 : implicit joins and shallow queries 10930 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/hql/ast/tree/DotNode.java HHH-2257 : implicit joins and shallow queries 10930 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/hql/QueryTranslatorTestCase.java HHH-2257 : implicit joins and shallow queries 10928 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/PropertyRefSuite.java oops! 10927 modified [EMAIL PROTECTED] //trunk/Hibernate3/src/org/hibernate/mapping/PersistentClass.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10924 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/jpa/ql/JPAQLComplianceTest.java additional test query 10923 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/Person.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10923 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/Person.hbm.xml HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10923 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/Group.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10923 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/PropertyRefTest.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10922 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/AllTests.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/Account.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/joined/BankAccount.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/joined/Account.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/basic/PropertyRefTest.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/component/complete/Identity.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/union HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/component/complete/Account.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/discrim HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 deleted [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/joineduid HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 modified [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/AllTests.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/basic/Person.hbm.xml HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/joined/Person.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/component/partial/Mapping.hbm.xml HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/basic/Group.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/component/partial HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/component/partial/PartialComponentPropertyRefTest.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/union/UnionSubclassPropertyRefTest.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests 10920 added [EMAIL PROTECTED] //trunk/Hibernate3/test/org/hibernate/test/propertyref/inheritence/union/Account.java HHH-2282 : PersistentClass propetty lookups and embedded composite identifiers;consolidate property-ref tests
--- End Message ---
_______________________________________________ hibernate-dev mailing list hibernate-dev@lists.jboss.org https://lists.jboss.org/mailman/listinfo/hibernate-dev