Hi all,
I'm still seeing test failures on clean database(Derby).
Sequence tables are not created on clean database. This is because ddl
generation has stopped in adding constraints like below.
[TopLink Warning]:
ServerSession(4018505)--Thread(Thread[main,5,main])--Exception
[TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Constraint 'CMP3SCIENTISTCBEID'
is invalid: there is no unique or primary key constraint on table '
APP.CMP3_CUBICLE' that matches the number and types of the columns in the
foreign key.Error Code: -1
Call:ALTER TABLE CMP3_SCIENTIST ADD CONSTRAINT CMP3SCIENTISTCBEID FOREIGN
KEY (CUBE_ID) REFERENCES CMP3_CUBICLE (ID)
Query:DataModifyQuery()
[TopLink Finest]: ServerSession(4018505)--Thread(Thread[main,5,main])--end
deploying Persistence Unit default; state Deployed; deploymentCount 1
As you know, there is a bug in ddl generation for foreign key constraints of
a composite key (Issue#1072) so the above foreign key constraint is wrongly
generated (I'm looking into this issue).
To ignore constraint generation failures and continue, I modified last lines
of TableCreator.replaceTablesAndConstraints() as follows:
for (Enumeration enumtr = getTableDefinitions().elements();
enumtr.hasMoreElements();) {
try {
schemaManager.createConstraints
((TableDefinition)enumtr.nextElement());
} catch
(oracle.toplink.essentials.exceptions.DatabaseExceptiondbE) {
//ignore
}
}
Then, another hidden problems occured. Please see below logs.
If you know any solution, please let me know.
Another constraint failure:
[TopLink Warning]:
ServerSession(32613288)--Thread(Thread[main,5,main])--Exception
[TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: 'BUYER_NAME' cannot be a column
of a primary key or unique key because it can contain null values.ErrorCode: -1
Call:ALTER TABLE CMP3_BUYER ADD CONSTRAINT UNQ_CMP3_BUYER_0 UNIQUE
(BUYER_ID, BUYER_NAME)
Query:DataModifyQuery()
Violations of foreign key constraint:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ'
caused a violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key
(56). The statement has been rolled back.Error Code: -1
Call:INSERT INTO CMP3_EMP_PROJ (projects_PROJ_ID, EMPLOYEES_EMP_ID) VALUES
(?, ?)
bind => [2, 56]
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(
AbstractSession.java:675)
at
oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall
(IsolatedClientSession.java:135)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect
(StatementQueryMechanism.java:129)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(
DatabaseQuery.java:536)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery
(UnitOfWorkImpl.java:2219)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.insertAddedObjectEntry(
ManyToManyMapping.java:693)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent
(ManyToManyMapping.java:891)
at
oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet
(CommitManager.java:199)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet
(AbstractSession.java:2638)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(
UnitOfWorkImpl.java:1030)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase
(RepeatableWriteUnitOfWork.java:357)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet
(UnitOfWorkImpl.java:1112)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork
(RepeatableWriteUnitOfWork.java:82)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(
UnitOfWorkImpl.java:842)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit
(EntityTransactionImpl.java:90)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit
(EntityTransactionImpl.java:45)
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadeMergeDetached
(EntityManagerJUnitTestSuite.java:2619)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(
JUnitTestRunner.java:297)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(
JUnitTestRunner.java:672)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(
JUnitTestRunner.java:567)
Caused by: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ' caused a
violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key (56). The
statement has been rolled back.
...
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ'
caused a violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key
(58). The statement has been rolled back.Error Code: -1
Call:INSERT INTO CMP3_EMP_PROJ (projects_PROJ_ID, EMPLOYEES_EMP_ID) VALUES
(?, ?)
bind => [3, 58]
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(
AbstractSession.java:675)
at
oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall
(IsolatedClientSession.java:135)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect
(StatementQueryMechanism.java:129)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(
DatabaseQuery.java:536)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery
(UnitOfWorkImpl.java:2219)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.insertAddedObjectEntry(
ManyToManyMapping.java:693)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent
(ManyToManyMapping.java:891)
at
oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet
(CommitManager.java:199)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet
(AbstractSession.java:2638)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(
UnitOfWorkImpl.java:1030)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase
(RepeatableWriteUnitOfWork.java:357)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet
(UnitOfWorkImpl.java:1112)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork
(RepeatableWriteUnitOfWork.java:82)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(
UnitOfWorkImpl.java:842)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit
(EntityTransactionImpl.java:90)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit
(EntityTransactionImpl.java:45)
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadeMergeManaged
(EntityManagerJUnitTestSuite.java:2689)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(
JUnitTestRunner.java:297)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(
JUnitTestRunner.java:672)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(
JUnitTestRunner.java:567)
Caused by: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ' caused a
violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key (58). The
statement has been rolled back.
...
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ'
caused a violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key
(59). The statement has been rolled back.Error Code: -1
Call:INSERT INTO CMP3_EMP_PROJ (projects_PROJ_ID, EMPLOYEES_EMP_ID) VALUES
(?, ?)
bind => [5, 59]
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeCall(
AbstractSession.java:675)
at
oracle.toplink.essentials.internal.sessions.IsolatedClientSession.executeCall
(IsolatedClientSession.java:135)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.internal.queryframework.StatementQueryMechanism.executeNoSelect
(StatementQueryMechanism.java:129)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.queryframework.DatabaseQuery.executeInUnitOfWork(
DatabaseQuery.java:536)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.internalExecuteQuery
(UnitOfWorkImpl.java:2219)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.insertIntoRelationTable
(ManyToManyMapping.java:737)
at
oracle.toplink.essentials.mappings.ManyToManyMapping.performDataModificationEvent
(ManyToManyMapping.java:887)
at
oracle.toplink.essentials.internal.sessions.CommitManager.commitAllObjectsWithChangeSet
(CommitManager.java:199)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet
(AbstractSession.java:2638)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabase(
UnitOfWorkImpl.java:1030)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitToDatabase
(RepeatableWriteUnitOfWork.java:357)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet
(UnitOfWorkImpl.java:1112)
at
oracle.toplink.essentials.internal.ejb.cmp3.base.RepeatableWriteUnitOfWork.commitRootUnitOfWork
(RepeatableWriteUnitOfWork.java:82)
at
oracle.toplink.essentials.internal.sessions.UnitOfWorkImpl.commitAndResume(
UnitOfWorkImpl.java:842)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.commit
(EntityTransactionImpl.java:90)
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.EntityTransactionImpl.commit
(EntityTransactionImpl.java:45)
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadePersistToNonEntitySubclass
(EntityManagerJUnitTestSuite.java:2713)
at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
at sun.reflect.NativeMethodAccessorImpl.invoke(
NativeMethodAccessorImpl.java:39)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(
DelegatingMethodAccessorImpl.java:25)
at java.lang.reflect.Method.invoke(Method.java:585)
at junit.framework.TestCase.runTest(TestCase.java:154)
at junit.framework.TestCase.runBare(TestCase.java:127)
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.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.framework.TestResult.runProtected(TestResult.java:124)
at junit.extensions.TestSetup.run(TestSetup.java:23)
at junit.framework.TestSuite.runTest(TestSuite.java:208)
at junit.framework.TestSuite.run(TestSuite.java:203)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.run(
JUnitTestRunner.java:297)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.launch(
JUnitTestRunner.java:672)
at org.apache.tools.ant.taskdefs.optional.junit.JUnitTestRunner.main(
JUnitTestRunner.java:567)
Caused by: java.sql.SQLException: INSERT on table 'CMP3_EMP_PROJ' caused a
violation of foreign key constraint 'CMP3MPPRJMPLYSMPID' for key (59). The
statement has been rolled back.
...
Testcase: testCascadeMergeDetached took 0.127 sec
Caused an ERROR
Exception Description: No transaction is currently active
java.lang.IllegalStateException:
Exception Description: No transaction is currently active
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.rollback
(EntityTransactionImpl.java:125)
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadeMergeDetached
(EntityManagerJUnitTestSuite.java:2621)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testCascadeMergeManaged took 0.078 sec
Caused an ERROR
Exception Description: No transaction is currently active
java.lang.IllegalStateException:
Exception Description: No transaction is currently active
at
oracle.toplink.essentials.internal.ejb.cmp3.transaction.base.EntityTransactionImpl.rollback
(EntityTransactionImpl.java:125)
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadeMergeManaged
(EntityManagerJUnitTestSuite.java:2691)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Testcase: testCascadePersistToNonEntitySubclass took 0.034 sec
FAILED
Persist operation was not cascaded to related non-entity.
junit.framework.AssertionFailedError: Persist operation was not cascaded to
related non-entity.
at
oracle.toplink.essentials.testing.tests.cmp3.advanced.EntityManagerJUnitTestSuite.testCascadePersistToNonEntitySubclass
(EntityManagerJUnitTestSuite.java:2718)
at junit.extensions.TestDecorator.basicRun(TestDecorator.java:22)
at junit.extensions.TestSetup$1.protect(TestSetup.java:19)
at junit.extensions.TestSetup.run(TestSetup.java:23)
...
Create table failures in setUp(): this is because drop table has failed
before...
[TopLink Warning]:
ServerSession(32613288)--Thread(Thread[main,5,main])--Exception
[TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build ${build_id})):
oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Operation 'DROP CONSTRAINT'
cannot be performed on object 'SQL061025100612710' because CONSTRAINT
'CMP3RDRCSTMRCUSTID' is dependent on that object. SQLSTATE: X0Y25: Operation
'DROP CONSTRAINT' cannot be performed on object 'SQL061025100612710' because
CONSTRAINT 'CMP3RBLLDCSTMRCSTD' is dependent on that object.Error Code: -1
Call:DROP TABLE CMP3_CUSTOMER
Query:DataModifyQuery()
Testcase: testgetReference took 0.085 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.EMQueryJUnitTestSuite.setUp
(EMQueryJUnitTestSuite.java:53)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
...
Testcase: testcreateNativeQuery took 0.054 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.EMQueryJUnitTestSuite.setUp
(EMQueryJUnitTestSuite.java:53)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
...
Testcase: testcreateNativeQueryWithSelectSQL took 0.06 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.EMQueryJUnitTestSuite.setUp
(EMQueryJUnitTestSuite.java:53)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
...
Testcase: testNativeNamedQuery took 0.047 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.EMQueryJUnitTestSuite.setUp
(EMQueryJUnitTestSuite.java:53)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
...
Testcase: testSetParameterUsingNull took 0.049 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.EMQueryJUnitTestSuite.setUp
(EMQueryJUnitTestSuite.java:53)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
...
Testcase: testLeftTrimWithTrimChar took 0.042 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.setUp
(ExpressionJUnitTestSuite.java:50)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
Testcase: testTrimWithTrimChar took 0.218 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.setUp
(ExpressionJUnitTestSuite.java:50)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
Testcase: testTrimWithoutTrimChar took 0.045 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.setUp
(ExpressionJUnitTestSuite.java:50)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
Testcase: testLocateWithSingleArgument took 0.042 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.setUp
(ExpressionJUnitTestSuite.java:50)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
Testcase: testLocateWithDoubleArgument took 0.049 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.relationships.ExpressionJUnitTestSuite.setUp
(ExpressionJUnitTestSuite.java:50)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
Testcase: unknown took 0 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT NULL,
NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.ejb.ejbqltesting.JUnitEJBQLExamplesTestSuite$1.setUp
(JUnitEJBQLExamplesTestSuite.java:119)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: Table/View 'CMP3_CUSTOMER' already exists
in Schema 'APP'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:632)
... 29 more
Caused by: org.apache.derby.client.am.SqlException: Table/View
'CMP3_CUSTOMER' already exists in Schema 'APP'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
... 31 more
Testcase: unknown took 0 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_XML_EMPLOYEE'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME
VARCHAR(40), L_NAME VARCHAR(40), START_DATE DATE, END_DATE DATE, ADDR_ID
BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, PRIMARY KEY (EMP_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_XML_EMPLOYEE'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_EMPLOYEE (EMP_ID BIGINT NOT NULL, F_NAME
VARCHAR(40), L_NAME VARCHAR(40), START_DATE DATE, END_DATE DATE, ADDR_ID
BIGINT, MANAGER_EMP_ID BIGINT, VERSION BIGINT, PRIMARY KEY (EMP_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.xml.advanced.EntityMappingsAdvancedJUnitTestCase$1.setUp
(EntityMappingsAdvancedJUnitTestCase.java:71)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: Table/View 'CMP3_XML_EMPLOYEE' already
exists in Schema 'APP'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:632)
... 31 more
Caused by: org.apache.derby.client.am.SqlException: Table/View
'CMP3_XML_EMPLOYEE' already exists in Schema 'APP'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
... 33 more
Testcase: unknown took 0 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View 'CMP3_XML_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT
NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View 'CMP3_XML_CUSTOMER'
already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT NOT
NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.xml.relationships.EntityMappingsRelationshipsJUnitTestCase$1.setUp
(EntityMappingsRelationshipsJUnitTestCase.java:81)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: Table/View 'CMP3_XML_CUSTOMER' already
exists in Schema 'APP'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:632)
... 31 more
Caused by: org.apache.derby.client.am.SqlException: Table/View
'CMP3_XML_CUSTOMER' already exists in Schema 'APP'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
... 33 more
Testcase: unknown took 0 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View
'CMP3_XML_MERGE_CUSTOMER' already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_MERGE_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT
NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View
'CMP3_XML_MERGE_CUSTOMER' already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_MERGE_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT
NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.xml.merge.relationships.EntityMappingsMergeRelationshipsJUnitTestCase$1.setUp
(EntityMappingsMergeRelationshipsJUnitTestCase.java:83)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: Table/View 'CMP3_XML_MERGE_CUSTOMER'
already exists in Schema 'APP'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:632)
... 33 more
Caused by: org.apache.derby.client.am.SqlException: Table/View
'CMP3_XML_MERGE_CUSTOMER' already exists in Schema 'APP'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
... 35 more
Testcase: unknown took 0 sec
Caused an ERROR
Internal Exception: java.sql.SQLException: Table/View
'CMP3_XML_INC_CUSTOMER' already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_INC_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT
NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
Local Exception Stack:
Exception [TOPLINK-4002] (Oracle TopLink Essentials - 9.1 (Build
${build_id})): oracle.toplink.essentials.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Table/View
'CMP3_XML_INC_CUSTOMER' already exists in Schema 'APP'.Error Code: -1
Call:CREATE TABLE CMP3_XML_INC_CUSTOMER (CITY VARCHAR(80), CUST_ID BIGINT
NOT NULL, NAME VARCHAR(80), CUST_VERSION BIGINT, PRIMARY KEY (CUST_ID))
Query:DataModifyQuery()
at oracle.toplink.essentials.exceptions.DatabaseException.sqlException(
DatabaseException.java:295)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:639)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeNoSelect
(DatabaseAccessor.java:688)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.basicExecuteCall
(DatabaseAccessor.java:477)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeCall
(DatabaseAccessor.java:437)
at oracle.toplink.essentials.threetier.ServerSession.executeCall(
ServerSession.java:465)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:213)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeCall
(DatasourceCallQueryMechanism.java:199)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelectCall
(DatasourceCallQueryMechanism.java:242)
at
oracle.toplink.essentials.internal.queryframework.DatasourceCallQueryMechanism.executeNoSelect
(DatasourceCallQueryMechanism.java:222)
at
oracle.toplink.essentials.queryframework.DataModifyQuery.executeDatabaseQuery
(DataModifyQuery.java:71)
at oracle.toplink.essentials.queryframework.DatabaseQuery.execute(
DatabaseQuery.java:609)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.internalExecuteQuery
(AbstractSession.java:1815)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:937)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeQuery(
AbstractSession.java:894)
at
oracle.toplink.essentials.internal.sessions.AbstractSession.executeNonSelectingCall
(AbstractSession.java:696)
at
oracle.toplink.essentials.tools.schemaframework.DatabaseObjectDefinition.createOnDatabase
(DatabaseObjectDefinition.java:90)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.createObject(
SchemaManager.java:153)
at
oracle.toplink.essentials.tools.schemaframework.SchemaManager.replaceObject(
SchemaManager.java:760)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTablesAndConstraints
(TableCreator.java:251)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:203)
at
oracle.toplink.essentials.tools.schemaframework.TableCreator.replaceTables(
TableCreator.java:195)
at
oracle.toplink.essentials.testing.tests.cmp3.xml.merge.incompletemappings.nonowning.EntityMappingsIncompleteNonOwningJUnitTestCase$1.setUp
(EntityMappingsIncompleteNonOwningJUnitTestCase.java:79)
at junit.extensions.TestSetup$1.protect(TestSetup.java:18)
at junit.extensions.TestSetup.run(TestSetup.java:23)
Caused by: java.sql.SQLException: Table/View 'CMP3_XML_INC_CUSTOMER' already
exists in Schema 'APP'.
at org.apache.derby.client.am.SQLExceptionFactory.getSQLException(Unknown
Source)
at org.apache.derby.client.am.SqlException.getSQLException(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown
Source)
at
oracle.toplink.essentials.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect
(DatabaseAccessor.java:632)
... 33 more
Caused by: org.apache.derby.client.am.SqlException: Table/View
'CMP3_XML_INC_CUSTOMER' already exists in Schema 'APP'.
at org.apache.derby.client.am.Statement.completeExecute(Unknown Source)
at org.apache.derby.client.net.NetStatementReply.parseEXCSQLSTTreply(Unknown
Source)
at org.apache.derby.client.net.NetStatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.StatementReply.readExecute(Unknown
Source)
at org.apache.derby.client.net.NetPreparedStatement.readExecute_(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.readExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown
Source)
at org.apache.derby.client.am.PreparedStatement.executeUpdateX(Unknown
Source)
... 35 more