Uploaded image for project: 'Derby'
  1. Derby
  2. DERBY-6923

Passing a ClientClob or ClientBlob from another connection to an INSERT statement results in 'null' being written.

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Open
    • Critical
    • Resolution: Unresolved
    • 10.13.1.1
    • None
    • Network Client, Network Server
    • None
    • Java 8
      MacOS
      Windows

    Description

      When assigning a Blob or Clob from a ResultSet to a PreparedStatement parameter on a second connection, null is written to the column instead.

      Attached the same example using Embedded->Embedded, Embedded->Network, Network->Embedded and Network->Network.

      Only the Network->Network example exhibits the fault.

      Originally discovered in HA-JDBC's sync code with 2 derby instances on Windows. Example were tested using MacOS. Both were running on Oracle Java 8 VMs.

      Attachments

        1. DerbyEmbeddedOnly.java
          3 kB
          Gordon Innes
        2. DerbyNetworkOnly.java
          4 kB
          Gordon Innes
        3. DerbyNetworkRead.java
          4 kB
          Gordon Innes
        4. DerbyNetworkWrite.java
          4 kB
          Gordon Innes

        Issue Links

          is related to

          Sub-task - The sub-task of the issue DERBY-2496 Implement Blob support for Locators

          • Major - Major loss of function.
          • Closed

          Activity

            People

              Unassigned Unassigned
              gordski Gordon Innes
              Votes:
              0 Vote for this issue
              Watchers:
              2 Start watching this issue

              Dates

                Created:
                Updated: