Bug 287983 - testSetup() in JUnitJPQLComplexTestSuite failed on GlassFish against Derby
Summary: testSetup() in JUnitJPQLComplexTestSuite failed on GlassFish against Derby
Status: ASSIGNED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P4 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords: test
Depends on:
Blocks:
 
Reported: 2009-08-28 11:22 EDT by Yiping Zhao CLA
Modified: 2022-06-09 10:34 EDT (History)
3 users (show)

See Also:

Attachments
Add an attachment (proposed patch, testcase, etc.)

Note You need to log in before you can comment on or make changes to this bug.
Description Yiping Zhao CLA 2009-08-28 11:22:00 EDT 
The error looks like it's test case related, the error message is as following:

Internal Exception: java.sql.SQLException: Constraint 'XPRTCNSMXPRTCNSMRD' already exists in Schema 'ANYUSER'.
Error Code: -1
Call: ALTER TABLE EXPERT_CONSUMER_RECORDS ADD CONSTRAINT XPRTCNSMXPRTCNSMRD FOREIGN KEY (EXPERT_CONSUMER_ID) REFERENCES EXPERT_CONSUMER (ID)
Query: DataModifyQuery(sql="ALTER TABLE EXPERT_CONSUMER_RECORDS ADD CONSTRAINT XPRTCNSMXPRTCNSMRD FOREIGN KEY (EXPERT_CONSUMER_ID) REFERENCES EXPERT_CONSUMER (ID)")" type="org.eclipse.persistence.exceptions.DatabaseException">Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.0.0.qualifier): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLException: Constraint 'XPRTCNSMXPRTCNSMRD' already exists in Schema 'ANYUSER'.
Error Code: -1
Call: ALTER TABLE EXPERT_CONSUMER_RECORDS ADD CONSTRAINT XPRTCNSMXPRTCNSMRD FOREIGN KEY (EXPERT_CONSUMER_ID) REFERENCES EXPERT_CONSUMER (ID)
Query: DataModifyQuery(sql="ALTER TABLE EXPERT_CONSUMER_RECORDS ADD CONSTRAINT XPRTCNSMXPRTCNSMRD FOREIGN KEY (EXPERT_CONSUMER_ID) REFERENCES EXPERT_CONSUMER (ID)")
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:323)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:785)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:851)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:574)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:517)
	at org.eclipse.persistence.sessions.server.ServerSession.executeCall(ServerSession.java:529)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:205)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:191)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelectCall(DatasourceCallQueryMechanism.java:234)
	at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeNoSelect(DatasourceCallQueryMechanism.java:214)
	at org.eclipse.persistence.queries.DataModifyQuery.executeDatabaseQuery(DataModifyQuery.java:85)
	at org.eclipse.persistence.queries.DatabaseQuery.execute(DatabaseQuery.java:670)
	at org.eclipse.persistence.internal.sessions.AbstractSession.internalExecuteQuery(AbstractSession.java:2291)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1208)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1190)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeQuery(AbstractSession.java:1150)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeNonSelectingCall(AbstractSession.java:919)
	at org.eclipse.persistence.tools.schemaframework.TableDefinition.createForeignConstraintsOnDatabase(TableDefinition.java:609)
	at org.eclipse.persistence.tools.schemaframework.SchemaManager.createForeignConstraints(SchemaManager.java:166)
	at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTablesAndConstraints(TableCreator.java:320)
	at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:248)
	at org.eclipse.persistence.tools.schemaframework.TableCreator.replaceTables(TableCreator.java:240)
	at org.eclipse.persistence.testing.tests.jpa.jpql.JUnitJPQLComplexTestSuite.testSetupComplex(JUnitJPQLComplexTestSuite.java:235)
	at org.eclipse.persistence.testing.framework.junit.JUnitTestCase.runBare(JUnitTestCase.java:379)
Comment 1 Yiping Zhao CLA 2009-08-31 10:53:16 EDT 
Note: testSetup() passed on WebLogic against Derby.
Comment 2 Peter Krogh CLA 2009-11-27 13:40:50 EST 
This bug fix did not make the cut off for 2.0.0. We are deferring the bugs to Future where we can properly sort them all together based on community votes and severity. We will then assign them accordingly to future patch sets and releases.
Comment 3 Peter Krogh CLA 2009-11-30 11:35:51 EST 
Changing the priority of the bugs that have been recently triaged to future.  Targetting them to P2 will differentiate them from the P3s that have been triaged into future earlier.
Comment 4 Eclipse Webmaster CLA 2022-06-09 10:34:27 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink