sure, here's the real thing....
jms message comes in off a queue to an MDB onMessage() - this
should start a new transaction
@Override
public void onMessage(Message message)
{
DealNumberUpdateType dealUpdate = null;
DealNumberUpdateJob dealNumberJob = null ;
try {
TextMessage txtMsg = (TextMessage) message;
if (log.isDebugEnabled())
log.debug("<MDB> ---- Got a message: JMS
time stamp - " + txtMsg.getJMSTimestamp() + ", message - " +
dealUpdate);
dealUpdate =
FieldProcessor.fromString(DealNumberUpdateType.class,
txtMsg.getText()); <<creates the embedded object from the
msg
dealNumberJob = new DealNumberUpdateJob(dealUpdate);
queueNewJob(dealNumberJob); << this is method
in superclass of this MDB as below
}
catch( WorkflowJobCreationException exc ) {
throw new
RuntimeException("WorkflowJobCreationException Exception : " +
dealNumberJob, exc);
}
catch( WorkflowJobQueueException exc ) {
throw new
RuntimeException("WorkflowJobQueueException Exception : " +
dealNumberJob, exc);
}
catch( JMSException exc ) {
throw new RuntimeException("JMSException Exception :
" + dealNumberJob, exc);
}
}
protected void queueNewJob(Job job) throws
WorkflowJobCreationException,
WorkflowJobQueueException {
try {
Long jobId = jobDAO.insertNewJob(job);
if (log.isDebugEnabled())
log.debug("inserted new Job
type:"+job.getJobType()+" with ID="+jobId);
// notify TaskController
JMSSender.sendMessage( connectionFactory,
destination,
messageCreator,
senderProperties,
new
TaskMessage(TaskMessage.Type.NEW_JOB, jobId));
} catch (EJBException ex) {
log.fatal("Unable to insert new Job:" +job +" in
database; work message is lost.", ex);
throw new WorkflowJobCreationException("Unable to
insert new Job:" +job +" in database; work message is lost.",
ex);
} catch (PersistenceException px) {
log.fatal("Unable to insert new Job:" +job +" in
database; work message is lost.", px);
throw new WorkflowJobCreationException("Unable to
insert new Job:" +job +" in database; work message is lost.",
px);
} catch (JMSException jx) {
log.warn("Unable to queue new Job:" + job, jx);
throw new WorkflowJobQueueException("Unable to queue
new Job:"+job, jx);
}
}
@Override
@TransactionAttribute(TransactionAttributeType.REQUIRED)
public Long insertNewJob(Job job) {
job.setJobCreatedTime(new BDateTime());
job.setJobState(TaskState.NEWTASK);
em.persist(idProvider.provideIds( job)); <<--we
provide our own id's so we know excactly what's happening -
happens everywhere....
return job.getId();
}
On 16/08/2011 14:06, Tom Ware wrote:
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
_______________________________________________
eclipselink-users mailing list
eclipselink-users@xxxxxxxxxxx
https://dev.eclipse.org/mailman/listinfo/eclipselink-users
|