db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Kristian Waagan <Kristian.Waa...@Sun.COM>
Subject Re: 'updateString' not allowed because the ResultSet is not an updatable ResultSet
Date Mon, 02 Feb 2009 16:03:10 GMT
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

> 


Mime
View raw message