Submitted by: Steffen Heil (firebirdsql.org_partner.sh-solutions.de)

Assigned to: Roman Rokytskyy (rrokytskyy)

When using updateable result setis with queries that contain quoted field names, an exception is thrown:

...
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
)
...

Commits: 788336e