Skip to main content
[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index] [List Home]
Re: [eclipselink-users] InheritanceType.Joined - Embedded field not getting bound parameters populated on INSERT INTO.... 
Hi Tim,

  Does the issue occur on our latest 2.3.1 build?
Can you give me some psuedo code for what how the object is being persisted and committed? 

Thanks,
Tom

Tim Martin wrote:

  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) 
|#]


------------------------------------------------------------------------

_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users

Back to the top