db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Wizard of OS <sg...@gmx.net>
Subject Torque/Oracle 10 Incrementation problem
Date Mon, 08 May 2006 15:37:05 GMT
Hi,

just installed happily torque for oracle and declared this table:

<table name="FAN" idMethod="native">
     <column name="FAN_ID" required="true" primaryKey="true" 
type="INTEGER"/>
     <column name="FIRST_NAME" required="true" size="128" type="VARCHAR"/>
     <column name="PASSWORD" required="true" size="32" type="VARCHAR"/>
     <column name="EMAIL" required="true" size="128" type="VARCHAR"/>
     <unique>
     	<unique-column name="EMAIL"/>
     </unique>
   </table>

Adding someone once is very fine with torque and ID gets incremented.
now I provoked a unique constraint violation with adding someone else 
with the same email address. The DB rejected of course and torque threw 
an exception.
Adding another set of data with a distinct email adresses created 
instead of ID =2 => ID = 3.
Seems like the failed torque command incremented the ID anyway.

how can I avoid this?
It is extremely unpleasent.
idMethod=idbroker does the same error!

bye

thx in advance

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


Mime
View raw message