Skip to main content

Notice: this Wiki will be going read only early in 2024 and edits will no longer be possible. Please see: https://gitlab.eclipse.org/eclipsefdn/helpdesk/-/wikis/Wiki-shutdown-plan for the plan.

Jump to: navigation, search

Talk:EclipseLink/Examples/JPA/DCN

Hello. I have encountered issues running the example. I posted a full log to the EclipseLink Community Forum but it is with logging set to the FINEST level so I'm not sure it is appropriate to paste here. I have verified that the privilege is granted to FPA_DEV and the database version is 11gR2. The tables are set up in the DB. There is a warning I notice:

[java] [EL Warning]: metadata: 2012-10-30 10:36:20.172--ServerSession(19235919)--Thread(Thread[main,5,main])--You have specified multiple ids for the entity class [model.OrderLine] without specifying an @IdClass. By doing this you may lose the ability to find by identity, distributed cache support etc. Note: You may however use entity manager find operations by passing a list of primary key fields. Else, you will have to use JPQL queries to read your entities. For other id options see @PrimaryKey.

but things carry on.

Then later I get some exceptions b/c the code tries to recreate tables. I'm not clear if that is having some affect on these following types of items or not:

[java] [EL Finest]: connection: 2012-10-30 10:39:54.489--ServerSession(1636997)--Thread(Thread[main,5,main])--Removing registering for database change event notification.

    [java] [EL Finest]: connection: 2012-10-30 10:39:54.583--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering for database change event notification.
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.833--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering table [DBE_CUSTOMER] for database change event notification.

And should I be seeing some response from the DB to the above registrations?

Here is the final part of the log. Any input will be greatly appreciated.


