Derby
  1. Derby
  2. DERBY-3656

ERROR XJ073: The data in this BLOB or CLOB is no longer available. should include the possibility that the lob has been freed

    Details

    • Type: Improvement Improvement
    • Status: Closed
    • Priority: Minor Minor
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1
    • Fix Version/s: 10.6.1.0
    • Component/s: JDBC
    • Labels:
      None
    • Issue & fix info:
      Newcomer

      Description

      The message XJ073 says:

      ERROR XJ073: The data in this BLOB or CLOB is no longer available. The BLOB/CLOB's transaction may be committed, or its connection is closed.

      but the lob might also not be available because it has been freed. It would be good to include that possibility in the error message.

      1. patch3656.patch
        0.7 kB
        Tiago R. Espinha

        Activity

        Hide
        Kathey Marsden added a comment -

        Thanks Tiago for the patch and for battling the tests. Please update the documentation/wiki with any tips you might have for newcomers after your experience.

        Committed revision 757204

        Show
        Kathey Marsden added a comment - Thanks Tiago for the patch and for battling the tests. Please update the documentation/wiki with any tips you might have for newcomers after your experience. Committed revision 757204
        Hide
        Tiago R. Espinha added a comment -

        After battling suites.All, it finally ran all the tests.

        Both derbyall and suites.All ran with no errors.

        Show
        Tiago R. Espinha added a comment - After battling suites.All, it finally ran all the tests. Both derbyall and suites.All ran with no errors.
        Hide
        Tiago R. Espinha added a comment -

        Okay, will do so then. I'll post the result as soon as I have it.

        Show
        Tiago R. Espinha added a comment - Okay, will do so then. I'll post the result as soon as I have it.
        Hide
        Kathey Marsden added a comment -

        Tiago asked:
        >Is it really needed to run the tests for this type of patch though? It's a through and through string change.

        Many of the tests are still canon based and may have the text of the message in the output and need updating.
        Also changing an xml file, it's easy to miss a bracket and break the whole thing, so always safest to clobber, build and run tests. You'll sleep better at night, knowing you'll get a clean commit. Kick them off before you leave for the day and it's no extra trouble.

        Show
        Kathey Marsden added a comment - Tiago asked: >Is it really needed to run the tests for this type of patch though? It's a through and through string change. Many of the tests are still canon based and may have the text of the message in the output and need updating. Also changing an xml file, it's easy to miss a bracket and break the whole thing, so always safest to clobber, build and run tests. You'll sleep better at night, knowing you'll get a clean commit. Kick them off before you leave for the day and it's no extra trouble.
        Hide
        Tiago R. Espinha added a comment -

        Added the correct fix, with the whole path.

        Show
        Tiago R. Espinha added a comment - Added the correct fix, with the whole path.
        Hide
        Tiago R. Espinha added a comment -

        Ah bugger, I should start using command line svn rather than the Tortoise.

        Will fix that.

        Is it really needed to run the tests for this type of patch though? It's a through and through string change.

        Show
        Tiago R. Espinha added a comment - Ah bugger, I should start using command line svn rather than the Tortoise. Will fix that. Is it really needed to run the tests for this type of patch though? It's a through and through string change.
        Hide
        Myrna van Lunteren added a comment -

        Reopening - there's a patch - but it needs to get reviewed and then the code will need to be committed by a committer...
        After that, our normal process is: the committer can resolve the issue & the original reporter can close it.
        You can switch on the 'patch available' flag to draw attention of a committer to your patch, by clicking on 'edit' of the issue. An email goes to the committers with a list of patches available for review/commit.

        Show
        Myrna van Lunteren added a comment - Reopening - there's a patch - but it needs to get reviewed and then the code will need to be committed by a committer... After that, our normal process is: the committer can resolve the issue & the original reporter can close it. You can switch on the 'patch available' flag to draw attention of a committer to your patch, by clicking on 'edit' of the issue. An email goes to the committers with a list of patches available for review/commit.
        Hide
        Kathey Marsden added a comment -

        Hi Tiago,

        Thanks for looking at this issue.

        On visual inspection of the change, your text change looks fine. However, I can't apply the patch. You need to svn diff from the top of the tree show it shows the path staring with java/engine/...

        You should reopen the issue until it has been committed.

        Also, just for good measure you should run suites.All and derbyall in case there are any canon updates needed.

        Thanks

        Kathey

        Show
        Kathey Marsden added a comment - Hi Tiago, Thanks for looking at this issue. On visual inspection of the change, your text change looks fine. However, I can't apply the patch. You need to svn diff from the top of the tree show it shows the path staring with java/engine/... You should reopen the issue until it has been committed. Also, just for good measure you should run suites.All and derbyall in case there are any canon updates needed. Thanks Kathey
        Hide
        Tiago R. Espinha added a comment -

        Just a quick language fix.

        Show
        Tiago R. Espinha added a comment - Just a quick language fix.

          People

          • Assignee:
            Tiago R. Espinha
            Reporter:
            Kathey Marsden
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development