Batch with keygen?
От | Mike Clements |
---|---|
Тема | Batch with keygen? |
Дата | |
Msg-id | 06B12D1D68BCCA4CB1F60BB4EA509768245476@pq-exch01.actional.com обсуждение исходный текст |
Ответы |
Re: Batch with keygen?
|
Список | 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@actional.com FREE! Actional SOAPstation Developer Version Web services routing, security, transformation and versioning http://www.actional.com/sstdownload
В списке pgsql-jdbc по дате отправления: