Return-Path: Delivered-To: apmail-ibatis-user-java-archive@www.apache.org Received: (qmail 2883 invoked from network); 18 Jul 2007 10:21:53 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (140.211.11.2) by minotaur.apache.org with SMTP; 18 Jul 2007 10:21:53 -0000 Received: (qmail 73004 invoked by uid 500); 18 Jul 2007 10:21:39 -0000 Delivered-To: apmail-ibatis-user-java-archive@ibatis.apache.org Received: (qmail 72992 invoked by uid 500); 18 Jul 2007 10:21:39 -0000 Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm Precedence: bulk List-Help: List-Unsubscribe: List-Post: List-Id: Reply-To: user-java@ibatis.apache.org Delivered-To: mailing list user-java@ibatis.apache.org Received: (qmail 72972 invoked by uid 99); 18 Jul 2007 10:21:38 -0000 Received: from herse.apache.org (HELO herse.apache.org) (140.211.11.133) by apache.org (qpsmtpd/0.29) with ESMTP; Wed, 18 Jul 2007 03:21:38 -0700 X-ASF-Spam-Status: No, hits=0.0 required=10.0 tests=UPPERCASE_25_50 X-Spam-Check-By: apache.org Received-SPF: pass (herse.apache.org: local policy includes SPF record at spf.trusted-forwarder.org) Received: from [203.84.221.128] (HELO web8707.mail.in.yahoo.com) (203.84.221.128) by apache.org (qpsmtpd/0.29) with SMTP; Wed, 18 Jul 2007 03:21:35 -0700 Received: (qmail 81701 invoked by uid 60001); 18 Jul 2007 10:21:13 -0000 DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=s1024; d=yahoo.co.in; h=X-YMail-OSG:Received:Date:From:Subject:To:MIME-Version:Content-Type:Content-Transfer-Encoding:Message-ID; b=V40gqL3nasDpft71MN029ppNt76B/sKG29UDNAwoqNmYmkPe8cuMSZ1ywYirozXQLB7X+B/hmmhPMHzfyX1ELtOHBqr/yBlZoKNw7ifo00V/BKt34M+qDchMEsHoZqSuvE4Tcs1pv1/63x2+nYe2kqyqk9Vwql6dWtQH1DtOojM=; X-YMail-OSG: C67hUaMVM1kPaQp8rNFz2WCiIzvv8k2iRCuVUEzTFB3UV3hTN0rp5fj_qRFLySR9JksVoLrcZsvAasRrOLGIGtrL_OJx.0z_GL8M_4FoAHYf0azQTOQ- Received: from [210.18.83.173] by web8707.mail.in.yahoo.com via HTTP; Wed, 18 Jul 2007 11:21:12 BST Date: Wed, 18 Jul 2007 11:21:12 +0100 (BST) From: felix thomas Subject: Multiple inserts in table with same sequence id To: user-java@ibatis.apache.org MIME-Version: 1.0 Content-Type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit Message-ID: <18626.81529.qm@web8707.mail.in.yahoo.com> X-Virus-Checked: Checked by ClamAV on apache.org Hi, I have to insert in 1 Parent table and 4 child tables . I have written sqlMap which inserts in the parent table as below. SELECT record_id.NEXTVAL AS ID FROM DUAL insert into FIELD (FIELD_ID, NAME, OBJECT_ID, SORT_ORDER, FIELD_SIZE, FIELD_TYPE_ID, FIELD_TYPE_CODE, DEFAULT_VALUE, IS_STANDARD, IS_PRIMARY_KEY, IS_REQUIRED, IS_UNIQUE_VALUE, IS_UNIQUE_IGNORE_CASE, IS_EXTERNAL_ID, IS_CHANGE_RECORDS, IS_TRACK_CHANGES, LENGTH, DECIMAL_PLACES, DISPLAY_FORMAT, STARTING_NUMBER, PARENT_OBJECT_ID, LOV_TYPE_ID, IS_LOV_SORT, IS_LOV_DEFAULT_FIRST,FORMULA_FIELD_TYPE_ID, VISIBLE_LINES, CONTROLLING_FIELD_ID, PARENT_SIZE, CHILD_SIZE, LANGUAGE_ID, LABEL, DESCRIPTION, CREATED_BY, CREATED_ON, MODIFIED_BY, MODIFIED_ON) values (#fieldId#,#name:VARCHAR#, 2593, #sortOrder:VARCHAR#, #fieldSize:NUMERIC#, #fieldTypeId:NUMERIC#, #fieldTypeCode:NUMERIC#, #defaultValue:OTHER#, 'Y','N','Y','N', 'N','N','N','N', #length:NUMERIC#, #decimalPlaces:NUMERIC#, #displayFormat:VARCHAR#, #startingNumber:NUMERIC#, #parentObjectId:NUMERIC#, #lovTypeId:NUMERIC#, #isLovSort:CHAR#, #isLovDefaultFirst:CHAR#, #formulaFieldTypeId:NUMERIC#, #visibleLines:NUMERIC#, #controllingFieldId:NUMERIC#, #parentSize:VARCHAR#, #childSize:VARCHAR#,6, #label#, #description#,1,'17-Jul-2007',1,'17-Jul-2007') My problem is that i want the fieldId which is generated in the sequence to be passed to different insert statements for the child tables. Can it be done in Ibatis. Hope my question is clear. Parent table i record inserted , the fieldid generated has to be passed to insertion in child table which has fielid as foreign key. 1 Field -> Multiple columns kind of secario. Regards, Felix T Get the freedom to save as many mails as you wish. To know how, go to http://help.yahoo.com/l/in/yahoo/mail/yahoomail/tools/tools-08.html