Subject Re: ResultSet.first() not supported?
Author ftaccess
--- In IB-Java@y..., "davcamer" <dave@n...> wrote:
> Unfortunately I don't have the sources to
> interbase.interclient.ResultSet,

The sources are in the CVS at
http://sourceforge.net/projects/firebird

>but the spec at
> http://www.aoindustries.com/docs/interclient/specifications/
> certainly gave me the impression that ResultSet.first() was
> supported.

Those specs indicate "JDBC 2, NOT YET SUPPORTED" for that method

> ResultSet rs = stmt.executeQuery("SELECT * FROM MESSAGE_WAIT");
> if (rs.first() == false){

Try something along the lines of:

if (rs.next() == false ) {
// result set is empty
} else {
// get the result and process it
}

Fred