Derby
  1. Derby
  2. DERBY-4278

Batch inserts with Clobs fails with the embedded driver

    Details

    • Type: Bug Bug
    • Status: Closed
    • Priority: Major Major
    • Resolution: Fixed
    • Affects Version/s: 10.5.1.1, 10.6.1.0
    • Fix Version/s: 10.5.2.0, 10.6.1.0
    • Component/s: JDBC
    • Labels:
      None
    • Urgency:
      Urgent
    • Bug behavior facts:
      Regression

      Description

      Batch inserts with Clobs fail because Derby is unable to determine if it should write the Clob stream header formats using the old 10.4 style format or the new 10.5 format.
      More specifically, the access mode (soft upgrade or not) hasn't been set specifically by Derby before the stream header has to be generated, and there isn't enough context to determine the mode at generation time.

      Bug was reported on derby-user: http://www.nabble.com/Hibernate-%2B-Derby---Unable-to-determine-stream-header-for-hibernate-type-%27text%27-td24099674.html

      The bug was reported for Derby used with Hibernate. Possible workarounds are to use the client driver or to avoid using batched inserts with Clobs (i.e. don't use batched inserts, which may degrade performance, or use a different data type).

      1. derby-4278-2a-fix.diff
        3 kB
        Kristian Waagan
      2. derby-4278-1a-regression_test.diff
        4 kB
        Kristian Waagan

        Activity

        Gavin made changes -
        Workflow jira [ 12466354 ] Default workflow, editable Closed status [ 12799775 ]
        Kristian Waagan made changes -
        Status Resolved [ 5 ] Closed [ 6 ]
        Kathey Marsden made changes -
        Fix Version/s 10.5.2.0 [ 12314116 ]
        Fix Version/s 10.5.1.2 [ 12313870 ]
        Kristian Waagan made changes -
        Status In Progress [ 3 ] Resolved [ 5 ]
        Issue & fix info [Patch Available]
        Fix Version/s 10.5.1.2 [ 12313870 ]
        Resolution Fixed [ 1 ]
        Kristian Waagan made changes -
        Fix Version/s 10.6.0.0 [ 12313727 ]
        Kristian Waagan made changes -
        Urgency Urgent
        Dag H. Wanvik made changes -
        Bug behavior facts [Regression]
        Kristian Waagan made changes -
        Derby Info [Regression] [Patch Available, Regression]
        Kristian Waagan made changes -
        Attachment derby-4278-2a-fix.diff [ 12411228 ]
        Kristian Waagan made changes -
        Attachment derby-4278-1a-regression_test.diff [ 12411225 ]
        Kristian Waagan made changes -
        Field Original Value New Value
        Status Open [ 1 ] In Progress [ 3 ]
        Kristian Waagan created issue -

          People

          • Assignee:
            Kristian Waagan
            Reporter:
            Kristian Waagan
          • Votes:
            0 Vote for this issue
            Watchers:
            0 Start watching this issue

            Dates

            • Created:
              Updated:
              Resolved:

              Development