Hello

Between versions RC1a and RC2 the ResultSetMetaData.getPrecision method that previously return a wrong value was changed. Now the method take the precision value from the metadata tables in the database.

From your previous mail, I suppose you use dialect 3. It is true?.

Please send us your query and table definition, this will help to analyze the problem.

I suspect the problem can be calculated columns or the table name for a column.

Regards
Blas Rodriguez Somoza.

At 09/01/2003 17:14 +0200, Haris Papadopoulos wrote:

>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.
>
>To unsubscribe from this group, send an email to:
>Firebird-Java-unsubscribe@yahoogroups.com
>
>
>
>Your use of Yahoo! Groups is subject to the <http://docs.yahoo.com/info/terms/>Yahoo! Terms of Service.