Paul,
We do the following and have no problems with Oracle:
<database
name="..."
defaultIdMethod="native">
<table name="MY_TABLE">
<column
name="MY_COLUMN"
required="true"
primaryKey="true"
...
/>
We use "defaultIdMethod" attribute in the database element rather than
idMethod in the table. Haven't tried it the other way. One guess might be
that without the primaryKey="true" and required="true", it doesn't trigger
Torque to generate the required SQL.
- Chi-Ming
-----Original Message-----
From: Paul Hammant [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 01, 2002 5:29 AM
To: [EMAIL PROTECTED]
Subject: Sequences for Oracle.
We can't get inserts to work for a Torque project that uses Oracle
sequences.
We're specifying the iDMethod="native" stuff, and the sequence is being
generated in the .sql
output, but none of the generated java code is populating the sequence
columns on insert.
Can anyone confirm this experience?
TIA,
- Paul H
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
--
To unsubscribe, e-mail:
<mailto:[EMAIL PROTECTED]>
For additional commands, e-mail:
<mailto:[EMAIL PROTECTED]>
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>