executing batch select queries
От | ng@maritimesource.ca (Justin Kennedy) |
---|---|
Тема | executing batch select queries |
Дата | |
Msg-id | 802eaf32.0408072002.400e4538@posting.google.com обсуждение исходный текст |
Ответы |
Re: executing batch select queries
|
Список | pgsql-jdbc |
Hi, Short version: How can I do batch select queries with jdbc-postgresql? Long version: I'm migrating a transaction management system from Oracle to PostgreSQL. We use batch select queries quite a bit, and to accomplish this in Oracle we just separated the queries with "\n" and ran: stmt.executeQuery(sql). Doing this in PostgreSQL (with a semicolon as a delimeter) generates this error: Cannot handle multiple result groups. So then I figured it wasn't supported and looked up the 'executeBatch' function, but now that leads me to this problem: This works: stmt.executeQuery("select * from pay_methods"); But this doesn't: stmt.clearBatch(); stmt.addBatch("select * from pay_methods"); stmt.executeBatch(); The following error is output: Batch entry 0 .... Call getNextException() to see the cause. calling getNextException() produces this: A result was returned when none was expected. Please advise me on how to accomplish batch select queries. Thanks for the help, -Justin
В списке pgsql-jdbc по дате отправления: