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

Client driver can insert and commit partial data when a LOB stream throws IOException or does not match the specified length

    XMLWordPrintableJSON

Details

    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • 10.2.1.6
    • 10.6.1.0
    • JDBC, Network Client
    • None
    • Normal
    • High Value Fix, Repro attached
    • Data corruption, Wrong query result

    Description

      When a LOB stream throws an exception or does not match the specified length, the client driver does not raise an exception until it has finished executing the statement. Therefore, the statement will be executed (and possibly committed) on the server even though the client reports that the statement failed.

      Attachments

        1. StreamErrRepro.java
          2 kB
          Knut Anders Hatlen
        2. Derby_2017_v1.diff
          2 kB
          Saurabh Vyas
        3. Derby_2017_v1.stat
          0.2 kB
          Saurabh Vyas
        4. derby2017_try1.diff
          3 kB
          Mayuresh Nirhali
        5. derby-2017-2a-regression_test.diff
          9 kB
          Kristian Waagan
        6. derby-2017-stream_status_preview.diff
          45 kB
          Kristian Waagan
        7. derby-2017-2b-regression-test.diff
          36 kB
          Kristian Waagan
        8. derby-2017-3a-fix.diff
          41 kB
          Kristian Waagan
        9. derby-2017-3a-fix.stat
          0.9 kB
          Kristian Waagan
        10. derby-2017-3b-fix.diff
          56 kB
          Kristian Waagan
        11. derby-2017-3c-fix.diff
          57 kB
          Kristian Waagan
        12. derby-2017-4a-remove_test_workaround.diff
          1 kB
          Kristian Waagan
        13. derby-2017-5a-binary_tests.diff
          22 kB
          Kristian Waagan

        Issue Links

          incorporates

          Bug - A problem which impairs or prevents the functions of the product. DERBY-4315 Attempt to reuse streams in client on insert gives protocol exception and inserts wrong data

          • Major - Major loss of function.
          • Closed

          Improvement - An improvement or enhancement to an existing feature or task. DERBY-1658 Too short streams passed in through JDBC are handled differently in client and embedded

          • Major - Major loss of function.
          • Closed
          is part of

          Task - A task that needs to be done. DERBY-2034 Tracking of bugs that lead to incorrect results being stored or returned to the client

          • Trivial - Cosmetic problem like misspelt words or misaligned text.
          • Closed
          relates to

          Bug - A problem which impairs or prevents the functions of the product. DERBY-5317 NullPointerException in org.apache.derby.client.net.Request.sendBytes() with client

          • Major - Major loss of function.
          • Closed

          Activity

            People

              kristwaa Kristian Waagan
              knutanders Knut Anders Hatlen
              Votes:
              1 Vote for this issue
              Watchers:
              1 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved: