Oracle 10 + Sun App Server 7: Unique Constraint Violation?!? - 11-15-2006 , 02:25 AM
For about a week and a half I have been trying to solve a mysterious
issue with unique constraint violations on our database server without
We basically have a simple table with a unique primary key (number) and
a few string columns that aren't part of the key.
With J2EE on the Sun App Server 7, we always make sure we get the
nextval from the table's sequence before inserting it into the table. I
have checked this numerous times.
The Oracle DB doesn't have any triggers or other procedures accessing
the table in any way.
Has anybody heard of this issue or know how to fix it?
Re: Oracle 10 + Sun App Server 7: Unique Constraint Violation?!? - 11-15-2006 , 10:53 AM
Have you tried tracing the sessions ? How many concurrent sessions is
your applications generating ?
Re: Oracle 10 + Sun App Server 7: Unique Constraint Violation?!? - 11-15-2006 , 11:08 AM
Renzo Zagni wrote:
re-submit values that they aren't sure have been entered due to page
More info would be helpful.
Re: Oracle 10 + Sun App Server 7: Unique Constraint Violation?!? - 11-19-2006 , 11:52 AM
Scroll down to DBMS_ERRLOG.
Implement a log and when errors occur next ... trace them
back to the value in the sequence.
BTW: When you write "the table's sequence" ... tables don't have
sequences. A sequence is completely independent of any table or
tables. Be sure something else isn't using the same sequence.
Daniel A. Morgan
University of Washington
(replace x with u to respond)
Puget Sound Oracle Users Group