Subject ResultSet.first() not supported?
Author davcamer
I've been writing a java application that queries a
firebird/IBPhoenix database through the interclient.jar drivers.

I'm getting the following exception:

interbase.interclient.DriverNotCapableException: [interclient]
Unsupported feature: Using a JDBC 2 method which is not yet supported.
See API reference for exception
interbase.interclient.DriverNotCapableException
at interbase.interclient.ResultSet.first(ResultSet.java:2208)
at DbInterface.checkMessages(DbInterface.java:50)
at SMSDaemon.run(SMSDaemon.java:13)
at java.util.TimerThread.mainLoop(Timer.java:436)
at java.util.TimerThread.run(Timer.java:386)

Unfortunately I don't have the sources to
interbase.interclient.ResultSet, but the spec at
http://www.aoindustries.com/docs/interclient/specifications/
certainly gave me the impression that ResultSet.first() was
supported. Could some other misconfiguration be causing the error?

I have the Firebird Interclient 2.01 jdk 1.3 from www.ibphoenix.com
I have the FirebirdSS for linux 1.00RC1 from www.ibphoenix.com
I got the Firebird Interserver from the linux InterClient tar 2.01
jdk 1.3 from ibphoenix.com (yes, everything I have is from
ibphoenix.com)
I have the jdbc2_0-stdext.jar from java.sun.com on the host building
the application (but not on the host the server is running on...
maybe this is a problem?)

I think these are all the parts involved. CommDiag reports back a
healthy server; my client app is connection fine, but then this
exception is being thrown on the following lines:

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

Any help would be much appreciated, and if the stdext.jar turns out
to be the problem I'll post a quick note back here.

Dave