| From: | ng(at)maritimesource(dot)ca (Justin Kennedy) |
|---|---|
| To: | pgsql-jdbc(at)postgresql(dot)org |
| Subject: | executing batch select queries |
| Date: | 2004-08-08 04:02:14 |
| Message-ID: | 802eaf32.0408072002.400e4538@posting.google.com |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | 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
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alexandre Aufrere | 2004-08-08 08:04:02 | Re: Problems with charsets, investigated... |
| Previous Message | Jan de Visser | 2004-08-08 03:12:36 | Re: Problems with charsets, investigated... |