Return-Path: 
 <dev-return-4666-apmail-ibatis-dev-archive=ibatis.apache.org@ibatis.apache.org>
Delivered-To: apmail-ibatis-dev-archive@www.apache.org
Received: (qmail 16227 invoked from network); 18 Oct 2008 05:03:08 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2)
  by minotaur.apache.org with SMTP; 18 Oct 2008 05:03:08 -0000
Received: (qmail 4860 invoked by uid 500); 18 Oct 2008 05:03:09 -0000
Delivered-To: apmail-ibatis-dev-archive@ibatis.apache.org
Received: (qmail 4847 invoked by uid 500); 18 Oct 2008 05:03:09 -0000
Mailing-List: contact dev-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
List-Help: <mailto:dev-help@ibatis.apache.org>
List-Unsubscribe: <mailto:dev-unsubscribe@ibatis.apache.org>
List-Post: <mailto:dev@ibatis.apache.org>
List-Id: <dev.ibatis.apache.org>
Reply-To: dev@ibatis.apache.org
Delivered-To: mailing list dev@ibatis.apache.org
Received: (qmail 4832 invoked by uid 99); 18 Oct 2008 05:03:08 -0000
Received: from athena.apache.org (HELO athena.apache.org) (140.211.11.136)
    by apache.org (qpsmtpd/0.29) with ESMTP; Fri, 17 Oct 2008 22:03:08 -0700
X-ASF-Spam-Status: No, hits=-2000.0 required=10.0
	tests=ALL_TRUSTED
X-Spam-Check-By: apache.org
Received: from [140.211.11.140] (HELO brutus.apache.org) (140.211.11.140)
    by apache.org (qpsmtpd/0.29) with ESMTP; Sat, 18 Oct 2008 05:02:06 +0000
Received: from brutus (localhost [127.0.0.1])
	by brutus.apache.org (Postfix) with ESMTP id 3B350234C232
	for <dev@ibatis.apache.org>; Fri, 17 Oct 2008 22:02:44 -0700 (PDT)
Message-ID: <1346902295.1224306164227.JavaMail.jira@brutus>
Date: Fri, 17 Oct 2008 22:02:44 -0700 (PDT)
From: "GONG HUAIYU (JIRA)" <ibatis-dev@incubator.apache.org>
To: dev@ibatis.apache.org
Subject: [jira] Created: (IBATIS-548) Please change Abator automatically
 generated datatype  from int into long and  primary key datatype from
 Interger into Long
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit
X-Virus-Checked: Checked by ClamAV on apache.org

Please change Abator automatically generated datatype  from int into long and  primary key datatype from Interger into Long
---------------------------------------------------------------------------------------------------------------------------

                 Key: IBATIS-548
                 URL: https://issues.apache.org/jira/browse/IBATIS-548
             Project: iBatis for Java
          Issue Type: Improvement
            Reporter: GONG HUAIYU


insert into admin_costcenterid (ID, COMID, COSTCENTERID, REMARKS, ACTIVESTATUS, UPDATEBY,
      LASTHIT)
    values (#id:Integer#, #comid:VARCHAR#, #costcenterid:VARCHAR#, #remarks:VARCHAR#,
      #activestatus:SMALLINT#, #updateby:VARCHAR#, #lasthit:TIMESTAMP#)
  

  <selectKey resultClass="int" keyProperty="id">
    SELECT LAST_INSERT_ID() AS id            
</selectKey>
		

Change into 
insert into admin_costcenterid (ID, COMID, COSTCENTERID, REMARKS, ACTIVESTATUS, UPDATEBY,
      LASTHIT)
    values (#id:Long#, #comid:VARCHAR#, #costcenterid:VARCHAR#, #remarks:VARCHAR#,
      #activestatus:SMALLINT#, #updateby:VARCHAR#, #lasthit:TIMESTAMP#)

  <selectKey resultClass="long" keyProperty="id">
    SELECT LAST_INSERT_ID() AS id            
</selectKey>	       

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.