Re: Statement.executeQuery() and no results

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.



---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command
   (send "unregister YourEmailAddressHere" to majordomo@xxxxxxxxxxxxxx)