How can I do batch select queries with jdbc-postgresql?
I'm migrating a transaction management system from Oracle to
We use batch select queries quite a bit, and to accomplish this in
Oracle we just separated the queries with "\n" and ran:
Doing this in PostgreSQL (with a semicolon as a delimeter) generates
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:
stmt.executeQuery("select * from pay_methods");
But this doesn't:
stmt.addBatch("select * from pay_methods");
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,
pgsql-jdbc by date
|Next:||From: Alexandre Aufrere||Date: 2004-08-08 08:04:02|
|Subject: Re: Problems with charsets, investigated... |
|Previous:||From: Jan de Visser||Date: 2004-08-08 03:12:36|
|Subject: Re: Problems with charsets, investigated...|