[jira] Resolved: (DERBY-2495) Create framework for calling locator related stored procedures from client

["Kristian Waagan (JIRA)" <ji...@apache.org>]

     [ https://issues.apache.org/jira/browse/DERBY-2495?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]

Kristian Waagan resolved DERBY-2495.
------------------------------------

    Resolution: Fixed
    Derby Info:   (was: [Patch Available])

Committed 'derby-2459-followup.diff' to trunk with revision 529259.

Thanks for the followup patch Øystein!

> Create framework for calling locator related stored procedures from client
> --------------------------------------------------------------------------
>
>                 Key: DERBY-2495
>                 URL: https://issues.apache.org/jira/browse/DERBY-2495
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Network Client
>            Reporter: Øystein Grøvlen
>         Assigned To: Øystein Grøvlen
>             Fix For: 10.3.0.0
>
>         Attachments: blobframework.diff, blobframework_v2.diff, blobframework_v2.diff, derby-2459-followup.diff
>
>
> The client JDBC driver will need to call stored procedures (ref DERBY-2257) to operate on LOBs identified by locators.  We should create a framework that implement the stored procedure calls.  This way, the rest of the client code can call methods in this framework when needing to call the stored procedures without having to prepare SQL statements themselves.  
> The framework should make sure that prepared statements are reused within a connection.  Each procedure call should only be prepared once per connection.
> Since LOBs can not be parameters to stored procedures, the framework should make sure that calls involving a byte[] or String that does not fit in a VARCHAR (FOR BIT DATA), are split into several calls each operating on a fragment of the LOB.

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