Re: "No results were returned by the query" exceptions

-----Original Message-----
From: tlewis@kyle.sinewave.com.au [mailto:tlewis@kyle.sinewave.com.au] On Behalf Of Tim Lewis
Sent: Tuesday, March 19, 2002 10:49 PM
To: Dave@micro-automation.net
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] "No results were returned by the query" exceptions

No difference.  Downloaded the driver (http://jdbc.postgresql.org/download/devpgjdbc2.jar) and have had the same problem.

It doesn't appear to have anything to do with the locking.  I have had it throw the same exception on a "select nextval ('my_sequence')" query which doesn't make any sense at all.

The machine is running an SMP kernel with two processes accessing the database (two database connections / driver instances etc).  I have been running the same code for about a month in development using the previous driver with no problems.  The development server was a single processor machine running a non-SMP kernel.

 Tim.

Dave Cramer wrote:

Tim,The latest driver which is experimental doesn't throw an exception and I copied your lock as wellcan you try it, it is the dev driver on the jdbc site.let me know what else you find, if anythingDave

-----Original Message-----
From: pgsql-jdbc-owner@postgresql.org [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tim Lewis
Sent: Tuesday, March 19, 2002 9:45 PM
To: Dave@micro-automation.net
Cc: pgsql-jdbc@postgresql.org
Subject: Re: [JDBC] "No results were returned by the query" exceptions

For what its worth Dave,  there are two places in my code where it the exception occurs and with both of them there is a prior statement to lock the table in share row exclusive mode. ie:

Statement st = db.createStatement();
st.executeUpdate("lock table tablex in share row exclusive mode");

String statment = "select col1 from tablex where col2 = ?";
PreparedStatement ps = db.prepareStatement(statement);
ps.setString(1, col2text);
ResultSet rs = ps.executeQuery();     // <- Exception thrown here
 

It may be coincidental but I thought it would be remiss of me to leave it out.

Tim.

Dave Cramer wrote:

Yes,

I can confirm that it does indeed throw an exception. I will have a look
at this shortly.

Thanks,

Dave

> -----Original Message-----
> From: pgsql-jdbc-owner@postgresql.org
> [mailto:pgsql-jdbc-owner@postgresql.org] On Behalf Of Tim Lewis
> Sent: Tuesday, March 19, 2002 7:01 PM
> To: pgsql-jdbc@postgresql.org
> Subject: [JDBC] "No results were returned by the query" exceptions
>
>
> Hi people,
>
> Am I correct in assuming that the new driver now throws an
> exception when a "No results were returned by the query"
> occurs for a prepared sql statement.  I have recently
> upgraded the driver from 7.1 to 7.2 and my application now
> throws this exception when a query returns no rows in the result set.
>
> Could someone clarify this with me.
>
> Thanks,
>
> Tim Lewis
>
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 6: Have you searched our list archives?
>
http://archives.postgresql.org

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

http://archives.postgresql.org