You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Anurag Shekhar (JIRA)" <de...@db.apache.org> on 2006/03/01 13:01:46 UTC

[jira] Updated: (DERBY-1059) call to stored procedure with out params fails in embedded driver

     [ http://issues.apache.org/jira/browse/DERBY-1059?page=all ]

Anurag Shekhar updated DERBY-1059:
----------------------------------

    Attachment: derby-1059.diff

In this patch I have introduced tow new classes
EmbedPreparedStatmentMethod40
PreparedStatmentMethod40
These class have implementation of jdbc4.0 method for prepared statements.
Method class to Callablestatement40 and PreparedStatement40 classes will be passed on to these class to avoid duplication of code.

Test case
No sperate test is provided for these change
jdbcapi/parameterMapping.java tests callable statment methods with out param.

> call to stored procedure with out params fails in embedded driver
> -----------------------------------------------------------------
>
>          Key: DERBY-1059
>          URL: http://issues.apache.org/jira/browse/DERBY-1059
>      Project: Derby
>         Type: Sub-task
>   Components: JDBC
>     Versions: 10.2.0.0
>     Reporter: Anurag Shekhar
>     Assignee: Anurag Shekhar
>  Attachments: derby-1059.diff
>
> org.apache.derby.impl.jdbc.EmbeddedCallableStatement40 and org.apache.derby.client.am.CallableStatement40 are instantiating Preparewdstament in 
> constructor. Becasue of this call to stored procedure with out param fails.
> Instantiatiation of prepared was done to share the common method in prepared statement and callbale statement. But this aporach causes another issue of creating two instance of statement (one by calling super () and another by instantiating prepared statement). 
> I can think of two solution of this problem 
> 1. Create another class which handles the common methods in PrepardStatement40 and CallableStatement40 classes.
> 2. Duplicate the common method in both classes. 
> I feel 1st one is better. It will will be easier to fix any issue in the common methods and chance to miss to fix in one of the classes will be eliminated.

-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators:
   http://issues.apache.org/jira/secure/Administrators.jspa
-
For more information on JIRA, see:
   http://www.atlassian.com/software/jira