Subject Exception in Connection.prepareStatement() (Jaybird 1.5.5/ Firebird 1.5.2)
Author davidjbyrne
I had an application that ran fine using Interclient / Interbase.
When I ported it over to Jaybird / Firebird I started getting the
following low level exception intermittently. Has anyone seen this
before?

java.lang.ArrayIndexOutOfBoundsException: 2

at org.firebirdsql.jgds.GDS_Impl.isc_vax_integer
(GDS_Impl.java:1405)

at org.firebirdsql.jgds.GDS_Impl.parseTruncSqlInfo
(GDS_Impl.java:2028)

at org.firebirdsql.jgds.GDS_Impl.parseSqlInfo
(GDS_Impl.java:1992)

at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare
(GDS_Impl.java:1268)

at org.firebirdsql.jca.FBManagedConnection.prepareSQL
(FBManagedConnection.java:773)

at org.firebirdsql.jdbc.AbstractConnection.prepareSQL
(AbstractConnection.java:958)

at
org.firebirdsql.jdbc.AbstractStatement.prepareFixedStatement
(AbstractStatement.java:1047)

at
org.firebirdsql.jdbc.AbstractPreparedStatement.prepareFixedStatement
(AbstractPreparedStatement.java:904)

at org.firebirdsql.jdbc.AbstractPreparedStatement.<init>
(AbstractPreparedStatement.java:86)

at org.firebirdsql.jdbc.FBPreparedStatement.<init>
(FBPreparedStatement.java:34)

at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:701)

at
org.firebirdsql.jdbc.AbstractConnection.prepareStatement
(AbstractConnection.java:232)

at
com.pangonetworks.ui.survey.site.core.DeploymentPeer.deleteProperties
(DeploymentPeer.java:123)


The code that causes this is :

-> PreparedStatement dProps = conn.prepareStatement("DELETE
FROM deployment_prop WHERE id = ?");


Is this a known bug? Is there any way to work around it?

Thanks,

Dave