[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