You would define a table like this:
<table name="MY_TABLE" idMethod="native">
<column name="PRIMARY_KEY_ID" required="true" autoIncrement="true"
primaryKey="true" type="INTEGER"/>
</table>
This will create a table called 'MY_TABLE', and a column that is a primary
key called 'PRIMARY_KEY_ID'. It will also create an Oracle sequence
MY_TABLE_SEQ, that will be used
to generate the ID during an insert.
I haven't used the project-jdbc task so can't help you there.
-robert.
-----Original Message-----
From: Annie Zhang [mailto:[EMAIL PROTECTED]]
Sent: Sunday, March 31, 2002 4:00 PM
To: Turbine Users List
Subject: How to deal with PK and Sequence in Oracle? How to generate XML
schema from an existing DB(oracle)?
Hi,
I have 2 questions:
I'm using oracle and torque. What's the best approach to use sequence to
generate PK ID ?
How to use ant task "project-jdbc" to generate torque's xml database schema
from an existing DB(oracle)?
thanks in advance.
Annie
--
To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]>
For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
