Mailing-List: contact user-java-help@ibatis.apache.org; run by ezmlm
Precedence: bulk
Reply-To: user-java@ibatis.apache.org
Received-SPF: pass (herse.apache.org: domain of larry.meadors@gmail.com
 designates 64.233.184.231 as permitted sender)
DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws;
        s=beta; d=gmail.com;
        h=received:message-id:date:from:reply-to:sender:to:subject:in-reply-to:mime-version:content-type:content-transfer-encoding:content-disposition:references:x-google-sender-auth;
        b=jZUWC70lT98M8pTkb+AhwyfxlYCspLKVl1XXhYue2bHzRO8xiIfBVqeeMhySXOvOYEZZVt6ea7dmWOY0f/2YtZFL2hf7PfUtEjJ4hm0vSQXI7ncxjn1h+qUGydf0B55QV59fRHdVyoI8+kFw8agoHVyoD6kN1BW4Uyii6izByDs=
Message-ID: <a10a823c0701050724m16243fd3se7526b0034417285@mail.gmail.com>
Date: Fri, 5 Jan 2007 08:24:35 -0700
From: "Larry Meadors" <lmeadors@apache.org>
Reply-To: lmeadors@apache.org
Sender: larry.meadors@gmail.com
To: user-java@ibatis.apache.org
Subject: Re: Data insertion into Parent and Child table -- How to do this
 while batch insert in IBatis
In-Reply-To: <002801c730d3$6360cef0$4514a8c0@ZSPL.local>
MIME-Version: 1.0
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit
Content-Disposition: inline
References: <002801c730d3$6360cef0$4514a8c0@ZSPL.local>

IIRC, your batch will be lots faster in a transaction, and if you do this:

start transaction
  insert parent
  start batch
    insert children
  end batch
end transaction

I think you'll be OK.

Larry


On 1/5/07, Deepinder <dmahi@zymesolutions.com> wrote:
>
>
>
>
>
>
> Hi,
>
>
>
> Is it possible to insert data into a parent table and then use the generated
> primary key to insert into a child table.
>
> I need to do this during a batch insert as it is necessary(performance).
>
>
>
> Thanking you for any lead that may be provided in solving this problem.(I
> spent a day , on this problem J)
>
>
>
> The sample code below has a comment specifying where the problem is
>
>
>
> public void batchInsertTable(
>
>                                     final List beanList) {
>
>
>
>
> getSqlMapClientTemplate().execute(new
> SqlMapClientCallback() {
>
>
>
>                                     public Object
> doInSqlMapClient(SqlMapExecutor executor)
>
>                                                             throws
> SQLException {
>
>
>
>                                                 executor.startBatch();
>
>
>
>                                                 for (int i = 0; i <
> beanList.size(); i++) {
>
>                                                             Integer
> primaryKey = (Integer)executor.insert("populateTable",
>
>
>        beanList.get(i));
>
>
> //use primaryKey for storing info in child table
>
> //Problem is that in batch insert the primarykey value returned is random
> number (not the //one in database)
>
>                                                 }
>
>
>
>                                                 executor.executeBatch();
>
>                                                 return null;
>
>                                     }
>
>
>
>                         });
>
>
>
>             }