Bug 262251 - jpa.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition failed on WebLogic
Summary: jpa.advanced.EntityManagerJUnitTestSuite.testSequenceObjectDefinition failed ...
Status: RESOLVED FIXED
Alias: None
Product: z_Archived
Classification: Eclipse Foundation
Component: Eclipselink (show other bugs)
Version: unspecified   Edit
Hardware: PC Windows XP
: P3 normal (vote)
Target Milestone: ---   Edit
Assignee: Nobody - feel free to take it CLA
QA Contact:
URL:
Whiteboard:
Keywords: test
Depends on:
Blocks:
 
Reported: 2009-01-23 17:16 EST by Kevin Yuan CLA
Modified: 2022-06-09 10:26 EDT (History)
0 users

See Also:

Attachments
patch for the bug (4.36 KB, application/octet-stream)
2009-07-28 15:39 EDT, Kevin Yuan CLA 		no flags Details
View All 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 Kevin Yuan CLA 2009-01-23 17:16:41 EST 
This test failed on both JTA and non-JTA datasource against WebLogic Server (10.0.1/10.3).
Exception:
==========
<error message="
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Error Code: 955" type="org.eclipse.persistence.exceptions.DatabaseException">Local Exception Stack: 
Exception [EclipseLink-4002] (Eclipse Persistence Services - 1.1.0 (Build 20090114)): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object

Error Code: 955
	at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:313)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:767)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:833)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:558)
	at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:501)
	at org.eclipse.persistence.internal.sessions.AbstractSession.executeCall(AbstractSession.java:872)
	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)
Comment 1 Kevin Yuan CLA 2009-07-28 15:39:37 EDT 
Created attachment 142813 [details]
patch for the bug

Based on suggestion from James Sutherland, add "drop sequence" statement before "create sequence" within "internalTestSequenceObjectDefinition" method, still got the same issue, so will take this test out from server testing, and only let it run inside container.
Comment 2 Kevin Yuan CLA 2009-07-28 15:47:50 EDT 
Patch had been checked into MAIN, and revision is: 4746
Comment 3 Kevin Yuan CLA 2009-07-29 11:30:16 EDT 
Backport to 1.1 branch, revision is 4753.
Comment 4 Peter Krogh CLA 2009-08-26 09:46:17 EDT 
Mass update to change fixed in target.
Comment 5 Peter Krogh CLA 2009-08-26 09:48:39 EDT 
Mass update to change fixed in target.
Comment 6 Peter Krogh CLA 2009-08-26 09:53:29 EDT 
Mass update to change fixed in target.
Comment 7 Peter Krogh CLA 2009-08-26 09:55:45 EDT 
Mass update to change fixed in target.
Comment 8 Eclipse Webmaster CLA 2022-06-09 10:16:17 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink
Comment 9 Eclipse Webmaster CLA 2022-06-09 10:26:48 EDT 
The Eclipselink project has moved to Github: https://github.com/eclipse-ee4j/eclipselink