Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <9628035.1184141525357.JavaMail.jira@brutus>
Date: Wed, 11 Jul 2007 01:12:05 -0700 (PDT)
From: =?utf-8?Q?=C3=98ystein_Gr=C3=B8vlen_=28JIRA=29?= <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Closed: (DERBY-2495) Create framework for calling locator
 related stored procedures from client
In-Reply-To: <13963871.1175081072184.JavaMail.jira@brutus>
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: quoted-printable


     [ https://issues.apache.org/jira/browse/DERBY-2495?page=3Dcom.atlassia=
n.jira.plugin.system.issuetabpanels:all-tabpanel ]

=C3=98ystein Gr=C3=B8vlen closed DERBY-2495.
----------------------------------


> Create framework for calling locator related stored procedures from clien=
t
> -------------------------------------------------------------------------=
-
>
>                 Key: DERBY-2495
>                 URL: https://issues.apache.org/jira/browse/DERBY-2495
>             Project: Derby
>          Issue Type: Sub-task
>          Components: Network Client
>            Reporter: =C3=98ystein Gr=C3=B8vlen
>            Assignee: =C3=98ystein Gr=C3=B8vlen
>             Fix For: 10.3.0.0
>
>         Attachments: blobframework.diff, blobframework_v2.diff, blobframe=
work_v2.diff, derby-2459-followup.diff
>
>
> The client JDBC driver will need to call stored procedures (ref DERBY-225=
7) to operate on LOBs identified by locators.  We should create a framework=
 that implement the stored procedure calls.  This way, the rest of the clie=
nt code can call methods in this framework when needing to call the stored =
procedures without having to prepare SQL statements themselves. =20
> The framework should make sure that prepared statements are reused within=
 a connection.  Each procedure call should only be prepared once per connec=
tion.
> Since LOBs can not be parameters to stored procedures, the framework shou=
ld 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 f=
ragment of the LOB.

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