[jira] Assigned: (DERBY-189) ResultSetMetaData.getSchemaName and ResultSetMetaData.isWritable donot return correct values

     [ http://issues.apache.org/jira/browse/DERBY-189?page=history ]

Mamta A. Satoor reassigned DERBY-189:
-------------------------------------

    Assign To: Mamta A. Satoor

> ResultSetMetaData.getSchemaName and ResultSetMetaData.isWritable donot return 
> correct values
> --------------------------------------------------------------------------------------------
>
>          Key: DERBY-189
>          URL: http://issues.apache.org/jira/browse/DERBY-189
>      Project: Derby
>         Type: Bug
>     Versions: 10.1.0.0
>     Reporter: Mamta A. Satoor
>     Assignee: Mamta A. Satoor

>
> ResultSetMetaData among other methods has isWritable() and getSchemaName() 
> and Derby engine does not return correct values for them. This needs to be 
> fixed in order to support updatable resultset apis in Network Server mode 
> since the client driver relies on these 2 methods.
> Derby Net Client and JCC driver rely on getSchemanName method to construct 
> the correct "update where current of sql" for an updatRow. For eg, if the 
> user is in say schema s1 and the updatable resultset is issued on a table 
> from schema s2 with the sql "select c11 from s2.t1 for update". Currenly, 
> getSchemaName returns null and hence, the client code constructs a sql like 
> "update t1 ... where current of ...". ie the update is being issued against 
> table t1 in schema s1. getSchemaName should return s2, so the driver can 
> correctly genereat sql as "update s2.t1 ... where current of ...".
> In addition, the client code lets a user issue an updateXXX on a column only 
> if the column is writable and it determines that by looking at the return 
> value of isWritable(). Derby engine currently always returns false for this 
> method and because of that, updateXXX fails in Network Server mode. Derby 
> should return true for the columns which can be updated in the given 
> resultset. For eg for "select c11, c12 from t1 for update of c11", isWritable 
> should return true for c11 and false for c12.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
If you want more information on JIRA, or have a bug to report see:
   http://www.atlassian.com/software/jira