[java] [EL Info]: 2012-10-30 10:39:47.02--ServerSession(1636997)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.4.0.v20120608-r11652

    [java] [EL Finest]: dbPlatformHelper_regExprDbPlatform: 2012-10-30 10:39:49.004--Thread(Thread[main,5,main])--(?i)oracle.*11 (There is no English translation for this message.)
    [java] [EL Fine]: connection: 2012-10-30 10:39:49.004--Thread(Thread[main,5,main])--Detected database platform: org.eclipse.persistence.platform.database.oracle.Oracle11Platform
    [java] [EL Config]: connection: 2012-10-30 10:39:49.192--ServerSession(1636997)--Connection(7886757)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
    [java]     platform=>Oracle11Platform
    [java]     user name=> "f"
    [java]     datasource URL=> "jdbc:oracle:thin:@scladb08.fuel..com:1521:dev"
    [java] ))
    [java] [EL Config]: connection: 2012-10-30 10:39:49.973--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@scladb08.fuel..com:1521:dev
    [java]     User: 
    [java]     Database: Oracle  Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    [java] With the Partitioning, OLAP, Data Mining and Real Application Testing options
    [java]     Driver: Oracle JDBC driver  Version: 11.2.0.3.0
    [java] [EL Finest]: connection: 2012-10-30 10:39:49.973--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.051--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:50.051--ServerSession(1636997)--Thread(Thread[main,5,main])--sequencing connected, state is Preallocation_Transaction_NoAccessor_State
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:50.051--ServerSession(1636997)--Thread(Thread[main,5,main])--sequence CUST_SEQ: preallocation size 50
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:50.051--ServerSession(1636997)--Thread(Thread[main,5,main])--sequence ORD_SEQ: preallocation size 50
    [java] [EL Info]: connection: 2012-10-30 10:39:50.051--ServerSession(1636997)--Thread(Thread[main,5,main])--order login successful
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.145--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering for database change event notification.
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.504--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering table [DBE_CUSTOMER] for database change event notification.
    [java] [EL Finest]: query: 2012-10-30 10:39:50.52--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="CREATE TABLE DBE_ORDER (ORDER_ID NUMBER(19) NOT NULL, DESCRIPTION VARCHAR2(255) NULL, TOTALCOST NUMBER(38) NULL, VERSION NUMBER(19) NULL, CUSTOMER_ID NUMBER(19) NULL, PRIMARY KEY (ORDER_ID))")
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.52--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:50.551--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--CREATE TABLE DBE_ORDER (ORDER_ID NUMBER(19) NOT NULL, DESCRIPTION VARCHAR2(255) NULL, TOTALCOST NUMBER(38) NULL, VERSION NUMBER(19) NULL, CUSTOMER_ID NUMBER(19) NULL, PRIMARY KEY (ORDER_ID))
    [java] [EL Fine]: sql: 2012-10-30 10:39:50.692--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.754--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:50.754--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
    [java]
    [java] Error Code: 955
    [java] Call: CREATE TABLE DBE_ORDER (ORDER_ID NUMBER(19) NOT NULL, DESCRIPTION VARCHAR2(255) NULL, TOTALCOST NUMBER(38) NULL, VERSION NUMBER(19) NULL, CUSTOMER_ID NUMBER(19) NULL, PRIMARY KEY (ORDER_ID))
    [java] Query: DataModifyQuery(sql="CREATE TABLE DBE_ORDER (ORDER_ID NUMBER(19) NOT NULL, DESCRIPTION VARCHAR2(255) NULL, TOTALCOST NUMBER(38) NULL, VERSION NUMBER(19) NULL, CUSTOMER_ID NUMBER(19) NULL, PRIMARY KEY (ORDER_ID))")
    [java] [EL Finest]: ddl: 2012-10-30 10:39:50.754--Thread(Thread[main,5,main])--The table (DBE_ORDER) is already in the database, and wont be created.
    [java] [EL Finest]: query: 2012-10-30 10:39:50.754--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="CREATE TABLE DBE_ORDERLINE (LINENUMBER NUMBER(10) NOT NULL, COST NUMBER(38) NULL, DESCRIPTION VARCHAR2(255) NULL, ORDER_ID NUMBER(19) NOT NULL, PRIMARY KEY (LINENUMBER, ORDER_ID))")
    [java] [EL Finest]: connection: 2012-10-30 10:39:50.754--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:50.754--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--CREATE TABLE DBE_ORDERLINE (LINENUMBER NUMBER(10) NOT NULL, COST NUMBER(38) NULL, DESCRIPTION VARCHAR2(255) NULL, ORDER_ID NUMBER(19) NOT NULL, PRIMARY KEY (LINENUMBER, ORDER_ID))
    [java] [EL Fine]: sql: 2012-10-30 10:39:50.864--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:51.004--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:51.004--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
    [java]
    [java] Error Code: 955
    [java] Call: CREATE TABLE DBE_ORDERLINE (LINENUMBER NUMBER(10) NOT NULL, COST NUMBER(38) NULL, DESCRIPTION VARCHAR2(255) NULL, ORDER_ID NUMBER(19) NOT NULL, PRIMARY KEY (LINENUMBER, ORDER_ID))
    [java] Query: DataModifyQuery(sql="CREATE TABLE DBE_ORDERLINE (LINENUMBER NUMBER(10) NOT NULL, COST NUMBER(38) NULL, DESCRIPTION VARCHAR2(255) NULL, ORDER_ID NUMBER(19) NOT NULL, PRIMARY KEY (LINENUMBER, ORDER_ID))")
    [java] [EL Finest]: ddl: 2012-10-30 10:39:51.051--Thread(Thread[main,5,main])--The table (DBE_ORDERLINE) is already in the database, and wont be created.
    [java] [EL Finest]: query: 2012-10-30 10:39:51.051--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="CREATE TABLE DBE_CUSTOMER (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, PRIMARY KEY (ID))")
    [java] [EL Finest]: connection: 2012-10-30 10:39:51.051--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:51.051--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--CREATE TABLE DBE_CUSTOMER (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, PRIMARY KEY (ID))
    [java] [EL Fine]: sql: 2012-10-30 10:39:51.692--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:52.817--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:52.817--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
    [java]
    [java] Error Code: 955
    [java] Call: CREATE TABLE DBE_CUSTOMER (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, PRIMARY KEY (ID))
    [java] Query: DataModifyQuery(sql="CREATE TABLE DBE_CUSTOMER (ID NUMBER(19) NOT NULL, NAME VARCHAR2(255) NULL, VERSION NUMBER(19) NULL, PRIMARY KEY (ID))")
    [java] [EL Finest]: ddl: 2012-10-30 10:39:52.864--Thread(Thread[main,5,main])--The table (DBE_CUSTOMER) is already in the database, and wont be created.
    [java] [EL Finest]: query: 2012-10-30 10:39:52.864--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="ALTER TABLE DBE_ORDER ADD CONSTRAINT FK_DBE_ORDER_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES DBE_CUSTOMER (ID)")
    [java] [EL Finest]: connection: 2012-10-30 10:39:52.864--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:52.864--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--ALTER TABLE DBE_ORDER ADD CONSTRAINT FK_DBE_ORDER_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES DBE_CUSTOMER (ID)
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.004--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.083--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:53.083--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-02275: such a referential constraint already exists in the table
    [java]
    [java] Error Code: 2275
    [java] Call: ALTER TABLE DBE_ORDER ADD CONSTRAINT FK_DBE_ORDER_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES DBE_CUSTOMER (ID)
    [java] Query: DataModifyQuery(sql="ALTER TABLE DBE_ORDER ADD CONSTRAINT FK_DBE_ORDER_CUSTOMER_ID FOREIGN KEY (CUSTOMER_ID) REFERENCES DBE_CUSTOMER (ID)")
    [java] [EL Finest]: query: 2012-10-30 10:39:53.161--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="ALTER TABLE DBE_ORDERLINE ADD CONSTRAINT FK_DBE_ORDERLINE_ORDER_ID FOREIGN KEY (ORDER_ID) REFERENCES DBE_ORDER (ORDER_ID)")
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.161--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.161--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--ALTER TABLE DBE_ORDERLINE ADD CONSTRAINT FK_DBE_ORDERLINE_ORDER_ID FOREIGN KEY (ORDER_ID) REFERENCES DBE_ORDER (ORDER_ID)
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.317--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.473--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:53.473--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-02275: such a referential constraint already exists in the table
    [java]
    [java] Error Code: 2275
    [java] Call: ALTER TABLE DBE_ORDERLINE ADD CONSTRAINT FK_DBE_ORDERLINE_ORDER_ID FOREIGN KEY (ORDER_ID) REFERENCES DBE_ORDER (ORDER_ID)
    [java] Query: DataModifyQuery(sql="ALTER TABLE DBE_ORDERLINE ADD CONSTRAINT FK_DBE_ORDERLINE_ORDER_ID FOREIGN KEY (ORDER_ID) REFERENCES DBE_ORDER (ORDER_ID)")
    [java] [EL Finest]: query: 2012-10-30 10:39:53.567--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(sql="CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR2(50) NOT NULL, SEQ_COUNT NUMBER(38) NULL, PRIMARY KEY (SEQ_NAME))")
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.567--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.567--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR2(50) NOT NULL, SEQ_COUNT NUMBER(38) NULL, PRIMARY KEY (SEQ_NAME))
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.895--ServerSession(1636997)--Thread(Thread[main,5,main])--SELECT 1 FROM DUAL
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.942--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Warning]: 2012-10-30 10:39:53.942--ServerSession(1636997)--Thread(Thread[main,5,main])--Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.4.0.v20120608-r11652): org.eclipse.persistence.exceptions.DatabaseException
    [java] Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00955: name is already used by an existing object
    [java]
    [java] Error Code: 955
    [java] Call: CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR2(50) NOT NULL, SEQ_COUNT NUMBER(38) NULL, PRIMARY KEY (SEQ_NAME))
    [java] Query: DataModifyQuery(sql="CREATE TABLE SEQUENCE (SEQ_NAME VARCHAR2(50) NOT NULL, SEQ_COUNT NUMBER(38) NULL, PRIMARY KEY (SEQ_NAME))")
    [java] [EL Finest]: query: 2012-10-30 10:39:53.973--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataReadQuery(sql="SELECT * FROM SEQUENCE WHERE SEQ_NAME = 'ORD_SEQ'")
    [java] [EL Finest]: connection: 2012-10-30 10:39:53.973--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:53.973--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--SELECT * FROM SEQUENCE WHERE SEQ_NAME = ORD_SEQ
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.27--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: query: 2012-10-30 10:39:54.27--ServerSession(1636997)--Thread(Thread[main,5,main])--Execute query DataReadQuery(sql="SELECT * FROM SEQUENCE WHERE SEQ_NAME = 'CUST_SEQ'")
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.27--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:54.379--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--SELECT * FROM SEQUENCE WHERE SEQ_NAME = CUST_SEQ
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.489--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.489--ServerSession(1636997)--Thread(Thread[main,5,main])--Removing registering for database change event notification.
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.583--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering for database change event notification.
    [java] [EL Finest]: connection: 2012-10-30 10:39:54.833--ServerSession(1636997)--Thread(Thread[main,5,main])--Registering table [DBE_CUSTOMER] for database change event notification.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:54.833--ServerSession(1636997)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.OrderLine_] not found during initialization.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:54.833--ServerSession(1636997)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.Customer_] not found during initialization.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:54.879--ServerSession(1636997)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.Order_] not found during initialization.
    [java] [EL Finest]: jpa: 2012-10-30 10:39:54.879--ServerSession(1636997)--Thread(Thread[main,5,main])--End deploying Persistence Unit order; session order; state Deployed; factoryCount 1
    [java]
    [java]
    [java] Starting example.
    [java]
    [java]
    [java] Selecting all customer on application #2.
    [java] [EL Finest]: jpa: 2012-10-30 10:39:54.879--ServerSession(1090841)--Thread(Thread[main,5,main])--Begin deploying Persistence Unit order2; session order2; state Predeployed; factoryCount 1
    [java] [EL Finer]: 2012-10-30 10:39:54.973--ServerSession(1090841)--Thread(Thread[main,5,main])--Could not initialize Validation Factory. Encountered following exception: java.lang.NoClassDefFoundError: javax/validation/Validation
    [java] [EL Finest]: properties: 2012-10-30 10:39:54.973--ServerSession(1090841)--Thread(Thread[main,5,main])--property=eclipselink.logging.level; value=FINEST; translated value=FINEST
    [java] [EL Finest]: properties: 2012-10-30 10:39:54.973--ServerSession(1090841)--Thread(Thread[main,5,main])--property=eclipselink.logging.level; value=FINEST; translated value=FINEST
    [java] [EL Finest]: properties: 2012-10-30 10:39:55.083--ServerSession(1090841)--Thread(Thread[main,5,main])--property=javax.persistence.jdbc.user; value=fpa_dev
    [java] [EL Finest]: properties: 2012-10-30 10:39:55.083--ServerSession(1090841)--Thread(Thread[main,5,main])--property=javax.persistence.jdbc.password; value=xxxxxx
    [java] [EL Finest]: properties: 2012-10-30 10:39:55.083--ServerSession(1090841)--Thread(Thread[main,5,main])--property=javax.persistence.jdbc.driver; value=oracle.jdbc.OracleDriver
    [java] [EL Finest]: properties: 2012-10-30 10:39:55.083--ServerSession(1090841)--Thread(Thread[main,5,main])--property=javax.persistence.jdbc.url; value=jdbc:oracle:thin:@scladb08.fuel.wec.com:1521:dev
    [java] [EL Finest]: properties: 2012-10-30 10:39:55.176--ServerSession(1090841)--Thread(Thread[main,5,main])--property=eclipselink.cache.database-event-listener; value=org.eclipse.persistence.platform.database.oracle.dcn.OracleChangeNotificationListener
    [java] [EL Info]: 2012-10-30 10:39:55.176--ServerSession(1090841)--Thread(Thread[main,5,main])--EclipseLink, version: Eclipse Persistence Services - 2.4.0.v20120608-r11652
    [java] [EL Finest]: dbPlatformHelper_regExprDbPlatform: 2012-10-30 10:39:57.27--Thread(Thread[main,5,main])--(?i)oracle.*11 (There is no English translation for this message.)
    [java] [EL Fine]: connection: 2012-10-30 10:39:57.27--Thread(Thread[main,5,main])--Detected database platform: org.eclipse.persistence.platform.database.oracle.Oracle11Platform
    [java] [EL Config]: connection: 2012-10-30 10:39:57.301--ServerSession(1090841)--Connection(4751287)--Thread(Thread[main,5,main])--connecting(DatabaseLogin(
    [java]     platform=>Oracle11Platform
    [java]     user name=> ""
    [java]     datasource URL=> "jdbc:oracle:thin:@scladb08.fuel..com:1521:dev"
    [java] ))
    [java] [EL Config]: connection: 2012-10-30 10:39:58.333--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connected: jdbc:oracle:thin:@scladb08.fuel..com:1521:dev
    [java]     User: 
    [java]     Database: Oracle  Version: Oracle Database 11g Enterprise Edition Release 11.2.0.3.0 - 64bit Production
    [java] With the Partitioning, OLAP, Data Mining and Real Application Testing options
    [java]     Driver: Oracle JDBC driver  Version: 11.2.0.3.0
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.333--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.395--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:58.395--ServerSession(1090841)--Thread(Thread[main,5,main])--sequencing connected, state is Preallocation_Transaction_NoAccessor_State
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:58.395--ServerSession(1090841)--Thread(Thread[main,5,main])--sequence CUST_SEQ: preallocation size 50
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:58.395--ServerSession(1090841)--Thread(Thread[main,5,main])--sequence ORD_SEQ: preallocation size 50
    [java] [EL Info]: connection: 2012-10-30 10:39:58.411--ServerSession(1090841)--Thread(Thread[main,5,main])--order2 login successful
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.411--ServerSession(1090841)--Thread(Thread[main,5,main])--Registering for database change event notification.
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.614--ServerSession(1090841)--Thread(Thread[main,5,main])--Registering table [DBE_CUSTOMER] for database change event notification.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:58.63--ServerSession(1090841)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.OrderLine_] not found during initialization.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:58.63--ServerSession(1090841)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.Customer_] not found during initialization.
    [java] [EL Finer]: metamodel: 2012-10-30 10:39:58.708--ServerSession(1090841)--Thread(Thread[main,5,main])--Canonical Metamodel class [model.Order_] not found during initialization.
    [java] [EL Finest]: jpa: 2012-10-30 10:39:58.708--ServerSession(1090841)--Thread(Thread[main,5,main])--End deploying Persistence Unit order2; session order2; state Deployed; factoryCount 1
    [java] [EL Finer]: connection: 2012-10-30 10:39:58.708--ServerSession(1090841)--Thread(Thread[main,5,main])--client acquired: 21349396
    [java] [EL Finer]: transaction: 2012-10-30 10:39:58.708--ClientSession(21349396)--Thread(Thread[main,5,main])--acquire unit of work: 21758676
    [java] [EL Finest]: query: 2012-10-30 10:39:58.708--UnitOfWork(21758676)--Thread(Thread[main,5,main])--Execute query ReadAllQuery(referenceClass=Customer sql="SELECT ID, NAME, VERSION, ROWID FROM DBE_CUSTOMER")
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.708--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:39:58.708--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--SELECT ID, NAME, VERSION, ROWID FROM DBE_CUSTOMER
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.911--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java]
    [java]
    [java] Inserting new customer on application #1.
    [java] [EL Finer]: connection: 2012-10-30 10:39:58.911--ServerSession(1636997)--Thread(Thread[main,5,main])--client acquired: 9608099
    [java] [EL Finer]: transaction: 2012-10-30 10:39:58.911--ClientSession(9608099)--Thread(Thread[main,5,main])--acquire unit of work: 19397123
    [java] [EL Finest]: transaction: 2012-10-30 10:39:58.911--UnitOfWork(19397123)--Thread(Thread[main,5,main])--persist() operation called on: model.Customer@18ef117.
    [java] [EL Finest]: connection: 2012-10-30 10:39:58.911--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Finer]: transaction: 2012-10-30 10:39:58.911--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--begin transaction
    [java] [EL Finest]: query: 2012-10-30 10:39:58.911--ClientSession(9608099)--Thread(Thread[main,5,main])--Execute query DataModifyQuery(name="CUST_SEQ" sql="UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + #PREALLOC_SIZE WHERE SEQ_NAME = #SEQ_NAME")
    [java] [EL Fine]: sql: 2012-10-30 10:39:58.911--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--UPDATE SEQUENCE SET SEQ_COUNT = SEQ_COUNT + ? WHERE SEQ_NAME = ?
    [java]     bind => [50, CUST_SEQ]
    [java] [EL Finest]: query: 2012-10-30 10:39:59.051--ClientSession(9608099)--Thread(Thread[main,5,main])--Execute query ValueReadQuery(name="CUST_SEQ" sql="SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = #SEQ_NAME")
    [java] [EL Fine]: sql: 2012-10-30 10:39:59.051--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--SELECT SEQ_COUNT FROM SEQUENCE WHERE SEQ_NAME = ?
    [java]     bind => [CUST_SEQ]
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:59.426--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--local sequencing preallocation for CUST_SEQ: objects: 50 , first: 51, last: 100
    [java] [EL Finer]: transaction: 2012-10-30 10:39:59.426--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--commit transaction
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:59.473--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--local sequencing preallocation is copied to preallocation after transaction commit
    [java] [EL Finest]: connection: 2012-10-30 10:39:59.52--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: sequencing: 2012-10-30 10:39:59.52--UnitOfWork(19397123)--Thread(Thread[main,5,main])--assign sequence to the object (51 -> model.Customer@18ef117)
    [java] [EL Finer]: transaction: 2012-10-30 10:39:59.52--UnitOfWork(19397123)--Thread(Thread[main,5,main])--begin unit of work commit
    [java] [EL Finest]: query: 2012-10-30 10:39:59.52--UnitOfWork(19397123)--Thread(Thread[main,5,main])--Execute query InsertObjectQuery(model.Customer@18ef117)
    [java] [EL Finest]: connection: 2012-10-30 10:39:59.52--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Finer]: transaction: 2012-10-30 10:39:59.614--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--begin transaction
    [java] [EL Fine]: sql: 2012-10-30 10:39:59.614--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--INSERT INTO DBE_CUSTOMER (ID, NAME, VERSION) VALUES (?, ?, ?)
    [java]     bind => [51, Test1, 1]
    [java] [EL Finer]: transaction: 2012-10-30 10:39:59.973--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--commit transaction
    [java] [EL Finest]: connection: 2012-10-30 10:40:00.067--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finest]: query: 2012-10-30 10:40:00.067--UnitOfWork(19397123)--Thread(Thread[main,5,main])--Execute query ValueReadQuery(name="ROWID" )
    [java] [EL Finest]: connection: 2012-10-30 10:40:00.067--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:40:00.067--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--SELECT ROWID FROM DBE_CUSTOMER WHERE (ID = ?)
    [java]     bind => [51]
    [java] [EL Finest]: connection: 2012-10-30 10:40:00.223--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finer]: transaction: 2012-10-30 10:40:00.223--UnitOfWork(19397123)--Thread(Thread[main,5,main])--end unit of work commit
    [java] [EL Finer]: transaction: 2012-10-30 10:40:00.223--UnitOfWork(19397123)--Thread(Thread[main,5,main])--resume unit of work
    [java]
    [java]
    [java] Selecting new customer on application #2.
    [java] [EL Finer]: connection: 2012-10-30 10:40:01.239--ServerSession(1090841)--Thread(Thread[main,5,main])--client acquired: 21711674
    [java] [EL Finer]: transaction: 2012-10-30 10:40:01.239--ClientSession(21711674)--Thread(Thread[main,5,main])--acquire unit of work: 3661289
    [java] [EL Finest]: query: 2012-10-30 10:40:01.239--UnitOfWork(3661289)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(referenceClass=Customer jpql="Select c from Customer c where c.id = 51")
    [java] [EL Finest]: connection: 2012-10-30 10:40:01.239--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Fine]: sql: 2012-10-30 10:40:01.317--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--SELECT ID, NAME, VERSION, ROWID FROM DBE_CUSTOMER WHERE (ID = ?)
    [java]     bind => [51]
    [java] [EL Finest]: connection: 2012-10-30 10:40:01.426--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java]
    [java]
    [java] Customer name on application #1: Test1
    [java] Customer name on application #2: Test1
    [java]
    [java]
    [java] Updating customer name to 'Test2' on application #1.
    [java] [EL Finer]: transaction: 2012-10-30 10:40:01.426--UnitOfWork(19397123)--Thread(Thread[main,5,main])--begin unit of work commit
    [java] [EL Finest]: query: 2012-10-30 10:40:01.426--UnitOfWork(19397123)--Thread(Thread[main,5,main])--Execute query UpdateObjectQuery(model.Customer@18ef117)
    [java] [EL Finest]: connection: 2012-10-30 10:40:01.52--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection acquired from connection pool [default].
    [java] [EL Finer]: transaction: 2012-10-30 10:40:01.536--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--begin transaction
    [java] [EL Fine]: sql: 2012-10-30 10:40:01.536--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--UPDATE DBE_CUSTOMER SET NAME = ?, VERSION = ? WHERE ((ID = ?) AND (VERSION = ?))
    [java]     bind => [Test2, 2, 51, 1]
    [java] [EL Finest]: query: 2012-10-30 10:40:02.192--UnitOfWork(19397123)--Thread(Thread[main,5,main])--Execute query ValueReadQuery(name="oracle.dcn.transaction-id" sql="SELECT DBMS_TRANSACTION.LOCAL_TRANSACTION_ID FROM DUAL")
    [java] [EL Fine]: sql: 2012-10-30 10:40:02.192--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--SELECT DBMS_TRANSACTION.LOCAL_TRANSACTION_ID FROM DUAL
    [java] [EL Finer]: transaction: 2012-10-30 10:40:02.348--ClientSession(9608099)--Connection(12724600)--Thread(Thread[main,5,main])--commit transaction
    [java] [EL Finest]: connection: 2012-10-30 10:40:02.505--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--Connection released to connection pool [default].
    [java] [EL Finer]: transaction: 2012-10-30 10:40:02.505--UnitOfWork(19397123)--Thread(Thread[main,5,main])--end unit of work commit
    [java] [EL Finer]: transaction: 2012-10-30 10:40:02.505--UnitOfWork(19397123)--Thread(Thread[main,5,main])--resume unit of work
    [java]
    [java]
    [java] Selecting customer on application #2.
    [java] [EL Finer]: connection: 2012-10-30 10:40:03.505--ServerSession(1090841)--Thread(Thread[main,5,main])--client acquired: 24335874
    [java] [EL Finer]: transaction: 2012-10-30 10:40:03.505--ClientSession(24335874)--Thread(Thread[main,5,main])--acquire unit of work: 18075465
    [java] [EL Finest]: query: 2012-10-30 10:40:03.505--UnitOfWork(18075465)--Thread(Thread[main,5,main])--Execute query ReadObjectQuery(referenceClass=Customer jpql="Select c from Customer c where c.id = 51")
    [java] [EL Finest]: transaction: 2012-10-30 10:40:03.505--UnitOfWork(18075465)--Thread(Thread[main,5,main])--Register the existing object model.Customer@18df055
    [java]
    [java]
    [java] Customer name on application #1: Test2
    [java] Customer name on application #2: Test1
    [java] [EL Finer]: transaction: 2012-10-30 10:40:03.536--UnitOfWork(19397123)--Thread(Thread[main,5,main])--release unit of work
    [java] [EL Finer]: connection: 2012-10-30 10:40:03.536--ClientSession(9608099)--Thread(Thread[main,5,main])--client released
    [java] [EL Finest]: jpa: 2012-10-30 10:40:03.536--ServerSession(1636997)--Thread(Thread[main,5,main])--Begin undeploying Persistence Unit order; session order; state Deployed; factoryCount 1
    [java] [EL Finest]: connection: 2012-10-30 10:40:03.536--ServerSession(1636997)--Thread(Thread[main,5,main])--Removing registering for database change event notification.
    [java] [EL Finest]: sequencing: 2012-10-30 10:40:03.802--ServerSession(1636997)--Thread(Thread[main,5,main])--sequencing disconnected
    [java] [EL Config]: connection: 2012-10-30 10:40:03.802--ServerSession(1636997)--Connection(12724600)--Thread(Thread[main,5,main])--disconnect
    [java] [EL Finer]: cache: 2012-10-30 10:40:03.895--ServerSession(1636997)--Thread(Thread[main,5,main])--initialize identitymaps
    [java] [EL Info]: connection: 2012-10-30 10:40:03.895--ServerSession(1636997)--Thread(Thread[main,5,main])--order logout successful
    [java] [EL Config]: connection: 2012-10-30 10:40:03.895--ServerSession(1636997)--Connection(7886757)--Thread(Thread[main,5,main])--disconnect
    [java] [EL Finest]: jpa: 2012-10-30 10:40:03.895--ServerSession(1636997)--Thread(Thread[main,5,main])--End undeploying Persistence Unit order; session order; state Undeployed; factoryCount 0
    [java] [EL Finest]: jpa: 2012-10-30 10:40:03.942--ServerSession(1090841)--Thread(Thread[main,5,main])--Begin undeploying Persistence Unit order2; session order2; state Deployed; factoryCount 1
    [java] [EL Finest]: connection: 2012-10-30 10:40:03.942--ServerSession(1090841)--Thread(Thread[main,5,main])--Removing registering for database change event notification.
    [java] [EL Finest]: sequencing: 2012-10-30 10:40:04.02--ServerSession(1090841)--Thread(Thread[main,5,main])--sequencing disconnected
    [java] [EL Config]: connection: 2012-10-30 10:40:04.02--ServerSession(1090841)--Connection(28900573)--Thread(Thread[main,5,main])--disconnect
    [java] [EL Finer]: cache: 2012-10-30 10:40:04.052--ServerSession(1090841)--Thread(Thread[main,5,main])--initialize identitymaps
    [java] [EL Info]: connection: 2012-10-30 10:40:04.052--ServerSession(1090841)--Thread(Thread[main,5,main])--order2 logout successful
    [java] [EL Config]: connection: 2012-10-30 10:40:04.052--ServerSession(1090841)--Connection(4751287)--Thread(Thread[main,5,main])--disconnect
    [java] [EL Finest]: jpa: 2012-10-30 10:40:04.052--ServerSession(1090841)--Thread(Thread[main,5,main])--End undeploying Persistence Unit order2; session order2; state Undeployed; factoryCount 0
    [java] java.lang.RuntimeException: Test #2 failed
    [java]     at example.Example.run(Example.java:116)
    [java]     at example.Example.main(Example.java:35)

BUILD SUCCESSFUL Total time: 4 minutes 22 seconds

Following up through the forums would be appropriate, this wiki is not the correct place for technical support.
James.sutherland.oracle.com 12:46, 31 October 2012 (UTC)

Sorry about that. The 'Page' contains the following: "If you encounter any issues in running this example, please discuss, here." I followed the link and it brought me to this page. Perhaps that sentence could/should be rewritten. Thanks.

Copyright © Eclipse Foundation, Inc. All Rights Reserved.