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]>

Reply via email to