Subject Differences between TYPE 2 and TYPE 4
Author Robert DiFalco
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
at
org.firebirdsql.jdbc.AbstractPreparedStatement.internalExecute(AbstractP
reparedStatement.java:503)
at
org.firebirdsql.jdbc.AbstractPreparedStatement.executeQuery(AbstractPrep
aredStatement.java:109)
at
com.tripwire.space.core.persistence.db.CachedPreparedStatement.executeQu
ery(ConnectionPool.java:1244)
at
com.tripwire.space.core.persistence.db.StatementStream.executeQuery(Stat
ementStream.java:51)
at
com.tripwire.space.core.persistence.db.QueryContext.apply(QueryContext.j
ava:295)
... 14 more