| [eclipselink-users] InheritanceType.Joined - Embedded field not getting bound parameters populated on INSERT INTO.... |
|
eclipselink build 2.2.1.v20110722-r9776) EmbeddedObject isnt getting the values of its fields bound to the parameters of the update query as far as I can see everything is correct here and works in toplink - but as per usual everytime we try and move to eclipselink something fails to work as expected :( usually to do with caching.... Job is superclass (joinedTable) of DealNumberUpdateJob which contains embedded object DealNumberUpdateType - which fails to insert as null values are bound to the parameters instead of the actual values , When debugging if I put a breakpoint on SQLIntegrityConstraintViolationException I see this in the variables window for the oracle statement which appear to be special binding cases for null vars instead of the VarcharBinder that we might expect, no where can I see the actual values from the object. I am just 'newing' the object, assigning values and doing em.persist() I'll try and put together an isolated test case in the meantime ... lastBinders Binder[] Binder[4] (id=426) Binder[] [0] Binder VarcharNullBinder (id=459) VarcharNullBinder bytelen int 0 int theVarcharCopyingBinder Binder VarcharCopyingBinder (id=637) VarcharCopyingBinder type short 9 short [1] Binder VarcharNullBinder (id=459) VarcharNullBinder bytelen int 0 int theVarcharCopyingBinder Binder VarcharCopyingBinder (id=637) VarcharCopyingBinder type short 9 short [2] Binder VarcharNullBinder (id=459) VarcharNullBinder bytelen int 0 int theVarcharCopyingBinder Binder VarcharCopyingBinder (id=637) VarcharCopyingBinder type short 9 short [3] Binder LongBinder (id=506) LongBinder bytelen int 22 int theVarnumCopyingBinder Binder VarnumCopyingBinder (id=630) VarnumCopyingBinder type short 6 short further down the callstack in RepeatableWriteUnitOfWork(AbstractSession).writeAllObjectsWithChangeSet(UnitOfWorkChangeSet) line: 3766 the uowChangeSet.objectChanges only seems to think the version column has changed [class biz.wss.server.services.workflow.dealnumber.DealNumberUpdateJob={ ObjectChangeSet(285649, biz.wss.server.services.workflow.dealnumber.DealNumberUpdateJob) [org.eclipse.persistence.internal.sessions.DirectToFieldChangeRecord(version)]=ObjectChangeSet(285649, biz.wss.server.services.workflow.dealnumber.DealNumberUpdateJob) [org.eclipse.persistence.internal.sessions.DirectToFieldChangeRecord(version)] }] anyone come across anything similar ? persistence.xml : <property name="eclipselink.cache.shared.Job" value="false"/> <property name="eclipselink.cache.shared.DealNumberUpdateJob" value="false"/ @Entity @Table(name="WBR_SY_WFJOB") @Inheritance(strategy=InheritanceType.JOINED) @DiscriminatorColumn(name="JOBTYPE") public abstract class Job implements JobIfc { @Id @GeneratedValue(strategy=GenerationType.TABLE, generator="wfJobSeq") @Column(name="ID") private Long id; @Version private Long version; @Column(name="JOBTYPE", nullable=false) private String jobType; @Column(name="JOBPRIORITY", nullable=false) private int jobPriority = Integer.MAX_VALUE; @Enumerated(EnumType.STRING) @Column(name="JOBSTATE") private TaskState jobState; @Column(name="CURRENTSEQ") private int currentSequence; @Embedded @AttributeOverride(name="persistentValue", column=@Column(name="CREATETIME")) private JpaBDateTime jobCreatedTime; @Embedded @AttributeOverride(name="persistentValue", column=@Column(name="STARTTIME")) private JpaBDateTime jobStartedTime; @Embedded @AttributeOverride(name="persistentValue", column=@Column(name="ENDTIME")) private JpaBDateTime jobFinishedTime; @OneToMany(mappedBy="job", cascade={CascadeType.ALL}, fetch=FetchType.EAGER) private List<Task> tasks; public Job() { @Entity @Table(name="WBR_SY_WFDEALNUMBERJOB") @DiscriminatorValue(Job.DISC_DEALNUMBER) @PrimaryKeyJoinColumn() public class DealNumberUpdateJob extends Job{ @Embedded private DealNumberUpdateType dealNumberInfo; @Embeddable public class DealNumberUpdateType implements Serializable { private static final long serialVersionUID = -4866647169410234064L; @Column(insertable=true,updatable=false) private String coreTran; @Column(insertable=true,updatable=false) private String dealNumber; @Column(insertable=true,updatable=false) private String ticketAreaUnit; @Column(insertable=false,updatable=true) private long p2TranID; public DealNumberUpdateType() [#|2011-08-16T11:12:13.155+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|client acquired: 2113516171|#] [#|2011-08-16T11:12:13.156+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|TX binding to tx mgr, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.156+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|acquire unit of work: 339280970|#] [#|2011-08-16T11:12:13.156+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|persist() operation called on: DealNumberUpdateJob [dealNumberInfo= [DealNumberUpdateType:core tran - 001007108000001, deal number - 2009060100057, ticketAreaUnit - 0056, p2TranID - 0] DealNumberUpdateJob@1ebccff8{id=280732;ver=null;typ=DEALNUMBER;pri=2147483647;st=NEWTASK;seq=0;starttime=null;finishedtime=null;tasks=null}].|#] [#|2011-08-16T11:12:13.157+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX beforeCompletion callback, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.158+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|begin unit of work commit|#] [#|2011-08-16T11:12:13.158+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX beginTransaction, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.query|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Execute query InsertObjectQuery(DealNumberUpdateJob [dealNumberInfo= [#|2011-08-16T11:12:13.155+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|client acquired: 2113516171|#] [#|2011-08-16T11:12:13.156+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|TX binding to tx mgr, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.156+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|acquire unit of work: 339280970|#] [#|2011-08-16T11:12:13.156+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=64351055-20d6-4568-a3d9-2582514bbea7;|persist() operation called on: DealNumberUpdateJob [dealNumberInfo= [DealNumberUpdateType:core tran - 001007108000001, deal number - 2009060100057, ticketAreaUnit - 0056, p2TranID - 0] DealNumberUpdateJob@1ebccff8{id=280732;ver=null;typ=DEALNUMBER;pri=2147483647;st=NEWTASK;seq=0;starttime=null;finishedtime=null;tasks=null}].|#] [#|2011-08-16T11:12:13.157+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX beforeCompletion callback, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.158+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|begin unit of work commit|#] [#|2011-08-16T11:12:13.158+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX beginTransaction, status=STATUS_ACTIVE|#] [#|2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.query|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Execute query InsertObjectQuery(DealNumberUpdateJob [dealNumberInfo= [DealNumberUpdateType:core tran - 001007108000001, deal number - 2009060100057, ticketAreaUnit - 0056, p2TranID - 0] DealNumberUpdateJob@1ebccff8{id=280732;ver=null;typ=DEALNUMBER;pri=2147483647;st=NEWTASK;seq=0;starttime=null;finishedtime=null;tasks=null}])|#] [#|2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Connection acquired from connection pool [default].|#] |2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|reconnecting to external connection pool|#] [#|2011-08-16T11:12:13.169+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|INSERT INTO WSSDBA.WBR_SY_WFJOB (ID, CURRENTSEQ, JOBPRIORITY, JOBSTATE, JOBTYPE, VERSION, CREATETIME, ENDTIME, STARTTIME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound]|#] [#|2011-08-16T11:12:13.179+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound]|#] [#|2011-08-16T11:12:13.202+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|SELECT 1 FROM DUAL|#] [#|2011-08-16T11:12:13.208+0000|WARNING|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;| Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) [#|2011-08-16T11:12:13.215+0000|WARNING|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;| Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) [#|2011-08-16T11:12:13.216+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Connection released to connection pool [default].|#] [#|2011-08-16T11:12:13.216+0000|WARNING|sun-appserver2.1|javax.enterprise.system.core.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|JTS5054: Unexpected error occurred in after completion Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) at com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:278) at com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:250) at com.sun.jts.CosTransactions.CurrentImpl.commit(CurrentImpl.java:623) at com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:309) at com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1003) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:398) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3826) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:789) ... 35 more |#] [#|2011-08-16T11:12:13.216+0000|WARNING|sun-appserver2.1|javax.enterprise.system.core.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound];before_completion;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|JTS5033: Exception [Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound]] on [before_completion] synchronization operation.|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX afterCompletion callback, status=ROLLEDBACK|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|release unit of work|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|client released|#] [#|2011-08-16T11:12:13.232+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB;javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException;|MDB00037: [Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB]: Message-driven bean invocation exception: [javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException]|#] [#|2011-08-16T11:12:13.232+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB;javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException;|MDB00037: [Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB]: Message-driven bean invocation exception: [javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException]|#] [#|2011-08-16T11:12:13.233+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;|javax.ejb.EJBException javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException javax.transaction.RollbackException at com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:311) at com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1003) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:398) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3826) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3832) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) |#] DealNumberUpdateJob@1ebccff8{id=280732;ver=null;typ=DEALNUMBER;pri=2147483647;st=NEWTASK;seq=0;starttime=null;finishedtime=null;tasks=null}])|#] [#|2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Connection acquired from connection pool [default].|#] |2011-08-16T11:12:13.158+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|reconnecting to external connection pool|#] [#|2011-08-16T11:12:13.169+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|INSERT INTO WSSDBA.WBR_SY_WFJOB (ID, CURRENTSEQ, JOBPRIORITY, JOBSTATE, JOBTYPE, VERSION, CREATETIME, ENDTIME, STARTTIME) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?) bind => [9 parameters bound]|#] [#|2011-08-16T11:12:13.179+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound]|#] [#|2011-08-16T11:12:13.202+0000|FINE|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.sql|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|SELECT 1 FROM DUAL|#] [#|2011-08-16T11:12:13.208+0000|WARNING|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;| Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) [#|2011-08-16T11:12:13.215+0000|WARNING|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;| Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) [#|2011-08-16T11:12:13.216+0000|FINEST|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|Connection released to connection pool [default].|#] [#|2011-08-16T11:12:13.216+0000|WARNING|sun-appserver2.1|javax.enterprise.system.core.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|JTS5054: Unexpected error occurred in after completion Local Exception Stack: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound] at org.eclipse.persistence.exceptions.DatabaseException.sqlException(DatabaseException.java:324) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:798) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeNoSelect(DatabaseAccessor.java:864) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.basicExecuteCall(DatabaseAccessor.java:583) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeCall(DatabaseAccessor.java:526) at org.eclipse.persistence.internal.sessions.AbstractSession.basicExecuteCall(AbstractSession.java:1729) at org.eclipse.persistence.sessions.server.ClientSession.executeCall(ClientSession.java:234) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeCall(DatasourceCallQueryMechanism.java:207) at org.eclipse.persistence.internal.queries.DatasourceCallQueryMechanism.executeDeferredCall(DatasourceCallQueryMechanism.java:376) at org.eclipse.persistence.internal.sessions.CommitManager.commitAllObjectsWithChangeSet(CommitManager.java:144) at org.eclipse.persistence.internal.sessions.AbstractSession.writeAllObjectsWithChangeSet(AbstractSession.java:3766) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabase(UnitOfWorkImpl.java:1412) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.commitToDatabase(RepeatableWriteUnitOfWork.java:618) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.commitToDatabaseWithChangeSet(UnitOfWorkImpl.java:1519) at org.eclipse.persistence.internal.sessions.UnitOfWorkImpl.issueSQLbeforeCompletion(UnitOfWorkImpl.java:3123) at org.eclipse.persistence.internal.sessions.RepeatableWriteUnitOfWork.issueSQLbeforeCompletion(RepeatableWriteUnitOfWork.java:333) at org.eclipse.persistence.transaction.AbstractSynchronizationListener.beforeCompletion(AbstractSynchronizationListener.java:157) at org.eclipse.persistence.transaction.JTASynchronizationListener.beforeCompletion(JTASynchronizationListener.java:68) at com.sun.jts.jta.SynchronizationImpl.before_completion(SynchronizationImpl.java:99) at com.sun.jts.CosTransactions.RegisteredSyncs.distributeBefore(RegisteredSyncs.java:158) at com.sun.jts.CosTransactions.TopCoordinator.beforeCompletion(TopCoordinator.java:2548) at com.sun.jts.CosTransactions.CoordinatorTerm.commit(CoordinatorTerm.java:278) at com.sun.jts.CosTransactions.TerminatorImpl.commit(TerminatorImpl.java:250) at com.sun.jts.CosTransactions.CurrentImpl.commit(CurrentImpl.java:623) at com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:309) at com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1003) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:398) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3826) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) Caused by: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:440) at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:396) at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:837) at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:445) at oracle.jdbc.driver.T4CTTIfun.doRPC(T4CTTIfun.java:191) at oracle.jdbc.driver.T4C8Oall.doOALL(T4C8Oall.java:523) at oracle.jdbc.driver.T4CPreparedStatement.doOall8(T4CPreparedStatement.java:207) at oracle.jdbc.driver.T4CPreparedStatement.executeForRows(T4CPreparedStatement.java:1010) at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:1315) at oracle.jdbc.driver.OraclePreparedStatement.executeInternal(OraclePreparedStatement.java:3576) at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:3657) at oracle.jdbc.driver.OraclePreparedStatementWrapper.executeUpdate(OraclePreparedStatementWrapper.java:1350) at org.eclipse.persistence.internal.databaseaccess.DatabaseAccessor.executeDirectNoSelect(DatabaseAccessor.java:789) ... 35 more |#] [#|2011-08-16T11:12:13.216+0000|WARNING|sun-appserver2.1|javax.enterprise.system.core.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound];before_completion;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|JTS5033: Exception [Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.2.1.v20110722-r9776): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLIntegrityConstraintViolationException: ORA-01400: cannot insert NULL into ("WSSDBA"."WBR_SY_WFDEALNUMBERJOB"."CORETRAN") Error Code: 1400 Call: INSERT INTO WSSDBA.WBR_SY_WFDEALNUMBERJOB (CORETRAN, DEALNUMBER, TICKETAREAUNIT, ID) VALUES (?, ?, ?, ?) bind => [4 parameters bound]] on [before_completion] synchronization operation.|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|TX afterCompletion callback, status=ROLLEDBACK|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.transaction|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|release unit of work|#] [#|2011-08-16T11:12:13.232+0000|FINER|sun-appserver2.1|org.eclipse.persistence.session.file:/rndvm/java/domainRNDVM/applications/j2ee-apps/Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514/Bedrock.server.services.local_jar/_WSSJPA.connection|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;ClassName=null;MethodName=null;_RequestID=d00784bd-e12c-473e-aa11-b3071265b541;|client released|#] [#|2011-08-16T11:12:13.232+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB;javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException;|MDB00037: [Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB]: Message-driven bean invocation exception: [javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException]|#] [#|2011-08-16T11:12:13.232+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB;javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException;|MDB00037: [Bedrock-ot-norcp-gf211-el221-DEV-r000000-20110816-111514:DealNumberUpdateListenerMDB]: Message-driven bean invocation exception: [javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException]|#] [#|2011-08-16T11:12:13.233+0000|INFO|sun-appserver2.1|javax.enterprise.system.container.ejb.mdb|_ThreadID=32;_ThreadName=p: thread-pool-1; w: 20;|javax.ejb.EJBException javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException javax.transaction.RollbackException at com.sun.jts.jta.TransactionManagerImpl.commit(TransactionManagerImpl.java:311) at com.sun.enterprise.distributedtx.J2EETransactionManagerImpl.commit(J2EETransactionManagerImpl.java:1003) at com.sun.enterprise.distributedtx.J2EETransactionManagerOpt.commit(J2EETransactionManagerOpt.java:398) at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3826) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) javax.ejb.EJBException: Transaction aborted; nested exception is: javax.transaction.RollbackException at com.sun.ejb.containers.BaseContainer.completeNewTx(BaseContainer.java:3832) at com.sun.ejb.containers.BaseContainer.postInvokeTx(BaseContainer.java:3605) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDeliveryInternal(MessageBeanContainer.java:1226) at com.sun.ejb.containers.MessageBeanContainer.afterMessageDelivery(MessageBeanContainer.java:1197) at com.sun.ejb.containers.MessageBeanListenerImpl.afterMessageDelivery(MessageBeanListenerImpl.java:79) at com.sun.enterprise.connectors.inflow.MessageEndpointInvocationHandler.invoke(MessageEndpointInvocationHandler.java:139) at $Proxy465.afterDelivery(Unknown Source) at com.sun.messaging.jms.ra.OnMessageRunner.run(OnMessageRunner.java:324) at com.sun.enterprise.connectors.work.OneWork.doWork(OneWork.java:77) at com.sun.corba.ee.impl.orbutil.threadpool.ThreadPoolImpl$WorkerThread.run(ThreadPoolImpl.java:555) |#] |