- Архив списков рассылки pgsql-jdbc

Hello,

I am having a problem with queries that return empty result sets.  Whenever
I execute a query that returns no rows, the driver throws a SQLException:

No results were returned by the query.
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:157)
        at
org.postgresql.jdbc1.AbstractJdbc1Statement.executeQuery(AbstractJdbc1Statem
ent.java:141)

I'm assuming this is not the intended behavior, since it's perfectly
reasonable for a query to return an empty result set.

Looking at the source code for AbstractJdbc1Statement and working backwards,
the following seems to be happening:

1) executeQuery() starts looping over the current results until it finds one
that is "really" a result set
2) either AbstractJdbc1ResultSet.getNext() never returns a non-null result,
or AbstractJdbc1ResultSet.reallyResultSet() never returns true (I didn't
track it down that far).
3) looking at AbstractJdbc1ResultSet.getNext(), it simply returns the next
member variable
4) I didn't track down where the AbstractJdbc1ResultSet.next() method is
called, but this statement on line 65 caught my eye:

 if (++current_row >= rows.size())
                        return false;

However, I'm not sure this is related at all since the "next" member
variable gets set by the append(), and I didn't track down where that is
called.

Any advice on this would be appreciated.

Thanks

Karl