[ 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.
|