db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "V.Narayanan (JIRA)" <j...@apache.org>
Subject [jira] Updated: (DERBY-2506) Adding the locator information to FD:OCA descriptor (FDODSC) andFD:OCA data (FDODTA) of the SQLDTA objects
Date Sat, 31 Mar 2007 16:00:25 GMT

     [ 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

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.

View raw message