db-derby-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Knut Anders Hatlen (JIRA)" <j...@apache.org>
Subject [jira] Commented: (DERBY-2257) Implementing the stored procedures called by the LOB related JDBC methods
Date Tue, 06 Mar 2007 15:51:24 GMT

    [ https://issues.apache.org/jira/browse/DERBY-2257?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12478448

Knut Anders Hatlen commented on DERBY-2257:

> All Brokered calls are forwarded to the rootConnection. Hence it wasn't necessary to
have an implementation for these methods here

Perhaps a comment in the code explaining this would be helpful?

> The test cases that test for failure are in the ClobStoredProcedureTest class. All of
them can be explained by considering the following example. [...]

This problem sounds related to the problems described in DERBY-1629 and DERBY-1440. I think
the exceptions thrown in stored procedures are supposed to be wrapped in an SQLException with
a specific SQL state, but I don't know the details.

> Also the code in which I check for the SQLException is temporary and will be removed
once the Clob locator methods are added.

The tests for BLOBRELEASELOCATOR and CLOBRELEASELOCATOR also ignore expected SQLExceptions
without checking SQL state. That code is not temporary, is it?

> 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, Expln_StoredProc_LOB_v2.txt, StoredProcedure_v3.diff,
StoredProcedure_v3.stat, StoredProcedure_v4.diff, StoredProcedure_v4.stat, StoredProcedure_v5.diff,
StoredProcedure_v5.stat, StoredProcedure_v6.diff, StoredProcedure_v6.stat, StoredProcedure_v7.diff,
StoredProcedure_v7.stat, StoredProcedures_v1.diff, StoredProcedures_v1.stat, StoredProcedures_v2.diff,

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

View raw message