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.



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


      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.


        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
        There are no Sub-Tasks for this issue.



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


              • Created: