jdbc driver Multiple Resultsets - Mailing list pgsql-jdbc

Does the jdbc driver really support Multiple Resultsets?
If not, does the backend return multiple resultsets(for more than one query concatenated together)?

ie., For a query like
    ResultSet rs = stmt.executeQuery("select * from table1; select * from table2;");
    Does the resultset contain both the resultsets or only one result set.

Note:
On Sat, 25 Apr 1998, Bruce Momjian wrote:

The JDBC spec allows for multiple ResultSet`s to be returned from a query, and our driver handles this already.
......
But when we tried doing the above query, the resultset had only the first resultset.

So,Does the jdbc driver really support Multiple Resultsets?

Thanks,
Rajesh


Get 250 color business cards for FREE! at Lycos Mail
http://mail.lycos.com/freemail/vistaprint_index.html