[hibernate-dev] Move to H2 for tests

Here are the last in testsuite: 1) testScrollingJoinFetchesEmptyResultSet(org.hibernate.test.hql.ScrollableCollectionFetchingTest) This seems top be an error in the H2 JDBC driver. I have asked on their forum. The issue is that on an empty result set, ResultSet.next is returning true. 2) testMappedAliasStrategy(org.hibernate.test.sql.hand.query.NativeSQLQueriesTest) testFailOnNoAddEntityOrScalar(org.hibernate.test.sql.hand.query.NativeSQLQueriesTest) Not really sure. What is really perplexing is that afaict this should fail on any dialect. 3) testCastInSelect(org.hibernate.test.hql.ASTParserLoadingTest) testCustomColumnReadAndWrite(org.hibernate.test.compositeelement.CompositeElementTest) Both seem to be caused by imprecise handling of double/float values. I need to look at these more closely (unless someone gets to it before me). 4) testWithClauseFailsWithFetch(org.hibernate.test.hql.WithClauseTest) testWithClause(org.hibernate.test.hql.WithClauseTest) These both pass when I run them individually or when I run the class by itself. Need more investigation. 5) testInsert(org.hibernate.test.legacy.CustomSQLTest) testCollectionCUD(org.hibernate.test.legacy.CustomSQLTest) testCRUD(org.hibernate.test.legacy.CustomSQLTest) Again need to look more, but I think these tests are just hosed. They are supplying custom insert SQL but are specifying the native id generator while the insert string is expecting a (what appears to be VARCHAR) value. Anyway, looks like we are getting close... -- Steve Ebersole <steve(a)hibernate.org&gt; http://hibernate.org