[jira] Commented: (DERBY-2529) Client PreparedStatement/CallableStatement implementations need to use locators

["V.Narayanan (JIRA)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/DERBY-2529?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12487205 ] 

V.Narayanan commented on DERBY-2529:
------------------------------------

This can be divided into the set methods of PreparedStatement and get methods of CallableStatement because the CallableStatement implementation extends from the PreparedStatement implementation. The implementation of the set methods in the PreparedStatement would hence be inherited by the CallableStatement. 

The get methods in CallableStatement pass the efforts on to the Clob and Blob implementation. There is a seperate JIRA for locator support to Clob and Blob. 

Hence here we need to Convert the implementation of Clob and Blob related set methods of PreparedStatements in the NetworkClient to use locators.

Note that for backward compatibility the existing implementation of the methods
would need to co-exist with the locator implementation. 

The following are the methods that shall be converted to use locators. The list of methods
that are allowed to operate on the Blob column can be got from PossibleTypes
class in am/PreparedStatement.java

Blob
----
setBytes
setBinaryStream
setBlob
setObject (when a Blob is passed as parameter)

Clob
----
setString
setAsciiStream
setCharacterStream
setClob
setObject (When a Clob is passed as parameter)

The implementation will be done in two phases

PHASE 1 - Blob related methods
PHASE 2 - Clob related methods.

> Client PreparedStatement/CallableStatement implementations need to use locators
> -------------------------------------------------------------------------------
>
>                 Key: DERBY-2529
>                 URL: https://issues.apache.org/jira/browse/DERBY-2529
>             Project: Derby
>          Issue Type: Sub-task
>            Reporter: V.Narayanan
>         Assigned To: V.Narayanan
>


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