Hi, During tearDown the below tests fails because it deletes instances of some objects that does not have fixed schema name set in the ORM. For this reason JPOX gets the default schema name and tries to delete objects from tables that are set in a different schema.
The PersistenceManagerTest.localSetUp should be overwriten to delete only classes used by these tests. derby-app-schemaAttributeClass-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 derby-app-schemaAttributeOrm-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 derby-app-schemaAttributePackage-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 derby-dsid-schemaAttributeClass-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 derby-dsid-schemaAttributeOrm-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 derby-dsid-schemaAttributePackage-junit.txt: ** Tests run: 001, Time: 005 seconds. Failures: 0, Errors: 1 1) testMakePersistent(org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistent)javax.jdo.JDOFatalException: Exception during tearDown at org.apache.jdo.tck.JDO_Test.tearDown(JDO_Test.java:329) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:251) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122) NestedThrowablesStackTrace: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT THIS.DEPARTMENT_ID,THIS.DEPTID,THIS."NAME" FROM datastoreidentity7.DEPARTMENT THIS" : Schema 'DATASTOREIDENTITY7' does not exist ERROR 42Y07: Schema 'DATASTOREIDENTITY7' does not exist at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:241) at org.jpox.store.rdbms.RDBMSManager.getStatement(RDBMSManager.java:361) at org.jpox.store.StatementText.prepareStatement(StatementText.java:204) at org.jpox.store.query.Query.getStatement(Query.java:798) at org.jpox.store.query.JDOQLQuery.performExecute(JDOQLQuery.java:520) at org.jpox.store.query.Query.executeWithMap(Query.java:1114) at org.jpox.store.query.Query.executeWithArray(Query.java:1087) at org.jpox.store.query.Query.execute(Query.java:1010) at org.apache.jdo.tck.JDO_Test.getAllObjects(JDO_Test.java:444) at org.apache.jdo.tck.JDO_Test.deleteTearDownClasses(JDO_Test.java:419) at org.apache.jdo.tck.JDO_Test.localTearDown(JDO_Test.java:341) at org.apache.jdo.tck.JDO_Test.tearDown(JDO_Test.java:308) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:251) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122) . at org.jpox.store.query.JDOQLQuery.performExecute(JDOQLQuery.java:574) at org.jpox.store.query.Query.executeWithMap(Query.java:1114) at org.jpox.store.query.Query.executeWithArray(Query.java:1087) at org.jpox.store.query.Query.execute(Query.java:1010) at org.apache.jdo.tck.JDO_Test.getAllObjects(JDO_Test.java:444) at org.apache.jdo.tck.JDO_Test.deleteTearDownClasses(JDO_Test.java:419) at org.apache.jdo.tck.JDO_Test.localTearDown(JDO_Test.java:341) at org.apache.jdo.tck.JDO_Test.tearDown(JDO_Test.java:308) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:251) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122) FAILURES!!! Error summary: 001 error: javax.jdo.JDODataStoreException: Error executing JDOQL query "SELECT THIS.DEPARTMENT_ID,THIS.DEPTID,THIS."NAME" FROM datastoreidentity7.DEPARTMENT THIS" : Schema 'DATASTOREIDENTITY7' does not exist ERROR 42Y07: Schema 'DATASTOREIDENTITY7' does not exist at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) at org.apache.derby.impl.sql.catalog.DataDictionaryImpl.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.QueryTreeNode.getSchemaDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindTableDescriptor(Unknown Source) at org.apache.derby.impl.sql.compile.FromBaseTable.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.FromList.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.SelectNode.bindNonVTITables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bindTables(Unknown Source) at org.apache.derby.impl.sql.compile.DMLStatementNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.ReadCursorNode.bind(Unknown Source) at org.apache.derby.impl.sql.compile.CursorNode.bind(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepMinion(Unknown Source) at org.apache.derby.impl.sql.GenericStatement.prepare(Unknown Source) at org.apache.derby.impl.sql.conn.GenericLanguageConnectionContext.prepareInternalStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement20.<init>(Unknown Source) at org.apache.derby.impl.jdbc.EmbedPreparedStatement30.<init>(Unknown Source) at org.apache.derby.jdbc.Driver30.newEmbedPreparedStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at org.apache.derby.impl.jdbc.EmbedConnection.prepareStatement(Unknown Source) at com.mchange.v2.c3p0.impl.NewProxyConnection.prepareStatement(NewProxyConnection.java:241) at org.jpox.store.rdbms.RDBMSManager.getStatement(RDBMSManager.java:361) at org.jpox.store.StatementText.prepareStatement(StatementText.java:204) at org.jpox.store.query.Query.getStatement(Query.java:798) at org.jpox.store.query.JDOQLQuery.performExecute(JDOQLQuery.java:520) at org.jpox.store.query.Query.executeWithMap(Query.java:1114) at org.jpox.store.query.Query.executeWithArray(Query.java:1087) at org.jpox.store.query.Query.execute(Query.java:1010) at org.apache.jdo.tck.JDO_Test.getAllObjects(JDO_Test.java:444) at org.apache.jdo.tck.JDO_Test.deleteTearDownClasses(JDO_Test.java:419) at org.apache.jdo.tck.JDO_Test.localTearDown(JDO_Test.java:341) at org.apache.jdo.tck.JDO_Test.tearDown(JDO_Test.java:308) at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:251) at junit.framework.TestResult$1.protect(TestResult.java:106) at junit.framework.TestResult.runProtected(TestResult.java:124) at junit.framework.TestResult.run(TestResult.java:109) at junit.framework.TestCase.run(TestCase.java:118) at junit.framework.TestSuite.runTest(TestSuite.java:208) at junit.framework.TestSuite.run(TestSuite.java:203) at junit.textui.TestRunner.doRun(TestRunner.java:116) at org.apache.jdo.tck.util.BatchTestRunner.doRun(BatchTestRunner.java:107) at org.apache.jdo.tck.util.BatchTestRunner.start(BatchTestRunner.java:147) at org.apache.jdo.tck.util.BatchTestRunner.main(BatchTestRunner.java:122) . derby-dsid-schemaAttributeClass-junit.txt: ** Tests run: 001, Time: 004 seconds. Failures: 0, Errors: 1 Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified, org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable]