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

Inserting large string value into non-existent table causes communication link failure over Network Server.

    XMLWordPrintableJSON

    Details

    • Type: Bug
    • Status: Closed
    • Priority: Major
    • Resolution: Fixed
    • Affects Version/s: None
    • Fix Version/s: 10.1.3.1, 10.2.1.6
    • Component/s: Network Server
    • Labels:
      None
    • Environment:
      Derby Network Server running with either JDBC or ODBC driver.

      Description

      The following failure, along with the 2 sub-tasks created under this issue, are reproducible both from a JDBC client (JCC) and from an ODBC client (in this case, DB2 Runtime Client). I've grouped them all together because they all share the characteristic of "large data transfer", though the context in which the transfer occurs is different for each failure.

      Failure: When trying to insert a large string value (ex. 1 million chars) into a non-existent table using a prepared statement, an ASSERT failure occurs on the Derby side (because data size < 0), which leads to connection closure and communication link failure. Note that the problem does NOT happen if the target table actually exists. Repro can be found in the "assert_repro.java" file attached to this bug.

        Attachments

        1. svn_jan14_2006.diff
          6 kB
          Bryan Pendleton
        2. changes.html
          9 kB
          Bryan Pendleton
        3. svn_jan12_2006.status
          0.4 kB
          Bryan Pendleton
        4. assert_repro.java
          1 kB
          A B
        5. storedProcs.java
          13 kB
          A B
        6. stored_proc_repro.java
          4 kB
          A B

          Activity

            People

            • Assignee:
              bryanpendleton Bryan Pendleton
              Reporter:
              army A B
            • Votes:
              1 Vote for this issue
              Watchers:
              0 Start watching this issue

              Dates

              • Created:
                Updated:
                Resolved: