db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Øystein Grøvlen (JIRA) <j...@apache.org>
Subject [jira] Created: (DERBY-2495) Create framework for calling locator related stored procedures from client
Date Wed, 28 Mar 2007 11:24:32 GMT
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
            Reporter: Øystein Grøvlen
         Assigned To: Øystein Grøvlen
             Fix For: 10.3.0.0


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.


Mime
View raw message