Re: MySQL autoincrement not working

[Chris Huisman]

Thanks,

I should have picked up on that.

c.

Keeney, Thomas wrote:

Chris,

Try autoIncrement instead of autoincrement.

Tom

-----Original Message-----
From: Chris Huisman [mailto:[EMAIL PROTECTED]
Sent: Wednesday, September 03, 2003 11:31 AM
To: Apache Torque Users List
Subject: MySQL autoincrement not working 

Hello,

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" 
idMethod="native">
       <column name="USER_ID" primaryKey="true" required="true" 
type="INTEGER" autoincrement="true"/>
       <column name="EMAIL_ADDRESS" required="true" size="30" 
type="VARCHAR"/>       
       <column name="PASSWORD" required="true" size="12" type="VARCHAR"/>
       <column name="PERMISSIONS" required="true" size="12" 
type="VARCHAR"/>
       <unique>
             <unique-column name="EMAIL_ADDRESS"/>
       </unique>
   </table>

What am I doing wrong?

chris.

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
 



---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]