Subject Re: [Firebird-Java] Differences between TYPE 2 and TYPE 4
Author Roman Rokytskyy
> I tried out the TYPE 2 driver today for the heck of it, using the
> :local:<path> option.
>
> Is error handling much different between these two types of drivers?
> An application that has run fine for a long time with TYPE4 gets
> this exception with the TYPE2 driver:
>
> Caused by: org.firebirdsql.jdbc.FBSQLException: GDS Exception.
> 335544569. Dynamic SQL Error
> SQL error code = -502
> Attempt to reopen an open cursor

I have discovered this bug before :) It happened in EMBEDDED mode (and
according to your report in LOCAL, but not when connecting via IPC) when a
query is executed using PreparedStatement, but returns no result. In this
case engine believes that cursor in open, though a driver had different
idea. When the same code is executed with remote server, everything is ok.

I will commit the fix to HEAD and Branch_1_5 today and it will appear in the
next point release (probably somewhere within next two weeks).

Roman