From torque-user-return-3029-apmail-db-torque-user-archive=db.apache.org@db.apache.org Wed Sep 03 18:15:07 2003
Return-Path: <torque-user-return-3029-apmail-db-torque-user-archive=db.apache.org@db.apache.org>
Delivered-To: apmail-db-torque-user-archive@www.apache.org
Received: (qmail 29573 invoked from network); 3 Sep 2003 18:15:07 -0000
Received: from daedalus.apache.org (HELO mail.apache.org) (208.185.179.12)
  by minotaur-2.apache.org with SMTP; 3 Sep 2003 18:15:07 -0000
Received: (qmail 9030 invoked by uid 500); 3 Sep 2003 17:53:51 -0000
Delivered-To: apmail-db-torque-user-archive@db.apache.org
Received: (qmail 8925 invoked by uid 500); 3 Sep 2003 17:53:49 -0000
Mailing-List: contact torque-user-help@db.apache.org; run by ezmlm
Precedence: bulk
List-Unsubscribe: <mailto:torque-user-unsubscribe@db.apache.org>
List-Subscribe: <mailto:torque-user-subscribe@db.apache.org>
List-Help: <mailto:torque-user-help@db.apache.org>
List-Post: <mailto:torque-user@db.apache.org>
List-Id: "Apache Torque Users List" <torque-user.db.apache.org>
Reply-To: "Apache Torque Users List" <torque-user@db.apache.org>
Delivered-To: mailing list torque-user@db.apache.org
Received: (qmail 8806 invoked from network); 3 Sep 2003 17:53:47 -0000
Received: from unknown (HELO secfw12.sec.gov) (12.40.163.231)
  by daedalus.apache.org with SMTP; 3 Sep 2003 17:53:47 -0000
Received: by secfw12.sec.gov; id h83HrkG20822; Wed, 3 Sep 2003 13:53:46 -0400
Received: from exchange2.sec.gov(162.138.65.52) by secfw12.sec.gov via smap
	id xma020522; Wed, 3 Sep 03 13:52:41 -0400
Received: by opc-sec-mt1.sec.gov with Internet Mail Service (5.5.2653.19)
	id <SGM5AW1C>; Wed, 3 Sep 2003 13:53:24 -0400
Message-ID: <E140F7BF5ED11A47AEE830C6FF0FA4C04E6202@opc-sec-ex1.sec.gov>
From: "Keeney, Thomas" <KeeneyT@SEC.GOV>
To: "'Apache Torque Users List'" <torque-user@db.apache.org>
Subject: RE: MySQL autoincrement not working 
Date: Wed, 3 Sep 2003 13:53:23 -0400 
MIME-Version: 1.0
X-Mailer: Internet Mail Service (5.5.2653.19)
Content-Type: text/plain;
	charset="iso-8859-1"
X-Spam-Rating: daedalus.apache.org 1.6.2 0/1000/N
X-Spam-Rating: minotaur-2.apache.org 1.6.2 0/1000/N

Chris,

Try autoIncrement instead of autoincrement.

Tom

-----Original Message-----
From: Chris Huisman [mailto:chuisman@chenomx.com]
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: torque-user-unsubscribe@db.apache.org
For additional commands, e-mail: torque-user-help@db.apache.org

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