jdbc driver Multiple Resultsets

From: "Rajesh Balla" <bnrajesh(at)lycos(dot)com>
To: pgsql-jdbc(at)postgresql(dot)org
Subject: jdbc driver Multiple Resultsets
Date: 2001-04-12 02:33:54
Message-ID: EAEGPPNBMKIBMAAA@mailcity.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-jdbc by date

  From Date Subject
Next Message chris markiewicz 2001-04-12 13:35:50 RE: fastpath error?
Previous Message Gilles DAROLD 2001-04-11 20:06:48 Oracle to PostgreSQL