Re: How to get multiple result sets

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@xxxxxxxxxxxxxx)
>
>  



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)