Hi

I am quite sure, I found one (or two) bug(s) in jaybirds updateable result
set "emulation":

...
Statement statement = connection.createStatement(
ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE );
ResultSet data = statement.executeQuery( "select id, \"SHARED\" from
some$table" );
while ( data.next() ) {
data.updateInt( 2, f(data.getInt( 2 ) ) );
data.updateRow();
}
data.close();
statement.close();
...

Results in:

Exception in thread "main" org.firebirdsql.jdbc.FBSQLException: GDS
Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 4, column 2
SHARED
at
org.firebirdsql.jdbc.FBRowUpdater.executeStatement(FBRowUpdater.java:612)
at
org.firebirdsql.jdbc.FBRowUpdater.updateRow(FBRowUpdater.java:416)
at
org.firebirdsql.jdbc.AbstractResultSet.updateRow(AbstractResultSet.java:2500
)
...
at org.firebirdsql.gds.GDSException: Dynamic SQL Error
SQL error code = -104
Token unknown - line 4, column 2
SHARED
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.readStatusVector(AbstractJ
avaGDSImpl.java:2169)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.receiveResponse(AbstractJa
vaGDSImpl.java:2119)
at
org.firebirdsql.gds.impl.wire.AbstractJavaGDSImpl.iscDsqlPrepare(AbstractJav
aGDSImpl.java:1529)
at
org.firebirdsql.gds.impl.GDSHelper.prepareStatement(GDSHelper.java:189)
at
org.firebirdsql.jdbc.FBRowUpdater.executeStatement(FBRowUpdater.java:573)
at
org.firebirdsql.jdbc.FBRowUpdater.updateRow(FBRowUpdater.java:416)
at
org.firebirdsql.jdbc.AbstractResultSet.updateRow(AbstractResultSet.java:2500
)
...

I think there is a problem with quoted field names. Moreover I earlier tried
with "RDB$DB_KEY" instead of "id". Despite it is mentioned in the release
notes, that never worked, I had to include the primary key.

Regards,
Steffen



[Non-text portions of this message have been removed]