[
https://issues.apache.org/jira/browse/DERBY-2506?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
V.Narayanan updated DERBY-2506:
-------------------------------
Attachment: PreparedCallable_DRDA_v1.stat
PreparedCallable_DRDA_v1.diff
The patch attached contains the modifications to the following files
M java/client/org/apache/derby/client/net/NetStatementRequest.java
Here the LID local identifier in the FDODSC FD:OCA descriptor should be
initialized as to contain a LOB locator. These changes are made in the
computeProtocolTypesAndLengths method. Here when the jdbctype is found to be of
type
java.sql.Types.CLOB or java.sql.Types.BLOB the Local Identifier (LID) is
initialized to contain the DRDA_TYPE_NLOB and DRDA_TYPE_NCLOB. This information
will be used in the server upon the parsing of the SQLDTA object.
The locator value associated with the LOB is set in the FDODTA FD:OCA data
object. This is done in the buildFDODTA method.
M java/drda/org/apache/derby/impl/drda/DRDAConnThread.java
The information got upon parsing the SQLDTA is used to obtain the locator
value. This locator value is then mapped to the corresponding locator object
that would be stored in the HashMap.
I tested this code with crude implementations of the following methods. I call
it crude because there now exists a JIRA for the creation of a framework for
calling the stored procedures DERBY-2495. I had however called then directly
without using the framework. I implemented the following methods
1) Connection.createClob
2) Connection.createBlob
3) PreparedStatement.setBlob
4) PreparedStatement.setBlob
5) added a constructor that will accept a locator in Blob (useful when called
from con.createBlob())
6) added a constructor that will accept a locator in Clob (useful when called
from con.createClob())
I will post that patch also which can be used as a test for this DRDA patch. I
need to do a bit of cleanup on that patch and will be posting it tomorrow or on
Monday.
I also have not run derbyall and junit all on this patch yet. I will post the
results of these runs tomorrow.
Pls consider this patch for reviews and comments.
> Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data
> (FDODTA) of the SQLDTA objects
> -----------------------------------------------------------------------------------------------------------
>
> Key: DERBY-2506
> URL: https://issues.apache.org/jira/browse/DERBY-2506
> Project: Derby
> Issue Type: Sub-task
> Reporter: V.Narayanan
> Assigned To: V.Narayanan
> Attachments: PreparedCallable_DRDA_v1.diff,
> PreparedCallable_DRDA_v1.stat
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
