From: | "Mike Clements" <mclements(at)actional(dot)com> |
---|---|
To: | <pgsql-jdbc(at)postgresql(dot)org> |
Subject: | Batch with keygen? |
Date: | 2005-11-07 18:33:43 |
Message-ID: | 06B12D1D68BCCA4CB1F60BB4EA509768245476@pq-exch01.actional.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-jdbc |
Hi everyone,
I've got a bunch of PreparedStatements doing inserts on tables with
primary keys generated by sequences. For example, insert on table A,
take generated primary key, insert on table B assigning foreign key
generated value for A's primary key.
For performance reasons, I need to batch these commands. But I don't see
how it would be possible to continue using this approach with a batch of
commands, because I need the results of the first insert to make the
second insert. Is there some way to do this or am I going to have to
stop using keygen and instead have my application generate its own keys?
Thanks.
Michael R. Clements
Principal Architect, Actional Corp.
mclements(at)actional(dot)com
FREE! Actional SOAPstation Developer Version
Web services routing, security, transformation and versioning
http://www.actional.com/sstdownload
From | Date | Subject | |
---|---|---|---|
Next Message | Kris Jurka | 2005-11-07 19:53:10 | Re: Using WebRow set with Postgresql JDBC drivers... |
Previous Message | Heikki Linnakangas | 2005-11-07 14:07:17 | Re: Stable JDBC drivers for 8.1 |