Subject testing RC2: strange GDSException on a query
Author Haris Papadopoulos
Hi again,
 
I 've been testing my web-apps using a cvs-built version of JBird(just after rc1a).
Today, I tried rc2. When it tries to execute a certain SELECT query that worked before,
I get the following stack trace(as you can see I am using a JBuilder API,
I don't know if there is a relation):
 
org.firebirdsql.gds.GDSException: invalid request BLR at offset 1786
context already in use (BLR error)
        at org.firebirdsql.jgds.GDS_Impl.readStatusVector(GDS_Impl.java:1677)
        at org.firebirdsql.jgds.GDS_Impl.receiveResponse(GDS_Impl.java:1630)
        at org.firebirdsql.jgds.GDS_Impl.isc_dsql_prepare(GDS_Impl.java:1171)
        at org.firebirdsql.jca.FBManagedConnection.prepareSQL(FBManagedConnectio
n.java:762)
        at org.firebirdsql.jdbc.FBConnection.prepareSQL(FBConnection.java:1082)
        at org.firebirdsql.jdbc.FBStatement.prepareFixedStatement(FBStatement.ja
va:919)
        at org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement(FBPrep
aredStatement.java:694)
        at org.firebirdsql.jdbc.FBPreparedStatement.prepareFixedStatement(FBPrep
aredStatement.java:694)
        at org.firebirdsql.jdbc.FBPreparedStatement.<init>(FBPreparedStatement.j
ava:73)
        at org.firebirdsql.jdbc.FBConnection.prepareStatement(FBConnection.java:
223)
        at org.firebirdsql.jdbc.FBConnection.getStatement(FBConnection.java:1153
)
        at org.firebirdsql.jdbc.FBConnection.doQuery(FBConnection.java:1178)
        at org.firebirdsql.jdbc.FBResultSetMetaData.getExtendedFieldInfo(FBResul
tSetMetaData.java:804)
        at org.firebirdsql.jdbc.FBResultSetMetaData.getExtFieldInfo(FBResultSetM
etaData.java:643)
        at org.firebirdsql.jdbc.FBResultSetMetaData.getPrecision(FBResultSetMeta
Data.java:313)
        at com.borland.dx.sql.dataset.RuntimeMetaData.a(Unknown Source)
        at com.borland.dx.sql.dataset.JdbcProvider.c(Unknown Source)
        at com.borland.dx.sql.dataset.JdbcProvider.provideData(Unknown Source)
        at com.borland.dx.dataset.StorageDataSet.refresh(Unknown Source)
        at com.borland.dx.sql.dataset.QueryDataSet.refresh(Unknown Source)
Note that the query joins two tables one of which has many fields (and blobs) if that matters. I realized though that the number of rows is irrelevant.
Note also that other queries work fine.
I don't know if all the above can help the list, I hope that someone can locate the problem.
 
Thanx,
Haris.