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 > > > >
