[
https://issues.apache.org/jira/browse/DERBY-2257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12465993
]
V.Narayanan commented on DERBY-2257:
------------------------------------
The Stored procedures that are being implemented here are related to adding
support to retrieve lobs for Network Server by locator rather than
materializing the LOB. This is the core of Derby-208.
The following extracts from comments on Derby-208 are very relevant
extract-1
-------------
The network client will request LOB columns to be sent as LOB Locators instead
of data value bytes. Since the client no longer has a copy of the LOB data
value bytes, operations on the LOB data will be performed on the server side,
and the results of these operations will be sent to the client. The client will
request the execution of an operation by the server by calling a stored
procedure.
extract-2
--------------
The implementation of LOB related JDBC methods in the network client must be
converted to use LOB Locators instead of having a copy of the LOB data in the
client side. Since the client will no longer have the data value bytes for the
LOB, operations performed on the data must be performed on the server side.
This will be done using stored procedures. Each time a LOB related JDBC method
is called, the client driver will "convert" that call into a call to one or
more stored procedures.
The design document attached to Derby-208 will also give further insight into
the bigger picture into which the stored procedure described here fits in.
> Implementing the stored procedures called by the LOB related JDBC methods
> -------------------------------------------------------------------------
>
> Key: DERBY-2257
> URL: https://issues.apache.org/jira/browse/DERBY-2257
> Project: Derby
> Issue Type: Sub-task
> Components: JDBC
> Environment: All environments
> Reporter: V.Narayanan
> Assigned To: V.Narayanan
> Attachments: Expln_StoredProc_LOB.txt, StoredProcedures_v1.diff,
> StoredProcedures_v1.stat
>
>
--
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
https://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira
