On 18 Nov 2014 02:01:15 -0800, "hugo.larson@... [Firebird-Java]"
<Firebird-Java@yahoogroups.com> wrote:

> 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

That is probably a different problem altogether. I will look into it. I
will have to check who is generating code here, the default CachedRowSet
implementation, or Jaybird.

Mark