Subject | testing RC2: strange GDSException on a query |
---|---|
Author | Haris Papadopoulos |
Post date | 2003-01-09T15:14:08Z |
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)
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.