Re: "No Results were returned by the query" exception

Thanks for the reply Joe.

I am using PostGreSQL 7.2.1 with JDBC driver of http://jdbc.postgresql.org/download/devpgjdbc2.jar.

Code is:

  public int getNextValue(
      String                           sequenceName )
      throws SQLException {
    checkAll(sequenceName);
    Statement s = null ;
    ResultSet rs = null ;
    try {
      s = connection.createStatement() ;
      rs = s.executeQuery("SELECT nextval('"+sequenceName+"')");
      if (!rs.next()) {
        throw new SQLException("No Rows Returned from Sequence " + sequenceName);
      } //end if
      int returnValue = rs.getInt(1) ;
      rs.close();
      s.close();
      return returnValue ;
    } catch (SQLException e) {
      if (rs != null) {
        rs.close();
      } //end if
      if (s != null) {
        s.close();
      } //end if
      throw e ;
    } //end try
  } //end getNextValue()

And yes I am using it from within a transaction.

What is odd is it is not consistant.  This same code runs fine for a lot of things.

My guess is that there is a variable that is not being reset properly in the driver.  That would explain why
it does not happen all the time.  In this case, I am receiving an error when running the above code after an
INSERT statement on the same connection.

Jon

On Thursday 06 June 2002 04:02 pm, Joe Shevland wrote:
> Sorry I'm not across the actual issue, but have you got a small snippet of
> Java code to demonstrate the problem (enough to see if its inside a
> transaction etc and how you're executing the statement and looping through
> the RS)? Also the version number of the PostgreSQL backend.
>
> I do the below sort of thing regularly and haven't had a problem. The
> drivers on http://jdbc.postgresql.org/download are the best ones to go for
> if you're not already using those.
>
> Cheers,
> Joe