Re: jdbc driver Multiple Resultsets

Quoting Rajesh Balla <bnrajesh@lycos.com>:

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

The driver has had the capability for years. However the backend doesn't
support this (AFAIK).

> ie., For a query like
>     ResultSet rs = stmt.executeQuery("select * from table1; select *
> from table2;");

This isn't proper JDBC. Multiple ResultSet's is where a stored procedure
returns them, not multiple queries.

Peter

--
Peter Mount peter@retep.org.uk
PostgreSQL JDBC Driver: http://www.retep.org.uk/postgres/
RetepPDF PDF library for Java: http://www.retep.org.uk/pdf/