Subject | Re: [Firebird-Java] CachedRowSet problem |
---|---|
Author | |
Post date | 2014-11-18T10:01:15Z |
Hi Mark,
I have tried an even more trivial example.
Connectioncon = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);
con.setAutoCommit(false);
CachedRowSet set = RowSetProvider.newFactory().createCachedRowSet();
set.setCommand("select * from product order by 1");
set.execute();
set.absolute(5);
set.updateString("NAME", "HEJ");
set.updateRow();
set.acceptChanges(con);
The "order by 1" cause at acceptChanges:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 331
WHERE
Hugo
I have tried an even more trivial example.
Connectioncon = DriverManager.getConnection(JDBC_URL, USER, PASSWORD);
con.setAutoCommit(false);
CachedRowSet set = RowSetProvider.newFactory().createCachedRowSet();
set.setCommand("select * from product order by 1");
set.execute();
set.absolute(5);
set.updateString("NAME", "HEJ");
set.updateRow();
set.acceptChanges(con);
The "order by 1" cause at acceptChanges:
org.firebirdsql.jdbc.FBSQLException: GDS Exception. 335544569. Dynamic SQL Error
SQL error code = -104
Token unknown - line 1, column 331
WHERE
Hugo