Interclient does not have scrollable result sets, so basically anything
except next() is going to fail. Is there some reason you'd want to use
them? They always seemed to me a way to make the driver inefficient;-)

david jencks

On 2001.12.18 19:57:10 -0500 davcamer wrote:
> 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
>
>
>
> To unsubscribe from this group, send an email to:
> IB-Java-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>
>
>