Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Received-SPF: neutral (asf.osuosl.org: local policy)
Message-ID: <440F2F74.5050507@sbcglobal.net>
Date: Wed, 08 Mar 2006 11:24:36 -0800
From: Alex Chen <alex_chen@sbcglobal.net>
Reply-To: alex_chen@sbcglobal.net
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: torque-user@db.apache.org
Subject: unique constraint violation
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

I have seem the following exceptions in my application:

java.sql.SQLException: ORA-00001: unique constraint 
(DBUSER.USER_INFO_PK) violated

It seems that the same primary key has been used again by the ID broker.

When we use Torque to 'save' the object, the ID broker automatically 
allocates the primary key for that object, right?
I do not know what kind of scenario can cause the exception?

When this happens, does ID broker try to reuse the same ID for the next 
insertion?  If so, wouldn't that make the exception happen indefinitely?

Another questions is that I also see the following warning message in my 
log:
WARN  [main] IDBroker - IDBroker is being used with db 'payroll', which 
does not support transactions. IDBroker attempts to use transactions to 
limit the possibility of duplicate key generation.  Without 
transactions, duplicate key generation is possible if multiple JVMs are 
used or other means are used to write to the database.

This may be something that causes the problem.  How do I let IDBroker 
know that my DB server support 'transaction'?
 I am using Oracle and definitely it support transaction.

Any help is appreciated.

Alex


---------------------------------------------------------------------
To unsubscribe, e-mail: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org