John T. Dow wrote:
I get this error message:
'updateString' not allowed because the ResultSet is not an updatable
ResultSet.
It happens after creating a result set with this query:
select * from orders where (orders.recordno = (select max(orders.recordno) from
orders))
--snip--
Hi John,
I think the problem is the subquery in the WHERE clause. This
restriction is not listed in the documentation (the reference manual
only mentions subqueries in the FROM clause), but the code actually
makes the cursor read-only if it finds a subquery in a WHERE clause.
It would be great if you could log this in the bug tracker
(https://issues.apache.org/jira/browse/DERBY) so that we can get the
documentation fixed or, if there's no need for the restriction, get the
restriction lifted.
Logged.
FYI, the issue was logged as DERBY-4045: Subquery causes error:
'updateString' not allowed because the ResultSet is not an updatable
ResultSet
https://issues.apache.org/jira/browse/DERBY-4045
--
Kristian
