I'm new so I probably don't know what I'm talking about, but wouldn't it be
faster to use SQL to create all this and just return a list of parents? I
guess unless each parent and child needs to be edited. Then Nathan's code is
the way to go.
On Jan 2, 2008 10:02 PM, Nathan Maves <[EMAIL PROTECTED]> wrote:
> we in my dao layer I would have something like...
> psudeo {
> batch insert the 100 partents
>
> foreach(parent) {
> batch the 100 children;
> collection = queryForList("getChildren",parentId);
> }
> }
>
> On Jan 2, 2008 5:55 PM, Gregg Bolinger < [EMAIL PROTECTED]> wrote:
>
> > Well, the problem is that I need them for a parent child relationship.
> > Are there any known solutions?
> >
> > So say I batch insert 100 parents. And then I need to batch insert 100
> > children for each parent. What is the best way to achieve this?
> >
> > Thanks.
> >
> > Gregg
> >
> >
> > On Jan 2, 2008 6:37 PM, Nathan Maves < [EMAIL PROTECTED]> wrote:
> >
> > > Gregg,
> > > The underlyng call is to
> > > http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#executeBatch()
> > >
> > > <http://java.sun.com/j2se/1.5.0/docs/api/java/sql/Statement.html#executeBatch%28%29>which
> > > as you can see from the javadocs only returns the number of effected
> > > rows.
> > >
> > > I don't know of any way that would allow you to return the ids for
> > > each batched insert with the current java.sql api's.
> > >
> > >
> > > Nathan
> > >
> > >
> > > On Jan 2, 2008 4:56 PM, Gregg Bolinger < [EMAIL PROTECTED]>
> > > wrote:
> > >
> > > > If doing a batch insert on several objects I can't seem to retrieve
> > > > the auto_increment key using the <selectKey /> tag. Individual inserts
> > > > work
> > > > just fine. Is this expected?
> > > >
> > > > Thanks.
> > > >
> > > > Gregg
> > > >
> > >
> > >
> >
>
--
"All that is necessary for the triumph of evil is that good men do nothing."
Edmund Burke
