Return-Path: Delivered-To: apmail-db-jdo-dev-archive@www.apache.org Received: (qmail 77859 invoked from network); 30 Apr 2006 13:40:11 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 30 Apr 2006 13:40:11 -0000 Received: (qmail 3441 invoked by uid 500); 30 Apr 2006 13:40:11 -0000 Mailing-List: contact jdo-dev-help@db.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: jdo-dev@db.apache.org Delivered-To: mailing list jdo-dev@db.apache.org Received: (qmail 3428 invoked by uid 99); 30 Apr 2006 13:40:11 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 30 Apr 2006 06:40:11 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests= X-Spam-Check-By: apache.org Received: from [209.237.227.198] (HELO brutus.apache.org) (209.237.227.198) by apache.org (qpsmtpd/0.29) with ESMTP; Sun, 30 Apr 2006 06:40:08 -0700 Received: from brutus (localhost [127.0.0.1]) by brutus.apache.org (Postfix) with ESMTP id 6ACC67142D4 for ; Sun, 30 Apr 2006 13:39:38 +0000 (GMT) Message-ID: <28732201.1146404378434.JavaMail.jira@brutus> Date: Sun, 30 Apr 2006 13:39:38 +0000 (GMT+00:00) From: "Craig Russell (JIRA)" To: jdo-dev@db.apache.org Subject: [jira] Commented: (JDO-375) Company model tables are not fully cleaned up In-Reply-To: <27533825.1146132818847.JavaMail.jira@brutus> MIME-Version: 1.0 Content-Type: text/plain; charset=utf-8 Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N [ http://issues.apache.org/jira/browse/JDO-375?page=comments#action_12377162 ] Craig Russell commented on JDO-375: ----------------------------------- Please include the patch for CompanyModelPMClass to change IMedicalInsurance.class to MedicalInsurance.class in this fix. > Company model tables are not fully cleaned up > --------------------------------------------- > > Key: JDO-375 > URL: http://issues.apache.org/jira/browse/JDO-375 > Project: JDO > Type: Bug > Components: tck20 > Versions: JDO 2 rc1 > Reporter: Erik Bengtson > Assignee: Michael Bouschen > Fix For: JDO 2 final > Attachments: JDO-375.patch > > Tables from company model does not appear to be clean after run. > I can't say if this is a JPOX or TCK issue, because I did not dig into the issue. > On second run, exceptions are like > > 1) > > test(org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability)javax.jdo.JDODataStoreException: > > Insert request failed: INSERT INTO applicationidentity0.COMPANIES > > ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISCRIMINATOR) > > VALUES (?,?,?,?,?,?,?,?,?,?) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:393) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.createObjects(GetExtentWithInstancesMadePersistentViaReachability.java:72) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.test(GetExtentWithInstancesMadePersistentViaReachability.java:63) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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: > > ERROR 23505: The statement was aborted because it would have caused a duplicate > > key value in a unique or primary key constraint or unique index identified by > > 'COMPS_PK' defined on 'COMPANIES'. > > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > > Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) > > at > > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:911) > > at > > org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPreparedStatement.java:212) > > at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:267) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.createObjects(GetExtentWithInstancesMadePersistentViaReachability.java:72) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithInstancesMadePersistentViaReachability.test(GetExtentWithInstancesMadePersistentViaReachability.java:63) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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) > > 2) > > test(org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses)javax.jdo.JDODataStoreException: > > Insert request failed: INSERT INTO applicationidentity0.PERSONS > > (ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,FIRSTNAME,BIRTHDATE,MIDDLENAME,LASTNAME,PERSONID,DISCRIMINATOR) > > VALUES (?,?,?,?,?,?,?,?,?,?,?,?) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:393) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.createObjects(GetExtentWithSubclasses.java:86) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.test(GetExtentWithSubclasses.java:73) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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: > > ERROR 23505: The statement was aborted because it would have caused a duplicate > > key value in a unique or primary key constraint or unique index identified by > > 'EMPS_PK' defined on 'PERSONS'. > > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > > Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) > > at > > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:911) > > at > > org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPreparedStatement.java:212) > > at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:267) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.createObjects(GetExtentWithSubclasses.java:86) > > at > > org.apache.jdo.tck.api.persistencemanager.extent.GetExtentWithSubclasses.test(GetExtentWithSubclasses.java:73) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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) > > 3) > > test(org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable)javax.jdo.JDODataStoreException: > > Insert request failed: INSERT INTO applicationidentity0.COMPANIES > > ("NAME",FOUNDEDDATE,ADDRID,CITY,COUNTRY,"STATE",STREET,ZIPCODE,ID,DISCRIMINATOR) > > VALUES (?,?,?,?,?,?,?,?,?,?) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:393) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.createObjects(MakePersistentAndInstancesNotReachable.java:85) > > at > > org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.test(MakePersistentAndInstancesNotReachable.java:69) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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: > > ERROR 23505: The statement was aborted because it would have caused a duplicate > > key value in a unique or primary key constraint or unique index identified by > > 'COMPS_PK' defined on 'COMPANIES'. > > at org.apache.derby.iapi.error.StandardException.newException(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insertAndCheckDups(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.doInsert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.IndexSetChanger.insert(Unknown Source) > > at org.apache.derby.impl.sql.execute.RowChangerImpl.insertRow(Unknown Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.normalInsertCore(Unknown > > Source) > > at org.apache.derby.impl.sql.execute.InsertResultSet.open(Unknown Source) > > at org.apache.derby.impl.sql.GenericPreparedStatement.execute(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedStatement.executeStatement(Unknown Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.executeStatement(Unknown > > Source) > > at org.apache.derby.impl.jdbc.EmbedPreparedStatement.execute(Unknown Source) > > at > > com.mchange.v2.c3p0.impl.NewProxyPreparedStatement.execute(NewProxyPreparedStatement.java:911) > > at > > org.jpox.store.rdbms.ParamLoggingPreparedStatement.execute(ParamLoggingPreparedStatement.java:212) > > at org.jpox.store.rdbms.request.Request.executeUpdate(Request.java:88) > > at org.jpox.store.rdbms.request.InsertRequest.execute(InsertRequest.java:267) > > at org.jpox.store.rdbms.table.ClassTable.insert(ClassTable.java:2171) > > at org.jpox.store.StoreManager.insert(StoreManager.java:757) > > at > > org.jpox.state.StateManagerImpl.internalMakePersistent(StateManagerImpl.java:3456) > > at org.jpox.state.StateManagerImpl.makePersistent(StateManagerImpl.java:3429) > > at > > org.jpox.AbstractPersistenceManager.internalMakePersistent(AbstractPersistenceManager.java:1150) > > at > > org.jpox.AbstractPersistenceManager.makePersistent(AbstractPersistenceManager.java:1205) > > at > > org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.createObjects(MakePersistentAndInstancesNotReachable.java:85) > > at > > org.apache.jdo.tck.api.persistencemanager.lifecycle.MakePersistentAndInstancesNotReachable.test(MakePersistentAndInstancesNotReachable.java:69) > > at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) > > at > > sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) > > at > > sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) > > at org.apache.jdo.tck.JDO_Test.runBare(JDO_Test.java:237) > > 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: SQL Exception: The statement was aborted because it would have > > caused a duplicate key value in a unique or primary key constraint or unique > > index identified by 'EMPS_PK' defined on 'PERSONS'. > > 002 errors: SQL Exception: The statement was aborted because it would have > > caused a duplicate key value in a unique or primary key constraint or unique > > index identified by 'COMPS_PK' defined on 'COMPANIES'. > > derby-app-pm-junit.txt: > > ** Tests run: 099, Time: 032 seconds. Failures: 0, Errors: 3 > > Excluded tests: [org.apache.jdo.tck.enhancement.FieldAccessModified, > > org.apache.jdo.tck.enhancement.ImplementsPersistenceCapable] > > -- This message is automatically generated by JIRA. - If you think it was sent incorrectly contact one of the administrators: http://issues.apache.org/jira/secure/Administrators.jspa - For more information on JIRA, see: http://www.atlassian.com/software/jira