Return-Path: <clinton.begin@gmail.com>
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 19293 invoked by uid 99); 11 Feb 2005 06:23:49 -0000
X-ASF-Spam-Status: No, hits=0.0 required=10.0
	tests=RCVD_BY_IP,SPF_HELO_PASS,SPF_PASS
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: domain of clinton.begin@gmail.com
 designates 64.233.184.192 as permitted sender)
Received: from wproxy.gmail.com (HELO wproxy.gmail.com) (64.233.184.192)
  by apache.org (qpsmtpd/0.28) with ESMTP; Thu, 10 Feb 2005 22:23:47 -0800
Received: by wproxy.gmail.com with SMTP id 69so253942wra
        for <ibatis-user-java@incubator.apache.org>;
 Thu, 10 Feb 2005 22:23:46 -0800 (PST)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:references;
        b=PLECLSFY1xiaJMar3ZsuM+CzeuqvNM3gWkH5NhrexCtBnraQQyeZmP2dvr0cPWRx1AyDROlK+o1WZr7B2OL73da8GzkiPW967YjfqBZUQDAoz2UlHEE8lAAEE7tYntNWIuW2Cb6SYeE1VWPKYue1ecT+rL70oXPaySyQXY7KnMk=
Received: by 10.54.38.63 with SMTP id l63mr31696wrl;
        Thu, 10 Feb 2005 22:23:45 -0800 (PST)
Received: by 10.54.33.78 with HTTP; Thu, 10 Feb 2005 22:23:45 -0800 (PST)
Message-ID: <16178eb105021022231a49f6ae@mail.gmail.com>
Date: Thu, 10 Feb 2005 23:23:45 -0700
From: Clinton Begin <clinton.begin@gmail.com>
Reply-To: cbegin@ibatis.com
To: ibatis-user-java@incubator.apache.org
Subject: Re: selectKey for Informix
In-Reply-To: <420C4EC3.9000104@isanusi.com>
Mime-Version: 1.0
Content-Type: text/plain; charset=US-ASCII
Content-Transfer-Encoding: 7bit
References: <20050209002627.33030.qmail@web21524.mail.yahoo.com>
	 <16178eb1050210163562cf2928@mail.gmail.com>
	 <420C4EC3.9000104@isanusi.com>
X-Virus-Checked: Checked

Thanks Abdullah.

Robert:  you should be able to put that in your <selectKey> element.

Clinton


On Fri, 11 Feb 2005 08:20:51 +0200, Abdullah Kauchali
<abdullah.kauchali@isanusi.com> wrote:
> select dbinfo('sqlca.errd1') from TABLENAME
> 
> works for me ... the first column of the JDBC resultset will be
> the newly inserted value.  Fire this immediately after your insert.
> 
> HTH,
> 
> Abdullah
> 
> 
> Clinton Begin wrote:
> 
> >Okay, you've posted this enough times.  We've seen it and have
> >responded.  My suggestion is that you talk to Informix support about
> >standard ways to access the serial generated ID.
> >
> >This issue barely has anything to do with iBATIS, it has more to do
> >with Informix and your connection pool.
> >
> >Cheers,
> >Clinton
> >
> >
> >On Tue, 8 Feb 2005 16:26:27 -0800 (PST), Roger Baeza <rogerimo@yahoo.com> wrote:
> >
> >
> >>Hello all
> >>
> >>Could any one help me, pls
> >>
> >>I'm looking for selectKey sintaxis to get serial value
> >>after inserting any row in tables for informix
> >>database...
> >>
> >>I was use getSerial() for ifxStatement JDBC class, but
> >>I moving to iBatis, I can't undertand what is the
> >>correct form tu use selectKey
> >>
> >>documentation say:
> >>for oracle
> >><selectKey resultClass="int" keyProperty="id" >
> >>SELECT STOCKIDSEQUENCE.NEXTVAL AS ID FROM DUAL
> >></selectKey>
> >>
> >>for sqlServer
> >><selectKey resultClass="int" keyProperty="id" >
> >>SELECT @@IDENTITY AS ID
> >></selectKey>
> >>
> >>for mysql
> >><selectKey resultClass="int" keyProperty="id" >
> >>SELECT GET_LAST_ID() AS ID
> >></selectKey>
> >>
> >>Infomix have serial datatype that autogerate ID,
> >>example
> >>
> >>Create Table Addrees(
> >>  addressId serial not null primary,
> >>  ....
> >>
> >>);
> >>
> >>Thanks alote
> >>regards
> >>
> >>
> >>__________________________________
> >>Do you Yahoo!?
> >>The all-new My Yahoo! - What will yours do?
> >>http://my.yahoo.com
> >>
> >>
> >>
> >
> >
> >
>