[jira] Created: (DERBY-4138) Adding an "ORDER BY" clause breaks updatable result sets

[Alan Burlison (JIRA)]

Adding an "ORDER BY" clause breaks updatable result sets
--------------------------------------------------------

                 Key: DERBY-4138
                 URL: https://issues.apache.org/jira/browse/DERBY-4138
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.4.2.0
         Environment: Solaris
            Reporter: Alan Burlison


The following doesn't work:

ps = c.prepareStatement("select a, b, c from tab where a = ? order by b desc",
  ResultSet.TYPE_SCROLL_INSENSITIVE, ResultSet.CONCUR_UPDATABLE);
:
:
rs.updateInt(3, 123);

and throws the following exception:

'updateInt' not allowed because the ResultSet is not an updatable ResultSet. 
[XJ083]

Removing the 'order by b desc' clause makes the problem go away.

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.