Batch with keygen?

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

Responses

Browse pgsql-jdbc by date

  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