db-torque-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Chris Huisman <chuis...@chenomx.com>
Subject MySQL autoincrement not working
Date Wed, 03 Sep 2003 15:30:37 GMT

I have just upgraded to version 3.1, and in updating my schema per:
     TRQS178: use sql autoincrement only if idMethod native.  So you 
have to set idMethod="native" (table) plus     autoincrement="true" 
(column) to generate the autoincrement code in your sql.
my tables primary keys are not longer being autoincremented. 

The following is an example table:
   <table name="USER" description="A collection of all users" 
        <column name="USER_ID" primaryKey="true" required="true" 
type="INTEGER" autoincrement="true"/>
        <column name="EMAIL_ADDRESS" required="true" size="30" 
        <column name="PASSWORD" required="true" size="12" type="VARCHAR"/>
        <column name="PERMISSIONS" required="true" size="12" 
              <unique-column name="EMAIL_ADDRESS"/>

What am I doing wrong?


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

View raw message