Recently a WO app has been getting the unique constraint error when creating a
record. This application has been running for years and so I'm surprised at
this 'just' showing up. here is the problem: you'll see in the following
lines that an index is retrieved for jobs_notes_seq twice because I'm inserting
two records. next you'll see the insert statements. look at the notesid
field.
[2010-12-8 10:54:32 EST] <WorkerThread1> === Begin Internal Transaction
[2010-12-8 10:54:32 EST] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT
JOBS_NOTES_SEQ.NEXTVAL FROM DUAL" withBindings: >
[2010-12-8 10:54:32 EST] <WorkerThread1> 1 row(s) processed
[2010-12-8 10:54:32 EST] <WorkerThread1> === Commit Internal Transaction
[2010-12-8 10:54:32 EST] <WorkerThread1> === Begin Internal Transaction
[2010-12-8 10:54:32 EST] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "SELECT
JOBS_NOTES_SEQ.NEXTVAL FROM DUAL" withBindings: >
[2010-12-8 10:54:32 EST] <WorkerThread1> 1 row(s) processed
[2010-12-8 10:54:32 EST] <WorkerThread1> === Commit Internal Transaction
[2010-12-8 10:54:32 EST] <WorkerThread1> === Begin Internal Transaction
[2010-12-8 10:54:32 EST] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "INSERT INTO
JOBS_NOTES(NOTES_SUBMITTED_BY, NOTES_HYPERLINK, NOTES_USER_VISIBLE,
NOTES_JOB_ID, NOTES_SUBMITTED_DATE, NOTES_DESCRIPTION, NOTES_ID,
NOTES_ATTACHMENT_NAME) VALUES (?, NULL, ?, ?, ?, ?, ?, ?)" withBindings:
1:204(submittedby), 2:"N"(uservisible), 3:292(jobid), 4:2010-12-08
10:54:17(submitteddate), 5:"gg"(notesdescription), 6:922(notesid),
7:"Overview.graffle"(attachmentname)>
[2010-12-8 10:54:32 EST] <WorkerThread1> evaluateExpression:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "INSERT INTO
JOBS_NOTES(NOTES_SUBMITTED_BY, NOTES_HYPERLINK, NOTES_USER_VISIBLE,
NOTES_JOB_ID, NOTES_SUBMITTED_DATE, NOTES_DESCRIPTION, NOTES_ID,
NOTES_ATTACHMENT_NAME) VALUES (?, NULL, ?, ?, ?, ?, ?, ?)" withBindings:
1:204(submittedby), 2:"N"(uservisible), 3:292(jobid), 4:2010-12-08
10:54:23(submitteddate), 5:"hh"(notesdescription), 6:56(notesid),
7:"Overview.graffle"(attachmentname)>
[2010-12-8 10:54:33 EST] <WorkerThread1> === Rollback Internal Transaction
see how one is 922 and another is 56? 922 is correct but the 56 should be 923.
very strange. then when the records are committed, sometimes I get the
dreaded error message:
com.webobjects.eoaccess.EOGeneralAdaptorException: EvaluateExpression failed:
<com.webobjects.jdbcadaptor.OraclePlugIn$OracleExpression: "INSERT INTO
JOBS_NOTES(NOTES_SUBMITTED_BY, NOTES_HYPERLINK, NOTES_USER_VISIBLE,
NOTES_JOB_ID, NOTES_SUBMITTED_DATE, NOTES_DESCRIPTION, NOTES_ID,
NOTES_ATTACHMENT_NAME) VALUES (?, NULL, ?, ?, ?, ?, ?, ?)" withBindings:
1:204(submittedby), 2:"N"(uservisible), 3:292(jobid), 4:2010-12-08
10:54:23(submitteddate), 5:"hh"(notesdescription), 6:56(notesid),
7:"Overview.graffle"(attachmentname)>
Next exception:SQL State:23000 -- error code: 1 -- msg: ORA-00001: unique
constraint (COREDEV3.SYS_C0031657) violated
Obviously this is a problem because number 56 was already a record in the
table. Sometimes, there is no error message and the record is not even
created. And sometimes, when the index is correct the record is created
successfully. argh!
Anyone have this problem before or know what I can do to solve this mystery?
(I've dropped the sequences and recreated them a couple of times. but it
doesn't solve the problem)
Thanks for your time.
Calven
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (Webobjects-dev@lists.apple.com)
Help/Unsubscribe/Update your Subscription:
http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com
This email sent to arch...@mail-archive.com
