RE: getMoreResults() returns false incorrectly

I agree (though -- according to Sun's sample code I was referring to --
the thing that "already exists" need not be a result set, but could
instead be an update count).

Thanks very much for taking the time to investigate and respond.

Bob

On Tue, 27 Jun 2000, Peter Mount wrote:

> This sounds correct. If you think about it, getMoreResults() does
> seem to imply it get's another ResultSet, implying that one already
> exists.
>
> Peter
>
> --
> Peter Mount
> Enterprise Support
> Maidstone Borough Council
> Any views stated are my own, and not those of Maidstone Borough Council
>
>
> -----Original Message-----
> From: Bob Kline [mailto:bkline(at)rksystems(dot)com]
> Sent: Monday, June 26, 2000 5:13 PM
> To: Peter Mount
> Cc: pgsql-interfaces(at)postgresql(dot)org
> Subject: RE: [INTERFACES] getMoreResults() returns false incorrectly
>
>
> I believe I've figured out what the problem is. The JDBC API
> documentation doesn't say so explicitly, but the example code in Sun's
> JDBC tutorial implies that you can only call getMoreResults() after you
> have retrieved either the first update count (with getUpdateCount()) or
> the first result set.
>
> So the version of the code below which works would be:
>
> Statement stmt = conn.createStatement();
> stmt.execute(queryString);
> for (;;) {
> int updateCount = stmt.getUpdateCount();
> if (updateCount >= 0) {
> // report update count ...
> }
> else {
> ResultSet rs = stmt.getResultSet();
> if (rs == null)
> break;
> // process resultset ....
> }
> stmt.getMoreResults();
> }
>
> Bob
>
> On Mon, 26 Jun 2000, Peter Mount wrote:
>
> > I'll look into this, as the psql example included with the source
> > uses this method in this way.
> >
> > Peter
> >
> > -----Original Message-----
> > From: Bob Kline [mailto:bkline(at)rksystems(dot)com]
> > Sent: Tuesday, June 20, 2000 11:25 AM
> > To: pgsql-interfaces(at)postgresql(dot)org
> > Subject: [INTERFACES] getMoreResults() returns false incorrectly
> >
> >
> > [Second submission; first seems to have disappeared.]
> >
> > I tried to search the list archives, but the search engine appears to be
> > broken (comes back with an http 404 error).
> >
> > Using the Postgresql JDBC driver (I'm testing with jdbc7.0-1.1.jar) it
> > appears that Statement.getMoreResults() returns false even if there is a
> > result set from the query just executed.
> >
> > Statement stmt = conn.createStatement();
> > stmt.execute("SELECT * FROM t");
> > if (stmt.getMoreResults()) {
> > ResultSet rs = stmt.getResultSet();
> > while (rs.next()) {
> > // process row ....
> > }
> > }
> >
> > The call to getMoreResults() returns false consistently. If the call is
> > replaced with 'if (true) ...' then the code to get the result set and
> > process the rows works fine.
> >
> > Accoring to the JDBC docs, this method should return "true if the next
> > result is a ResultSet; false if it is an update count or there are no
> > more results." There is no update count (as confirmed by
> > getUpdateCount()).
> >
> > Is this a known problem? If this method doesn't work as documented,
> > it's impossible to "work with an unknown SQL string" as the
> > documentation for execute() indicates we should be able to (without
> > parsing the SQL query).
> >
>

--
Bob Kline
mailto:bkline(at)rksystems(dot)com
http://www.rksystems.com