Return-Path: 
 <ibatis-user-java-return-1697-apmail-incubator-ibatis-user-java-archive=incubator.apache.org@incubator.apache.org>
Delivered-To: apmail-incubator-ibatis-user-java-archive@www.apache.org
Received: (qmail 31703 invoked from network); 6 Apr 2005 16:13:10 -0000
Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199)
  by minotaur.apache.org with SMTP; 6 Apr 2005 16:13:10 -0000
Received: (qmail 57540 invoked by uid 500); 6 Apr 2005 16:13:08 -0000
Delivered-To: apmail-incubator-ibatis-user-java-archive@incubator.apache.org
Received: (qmail 57513 invoked by uid 500); 6 Apr 2005 16:13:07 -0000
Mailing-List: contact ibatis-user-java-help@incubator.apache.org; run by ezmlm
Precedence: bulk
Reply-To: ibatis-user-java@incubator.apache.org
List-Help: <mailto:ibatis-user-java-help@incubator.apache.org>
List-Unsubscribe: <mailto:ibatis-user-java-unsubscribe@incubator.apache.org>
List-Post: <mailto:ibatis-user-java@incubator.apache.org>
List-Id: <ibatis-user-java.incubator.apache.org>
Delivered-To: mailing list ibatis-user-java@incubator.apache.org
Received: (qmail 57498 invoked by uid 99); 6 Apr 2005 16:13:07 -0000
X-ASF-Spam-Status: No, hits=0.1 required=10.0
	tests=FORGED_RCVD_HELO
X-Spam-Check-By: apache.org
Received-SPF: pass (hermes.apache.org: local policy)
Received: from mailserv.cihi.ca (HELO tormail01.cihi.ca) (205.207.78.3)
  by apache.org (qpsmtpd/0.28) with ESMTP; Wed, 06 Apr 2005 09:13:07 -0700
Received: from (10.64.1.106) by webshield.cihi.ca via smtp
	 id 59ab_ebcff532_a6b8_11d9_88fe_003048245df9;
	Wed, 06 Apr 2005 12:28:54 -0400 (EDT)
X-MimeOLE: Produced By Microsoft Exchange V6.5.7226.0
Content-class: urn:content-classes:message
MIME-Version: 1.0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
Subject: RE: Selectkey Tag Question
Date: Wed, 6 Apr 2005 12:12:57 -0400
Message-ID: <373399D6389D8C42B4EAD9BE2B6B5C5F024A1572@tormail01.cihi.ca>
X-MS-Has-Attach: 
X-MS-TNEF-Correlator: 
Thread-Topic: Selectkey Tag Question
Thread-Index: AcU6w0PiVvIDF8jCTZ+T1W1DchTqXAAADa4w
From: "Jason Hall" <JHall@cihi.ca>
To: <ibatis-user-java@incubator.apache.org>,
	"Brandon Goodin" <brandon.goodin@gmail.com>
X-Virus-Checked: Checked
X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N

Thanks!

-----Original Message-----
From: Brandon Goodin [mailto:brandon.goodin@gmail.com]
Sent: Wednesday, April 06, 2005 12:11 PM
To: ibatis-user-java@incubator.apache.org
Subject: Re: Selectkey Tag Question


the selectKey places the value in your java object. The reference you
pass into your insert will then contain the id.

--- service ---

SomeObject someObject =3D new SomeObject();
...
myDao.insertSomeObject(someObject);

Integer myId =3D someObject.getObjectId();

... call some other Dao and pass the myId



--- Dao ---
... insertSomeObject(SomeOjbect someObject) {
  sqlMap.insert("myInsertStatement",someObject);
}



--- sql map ---
<insert...>
<selectKey keyProperty=3D"objectId" resultClass=3D"integer">
 ...
</selectKey>
...
</insert>

Hope that helps,
Brandon

On Apr 6, 2005 9:46 AM, Jason Hall <JHall@cihi.ca> wrote:
> =20
>=20
> Hi,=20
>=20
> I'm using Oracle sequences.  I just wanted to know when using the
> <selectKey> tag, if there is a way to fetch that key in java=20
>=20
> after it has been inserted.  I need this key for other tables.=20
>=20
> Thanks,=20
>=20
> Jason Hall