db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "John T. Dow" <j...@johntdow.com>
Subject Re: 'updateString' not allowed because the ResultSet is not an updatable ResultSet
Date Mon, 02 Feb 2009 15:36:28 GMT
>> 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.


Mime
View raw message