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/