Derby
  1. Derby
  2. DERBY-3650

internal multiple references from different rows to a single BLOB/CLOB stream leads to various errors when second reference used.

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.3.3.0, 10.4.1.3, 10.5.3.0, 10.6.1.0
    • Fix Version/s: 10.6.1.0
    • Component/s: Network Client, SQL, Store
    • Environment:
      Mac OSX 10.4
      JDK 1.5.0_13
      Hibernate EntityManager 3.2.1
    • Urgency:
      Normal
    • Issue & fix info:
      Known fix, Repro attached
    • Bug behavior facts:
      Regression

      Description

      Derby + Hibernate JPA 3.2.1 problem on entity with Blob/Clob

      Hi,

      I'm using Derby in Client - Server mode with Hibernate JPA EJB 3.0.
      When a query on an entity containing a Clob and some joins on other entites is executed, an exception with the following message is thrown:
      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.

      This problem occurs when the property "hibernate.max_fetch_depth" is greater than 0.
      When hibernate.max_fetch_depth=0, the query works.

      If Derby is configured in embedded mode, the query works independently of the value of hibernate.max_fetch_depth.

      On the Hibernate's documentation, the advised value of hibernate.max_fetch_depth is 3.
      Could you explain me if I made something wrong ?

      Thank you.
      Stephane

      1. ASF.LICENSE.NOT.GRANTED--derby-3650-preliminary_2_reworked-1b.diff
        5 kB
        Kristian Waagan
      2. cloning-methods.html
        5 kB
        Kristian Waagan
      3. derby-3650_tests_diff.txt
        8 kB
        Kathey Marsden
      4. Derby3650EmbeddedRepro.java
        1 kB
        Kathey Marsden
      5. Derby3650FullClientRepro.java
        2 kB
        Kathey Marsden
      6. Derby3650FullRepro.java
        2 kB
        Kathey Marsden
      7. derby-3650-preliminary_2_diff.txt
        44 kB
        Mike Matrigali
      8. derby-3650-preliminary_2_reworked.diff
        5 kB
        Kristian Waagan
      9. derby-3650-preliminary_diff.txt
        35 kB
        Mike Matrigali
      10. Derby3650Repro.java
        1 kB
        Kristian Waagan
      11. DerbyHibernateTest.zip
        89 kB
        Golgoth 14
      12. testdb.zip
        124 kB
        Kristian Waagan
      13. traces_on_FormatIdStream_alloc.txt
        4 kB
        Kathey Marsden
      14. UnionAll.java
        2 kB
        Kathey Marsden

        Issue Links

          Activity

          No work has yet been logged on this issue.

            People

            • Assignee:
              Kristian Waagan
              Reporter:
              Golgoth 14
            • Votes:
              1 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved:

                Development