Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-jdbc by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group