Subject Re: [Firebird-Java] CachedRowSet problem
Author
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