Uploaded image for project: '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.



    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • Network Client, SQL, Store
    • Mac OSX 10.4
      JDK 1.5.0_13
      Hibernate EntityManager 3.2.1
    • Normal
    • Known fix, Repro attached
    • Regression


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


      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.


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

        Issue Links



              kristwaa Kristian Waagan
              golgoth14 Golgoth 14
              1 Vote for this issue
              2 Start watching this issue