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: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
