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

Fails to handle BLOB fields with a PreparedStatement with size >32750 bytes



    • Bug
    • Status: Closed
    • Major
    • Resolution: Fixed
    • JDBC, Network Client
    • None
    • Windows XP SP2
    • Patch Available
    • Regression


      Java Version: 1.6.0_02
      Java Vendor: Sun Microsystems Inc.
      Java home: C:\Program Files\Java\jre1.6.0_02
      Java classpath: derbytools.jar
      OS name: Windows XP
      OS architecture: x86
      OS version: 5.1
      Java user name: Ma
      Java user home: C:\Documents and Settings\ma
      Java user dir: c:\tools\derby\lib
      java.specification.name: Java Platform API Specification
      java.specification.version: 1.6
      --------- Derby Information --------
      JRE - JDBC: Java SE 6 - JDBC 4.0
      [C:\tools\derby\lib\derbytools.jar] - (561794)

      The following code fails:
      // Data is a byte[] vector
      ByteArrayInputStream is = new ByteArrayInputStream( data);
      String sql = "UPDATE MyTable SET FContents=? WHERE FName='" + name + "'";
      PreparedStatement ps = conn.prepareStatement( sql);
      ps.setBinaryStream( 1, is, data.length);

      if( ps.executeUpdate() == 0)

      { // it throws an exception here if the data array us larger then around 32750 bytes!!! }

      It look's like when the size of the data[] vector is > 32750 bytes or so it throws an exception like this:
      java.sql.SQLException: A network protocol error was encountered and the connection has been terminated: A PROTOCOL Data Stream Syntax Error was detected. Reason: 0x0. Plaintext connection attempt to an SSL enabled server?
      at org.apache.derby.client.am.SQLExceptionFactory40.getSQLException(Unknown Source)
      at org.apache.derby.client.am.SqlException.getSQLException(Unknown Source)
      at org.apache.derby.client.am.PreparedStatement.executeUpdate(Unknown Source)

      The table is defined as:
      CREATE TABLE MyTable (FName varchar(300) NOT NULL,FContents BLOB(16M) NOT NULL)

      It does loook like this only happens with the NetWork client driver, the embedded driver works fine.


        1. TestBlob.java
          1 kB
          Katherine Marsden
        2. trace.out.norows
          250 kB
          Katherine Marsden
        3. trace.out.withrow
          251 kB
          Katherine Marsden
        4. derby-3085_diff.txt
          9 kB
          Katherine Marsden
        5. derby-3085_stat.txt
          0.2 kB
          Katherine Marsden
        6. derby-3085_diff2.txt
          12 kB
          Katherine Marsden
        7. derby-3085_stat2.txt
          0.2 kB
          Katherine Marsden



            kmarsden Katherine Marsden
            mikael_aronsson Mikael Aronsson
            0 Vote for this issue
            0 Start watching this issue