Issue Details (XML | Word | Printable)

Key: DERBY-189
Type: Bug Bug
Status: Closed Closed
Resolution: Fixed
Priority: Major Major
Assignee: Mamta A. Satoor
Reporter: Mamta A. Satoor
Votes: 0
Watchers: 0
Operations

If you were logged in you would be able to see more operations.
Derby

ResultSetMetaData.getSchemaName and ResultSetMetaData.isWritable donot return correct values

Created: 31/Mar/05 01:26 AM   Updated: 05/Jun/05 01:17 AM
Return to search
Component/s: JDBC
Affects Version/s: 10.1.1.0
Fix Version/s: 10.1.1.0

Time Tracking:
Not Specified

Resolution Date: 13/May/05 12:57 AM


 Description  « Hide
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.


 All   Comments   Work Log   Change History   Subversion Commits      Sort Order: Ascending order - Click to sort in descending order
Mamta A. Satoor made changes - 31/Mar/05 01:44 AM
Field Original Value New Value
Assignee Mamta A. Satoor [ mamtas ]
Satheesh Bandaram made changes - 05/May/05 06:44 AM
Component/s JDBC [ 11407 ]
Daniel John Debrunner made changes - 13/May/05 12:57 AM
Fix Version/s 10.1.0.0 [ 10993 ]
Resolution Fixed [ 1 ]
Status Open [ 1 ] Resolved [ 5 ]
Mamta A. Satoor made changes - 05/Jun/05 01:17 AM
Status Resolved [ 5 ] Closed [ 6 ]