gloeglm wrote:
Well, this is just a warning - are you actually getting test case failures because of not having a container?
No, it looks like I'm not getting failures due to not running in container with JNDI. I'm beginning to get it that legitimate test results may be obtained when running outside of a container and without JNDI.
At this point when running iSeries DB2 (DB2400Dialect) and AllTests I have 14 errors and 8 failures out of 187 tests. I'm going to look into this further.
Thanks for the responses. FYI, here is summary of AllTests.
There were 14 errors:
1) testQueryLockMode(org.hibernate.test.FooBarTest)net.sf.hibernate.NonUniqueResultException: query did not return a unique result: 64
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:514)
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:505)
at org.hibernate.test.FooBarTest.testQueryLockMode(FooBarTest.java:1110)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
2) testListRemove(org.hibernate.test.FooBarTest)net.sf.hibernate.JDBCException: could not delete: [org.hibernate.test.Fee#4028814bfa0a429800fa0a5616ce01d8]
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:645)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java(Compiled Code))
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2264)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2185)
at org.hibernate.test.FooBarTest.testListRemove(FooBarTest.java:966)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0532] Delete prevented by referential constraint FK300C6DBDE28AFF in $MYTESTLIB.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:533)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java(Compiled Code))
at net.sf.hibernate.impl.NonBatchingBatcher.addToBatch(NonBatchingBatcher.java(Compiled Code))
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:626)
... 21 more
3) testUpdate(org.hibernate.test.FooBarTest)net.sf.hibernate.JDBCException: could not delete: [org.hibernate.test.Glarch#4028814bfa0a429800fa0a56c2dd01e3]
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:645)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java(Compiled Code))
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2264)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2185)
at org.hibernate.test.FooBarTest.testUpdate(FooBarTest.java:929)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0532] Delete prevented by referential constraint FK300C6D18E87 in $MYTESTLIB.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:533)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java(Compiled Code))
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:623)
... 21 more
4) testNonlazyCollection(org.hibernate.test.FooBarTest)net.sf.hibernate.NonUniqueResultException: query did not return a unique result: 6
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:514)
at net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:322)
at org.hibernate.test.FooBarTest.testNonlazyCollection(FooBarTest.java:651)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
5) testQuery(org.hibernate.test.FooBarTest)net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1452)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1444)
at org.hibernate.test.FooBarTest.testQuery(FooBarTest.java:224)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0204] REPEAT in *LIBL type *N not found.
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
... 19 more
6) testCriteriaCollection(org.hibernate.test.FooBarTest)net.sf.hibernate.NonUniqueResultException: query did not return a unique result: 6
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:514)
at net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:322)
at org.hibernate.test.FooBarTest.testCriteriaCollection(FooBarTest.java:179)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
7) testDeleteEmpty(org.hibernate.test.ParentChildTest)net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: org.hibernate.test.MoreStuff@d1b, of class: org.hibernate.test.MoreStuff
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:37)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1879)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:68)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:215)
at net.sf.hibernate.type.ComponentType.resolveIdentifier(ComponentType.java(Compiled Code))
at net.sf.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:145)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:347)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1452)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1594)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1580)
at org.hibernate.test.ParentChildTest.testDeleteEmpty(ParentChildTest.java:830)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
8) testCircularCascade(org.hibernate.test.ParentChildTest)net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: org.hibernate.test.MoreStuff@d1b, of class: org.hibernate.test.MoreStuff
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:37)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1879)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:68)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:215)
at net.sf.hibernate.type.ComponentType.resolveIdentifier(ComponentType.java(Compiled Code))
at net.sf.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:145)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:347)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1452)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1594)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1580)
at org.hibernate.test.ParentChildTest.testCircularCascade(ParentChildTest.java:822)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
9) testClassWhere(org.hibernate.test.ParentChildTest)net.sf.hibernate.NonUniqueResultException: query did not return a unique result: 7
at net.sf.hibernate.impl.AbstractQueryImpl.uniqueElement(AbstractQueryImpl.java:514)
at net.sf.hibernate.impl.CriteriaImpl.uniqueResult(CriteriaImpl.java:322)
at org.hibernate.test.ParentChildTest.testClassWhere(ParentChildTest.java:292)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
10) testComplexCriteria(org.hibernate.test.ParentChildTest)net.sf.hibernate.JDBCException: could not delete: [org.hibernate.test.Glarch#4028814bfa0a429800fa0ae79f650277]
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:645)
at net.sf.hibernate.impl.ScheduledDeletion.execute(ScheduledDeletion.java:29)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java(Compiled Code))
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2264)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2185)
at net.sf.hibernate.transaction.JDBCTransaction.commit(JDBCTransaction.java:61)
at org.hibernate.test.ParentChildTest.testComplexCriteria(ParentChildTest.java:266)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0532] Delete prevented by referential constraint FK300C6D18E87 in $MYTESTLIB.
at com.ibm.as400.access.JDError.throwSQLException(JDError.java:533)
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonExecute(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.executeUpdate(AS400JDBCPreparedStatement.java(Compiled Code))
at net.sf.hibernate.persister.EntityPersister.delete(EntityPersister.java:623)
... 22 more
11) testProxyReuse(org.hibernate.test.ParentChildTest)net.sf.hibernate.UnresolvableObjectException: No row with the given identifier exists: org.hibernate.test.MoreStuff@d1b, of class: org.hibernate.test.MoreStuff
at net.sf.hibernate.UnresolvableObjectException.throwIfNull(UnresolvableObjectException.java:37)
at net.sf.hibernate.impl.SessionImpl.internalLoad(SessionImpl.java:1879)
at net.sf.hibernate.type.ManyToOneType.resolveIdentifier(ManyToOneType.java:68)
at net.sf.hibernate.type.EntityType.resolveIdentifier(EntityType.java:215)
at net.sf.hibernate.type.ComponentType.resolveIdentifier(ComponentType.java(Compiled Code))
at net.sf.hibernate.type.ComponentType.nullSafeGet(ComponentType.java:145)
at net.sf.hibernate.loader.Loader.getKeyFromResultSet(Loader.java:347)
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1452)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1594)
at net.sf.hibernate.impl.SessionImpl.delete(SessionImpl.java:1580)
at org.hibernate.test.ParentChildTest.testProxyReuse(ParentChildTest.java:136)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
12) testBlobClob(org.hibernate.test.SQLFunctionsTest)java.lang.UnsupportedOperationException: Blobs are not cacheable
at net.sf.hibernate.type.BlobType.disassemble(BlobType.java:60)
at net.sf.hibernate.impl.CacheEntry.disassemble(CacheEntry.java(Compiled Code))
at net.sf.hibernate.impl.CacheEntry.<init>(CacheEntry.java:27)
at net.sf.hibernate.impl.ScheduledInsertion.execute(ScheduledInsertion.java:32)
at net.sf.hibernate.impl.SessionImpl.executeAll(SessionImpl.java(Compiled Code))
at net.sf.hibernate.impl.SessionImpl.execute(SessionImpl.java:2259)
at net.sf.hibernate.impl.SessionImpl.flush(SessionImpl.java:2185)
at org.hibernate.test.SQLFunctionsTest.testBlobClob(SQLFunctionsTest.java:420)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
13) testSQLFunctions(org.hibernate.test.SQLFunctionsTest)net.sf.hibernate.JDBCException: Could not execute query
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1476)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1452)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1444)
at org.hibernate.test.SQLFunctionsTest.testSQLFunctions(SQLFunctionsTest.java:277)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0204] REPEAT in *LIBL type *N not found.
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.hql.QueryTranslator.list(QueryTranslator.java:983)
at net.sf.hibernate.impl.SessionImpl.find(SessionImpl.java:1473)
... 19 more
14) testFindBySQLStar(org.hibernate.test.SQLLoaderTest)net.sf.hibernate.JDBCException: SQLException occurred
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3631)
at net.sf.hibernate.impl.SQLQueryImpl.list(SQLQueryImpl.java:50)
at org.hibernate.test.SQLLoaderTest.testFindBySQLStar(SQLLoaderTest.java:65)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
Caused by: java.sql.SQLException: [SQL0199] Keyword SIMPLE not expected. Valid tokens: FOR WITH FETCH ORDER UNION OPTIMIZE.
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCStatement.commonPrepare(AS400JDBCStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCPreparedStatement.<init>(AS400JDBCPreparedStatement.java(Compiled Code))
at com.ibm.as400.access.AS400JDBCConnection.prepareStatement(AS400JDBCConnection.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.getPreparedStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.impl.BatcherImpl.prepareQueryStatement(BatcherImpl.java(Compiled Code))
at net.sf.hibernate.loader.Loader.prepareQueryStatement(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQuery(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java(Compiled Code))
at net.sf.hibernate.loader.Loader.list(Loader.java:918)
at net.sf.hibernate.loader.SQLLoader.list(SQLLoader.java:71)
at net.sf.hibernate.impl.SessionImpl.findBySQL(SessionImpl.java:3628)
... 18 more
There were 8 failures:
1) testAssociationId(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testAssociationId(FooBarTest.java:1851)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
2) testCollectionWhere(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testCollectionWhere(FooBarTest.java:1737)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
3) testNamedParams(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testNamedParams(FooBarTest.java:1459)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
4) testLimit(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testLimit(FooBarTest.java:1377)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
5) testSortables(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testSortables(FooBarTest.java:1022)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
6) testQueryCollectionOfValues(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testQueryCollectionOfValues(FooBarTest.java:756)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
7) testCascadeDeleteDetached(org.hibernate.test.FooBarTest)junit.framework.AssertionFailedError
at org.hibernate.test.FooBarTest.testCascadeDeleteDetached(FooBarTest.java:544)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
8) testOdmgApi(org.hibernate.test.ODMGTest)junit.framework.AssertionFailedError
at org.hibernate.test.ODMGTest.testOdmgApi(ODMGTest.java:45)
at org.hibernate.test.TestCase.runTest(TestCase.java:79)
at org.hibernate.test.AllTests.main(AllTests.java:32)
FAILURES!!!
Tests run: 187, Failures: 8, Errors: 14