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-2932) Connection.createClob() and Connection.createBlob() throw a procedure not found exception and do not switch to non-locator code upon soft upgrade
Date Thu, 12 Jul 2007 14:47:06 GMT

     [ https://issues.apache.org/jira/browse/DERBY-2932?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]

V.Narayanan updated DERBY-2932:
-------------------------------

    Attachment: SoftUpgrade_createClob_createBlob_v1.stat
                SoftUpgrade_createClob_createBlob_v1.diff

CallableLocatorProcedures makes a call to the stored procedure

SYSIBM.BLOBCREATELOCATOR() to get a valid Blob locator value
SYSIBM.CLOBCREATELOCATOR() to get a valid Clob locator value

and then returns a Blob or a Clob object created using these
locator values.

When soft-upgrade happens these stored procedures would not be present.

Hence the exception thrown upon not finding the stored procedures has
to be caught and a non-locator LOB object has to e returned.

This exception that the stored procedure is not present on the
server is thrown from connection.prepareCallX when the CallableStatement
is constructed rather than at executeX().

The problem occurred because only executeX() was enclosed in the try catch
block and was solved by simply moving connection.prepareCallX into the
try catch.

The above attached patch achieves the same

I haven't yet run junit All on this patch. I shall run the tests
and revert back. However I did repeat the steps outlined to reproduce
this bug and did not find the exception.

> Connection.createClob() and Connection.createBlob() throw a procedure not found exception
and do not switch to non-locator code upon soft upgrade
> -------------------------------------------------------------------------------------------------------------------------------------------------
>
>                 Key: DERBY-2932
>                 URL: https://issues.apache.org/jira/browse/DERBY-2932
>             Project: Derby
>          Issue Type: Bug
>          Components: Network Client
>    Affects Versions: 10.3.0.0, 10.3.1.0, 10.3.1.1
>            Reporter: V.Narayanan
>            Assignee: V.Narayanan
>            Priority: Blocker
>             Fix For: 10.3.1.1
>
>         Attachments: SoftUpgrade_createClob_createBlob_v1.diff, SoftUpgrade_createClob_createBlob_v1.stat
>
>


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


Mime
View raw message