Hi All, I get the error below. I'm using torque 3.1.1 and postgres 8.0 . I wonder why the quantity of the specific record in id-table is increased and one second later it will fail during an insert. This table is only accessed by using the idbroker method of Torque. It worked for 2 months perfectly except for now. Does anyone has an idea?
2006/01/31 11:05:59 | - Forced id retrieval - no available list 2006/01/31 11:05:59 | - updateQuantity: UPDATE ID_TABLE SET QUANTITY = 3 WHERE TABLE_NAME = 'LOCKING' 2006/01/31 11:05:59 | - updateNextId: UPDATE ID_TABLE SET NEXT_ID = 1373 WHERE TABLE_NAME = 'LOCKING' 2006/01/31 11:06:00 | - Exception 2006/01/31 11:06:00 | org.apache.torque.TorqueException: java.sql.SQLException: ERROR: duplicate key violates unique constraint "locking_pkey" 2006/01/31 11:06:00 | at org.apache.torque.util.BasePeer.throwTorqueException(BasePeer.java:200) 2006/01/31 11:06:00 | at org.apache.torque.util.BasePeer.insertOrUpdateRecord(BasePeer.java:867) Cheers, Robert --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
