Thread: Statement.executeQuery() and no results

Folks

When we run a query that produces no results, executeQuery() returns
an exception instead of a ResultSet object for which the first call to
next() returns false. (This is with a driver for pgsql 7.3.2)

Here is some code in AbstractJdbc1Statement.java

    /*
     * A Prepared SQL query is executed and its ResultSet is returned
     *
     * @return a ResultSet that contains the data produced by the
     *         *    query - never null
     * @exception SQLException if a database access error occurs
     */
    public java.sql.ResultSet executeQuery() throws SQLException
    {
      this.execute(false);
      while (result != null && !((AbstractJdbc1ResultSet)result).reallyResultSet())
        result = ((AbstractJdbc1ResultSet)result).getNext();
      if (result == null)
        throw new PSQLException("postgresql.stat.noresult");
      return result;
    }

Is my understanding correct ? Is this working as designed ? I'm not
convinced that this is as per the spec. I would rather see a ResultSet
object returned instead of an exception.

--
Pip-pip
Sailesh
http://www.cs.berkeley.edu/~sailesh

On 22 Jul 2003, Sailesh Krishnamurthy wrote:

>
> Folks
>
> When we run a query that produces no results, executeQuery() returns
> an exception instead of a ResultSet object for which the first call to
> next() returns false. (This is with a driver for pgsql 7.3.2)
>

This code will throw an exception if you try calling executeQuery with a
non-select statement.  For example an UPDATE.  If you are getting
unexpected exceptions please post a test case here.

Kris Jurka

On Tue, Jul 22, 2003 at 07:48:49PM -0700, Sailesh Krishnamurthy wrote:
>
> Folks
>
> When we run a query that produces no results, executeQuery() returns
> an exception instead of a ResultSet object for which the first call to
> next() returns false. (This is with a driver for pgsql 7.3.2)

JDBC distinguishes between statements that return a (possibly empty)
ResultSet (e.g. any SELECT) that should use executeQuery() and statements
that return no ResultSet (e.g. INSERT or CREATE TABLE) that should use
executeUpdate().

The JDBC javadoc is a bit clearer than the driver's javadoc on this.

-O

Sailesh,

Something else must be going on here.  As under normal circumstances you
will always get ResultSet even if the query returns now rows.  Can you
send test case that reproduces the problem?

thanks,
--Barry


Sailesh Krishnamurthy wrote:
> Folks
>
> When we run a query that produces no results, executeQuery() returns
> an exception instead of a ResultSet object for which the first call to
> next() returns false. (This is with a driver for pgsql 7.3.2)
>
> Here is some code in AbstractJdbc1Statement.java
>
>     /*
>      * A Prepared SQL query is executed and its ResultSet is returned
>      *
>      * @return a ResultSet that contains the data produced by the
>      *         *    query - never null
>      * @exception SQLException if a database access error occurs
>      */
>     public java.sql.ResultSet executeQuery() throws SQLException
>     {
>       this.execute(false);
>       while (result != null && !((AbstractJdbc1ResultSet)result).reallyResultSet())
>         result = ((AbstractJdbc1ResultSet)result).getNext();
>       if (result == null)
>         throw new PSQLException("postgresql.stat.noresult");
>       return result;
>     }
>
> Is my understanding correct ? Is this working as designed ? I'm not
> convinced that this is as per the spec. I would rather see a ResultSet
> object returned instead of an exception.
>