John,
It currently isn't possible in the jdbc driver to get back multiple
result sets. It should be possible since the server returns multiple
result sets, but the jdbc driver doesn't currently handle them.
thanks,
--Barry
Guthrie, John wrote:
>what is the best way to send multiple queries into the database so that I
>can run Statement.execute() and get back multiple result sets? i tried
>something like:
>
>PreparedStatement ps = "select * from table1; select * from table2";
>
>running that I get back only a single result set...
>
>thanks.
>john
>
>---------------------------(end of broadcast)---------------------------
>TIP 2: you can get off all lists at once with the unregister command
> (send "unregister YourEmailAddressHere" to majordomo@postgresql.org)
>
>
>