When the Statement object is created with CONCUR_UPDATABLE, the
ResultSet object will return concurrency as CONCUR_UPDATABLE if the
underlying language result set is updateable. If the underlying language resultset
is not updatable, there should be a warning issued on the ResultSet object that this
is not an updateable ResultSet. But, what should the ResultSet object return for
concurrency in this case? I think it should return CONCUR_READ_ONLY.
And any attempts to updateable resultset apis will throw exceptions as well
since the ResultSet object is not updateable.
In the case of Oracle, it would return CONCUR_READ_ONLY. I would the
imagine a JDBC programmer would expect this behavior from Derby as well.