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

Re: BUG #4617: JDBC Drivers 8.2/8.3 return no ResultSet

From: Kris Jurka <books(at)ejurka(dot)com>
To: "Raymond L(dot) Naseef" <naseef(at)egr(dot)msu(dot)edu>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #4617: JDBC Drivers 8.2/8.3 return no ResultSet
Date: 2009-01-16 22:14:04
Message-ID: Pine.BSO.4.64.0901161706370.32207@leary.csoft.net (view raw or flat)
Thread:
Lists: pgsql-bugs

On Thu, 15 Jan 2009, Raymond L. Naseef wrote:

>
> The following bug has been logged online:
>
> Bug reference:      4617
> PostgreSQL version: 8.3 & 7.4
> Operating system:   FreeBSD
> Description:        JDBC Drivers 8.2/8.3 return no ResultSet
> Details:
>
> Below is query using temporary table instead of "IN" to greatly improve
> performance.  This worked in older JDBC driver, but no longer does.  The
> following were checked, making no difference:
>
> RESULT:
> 	org.postgresql.util.PSQLException: No results were returned by the query.
>
>
> QUERY:
> ------
> create temporary table lookup_username (username varchar) on commit drop;
> insert into lookup_username values ('naseef');
> CREATE UNIQUE INDEX lookup_username_idx
> ON lookup_username
> USING btree
> (username);
>
> SELECT enp.username, trim(enp.full_name)
> FROM egr_nis_person as enp
> JOIN lookup_username as lu
> ON lu.username = enp.username
> WHERE enp.start_date < now() + interval '30 seconds'
> AND enp.end_date > now() + interval '30 seconds';
>

What's happening here is that you are actually issuing four commands, not 
a single query.  The newer drivers will return a status for each command 
executed, and won't just give you the final select result.  For 
multi-command statements you should use Statement.execute() and then 
getResultSet or getUpdateCount until getMoreResults is false.

Kris Jurka

In response to

Responses

pgsql-bugs by date

Next:From: Raymond NaseefDate: 2009-01-17 00:11:36
Subject: Re: BUG #4617: JDBC Drivers 8.2/8.3 return no ResultSet
Previous:From: John R PierceDate: 2009-01-16 22:06:13
Subject: Re: can not install

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