[DERBY-4224] Commit after setAsciiStream() makes execution fail with the client driver

• Type: Bug
• Status: Closed
• Priority: Major
• Resolution: Fixed
• Affects Version/s: 10.4.2.0
• Fix Version/s: 10.4.2.1, 10.5.3.0, 10.6.1.0
• Component/s: JDBC, Network Client
• Urgency: Normal
• Issue & fix info: Repro attached
• Bug behavior facts: Deviation from standard, Embedded/Client difference, Regression
• Assignee: Katherine Marsden
• Reporter: Simon Meng
• Created: 12/May/09 06:59
• Updated: 21/Jan/11 17:52
• Resolved: 23/Jul/09 12:56

Description

Got below error message when running a JDBC prolgram with derby. I use Apache Derby Network Server - 10.4.2.0 - (689064). The same program works fine with another version Apache Derby Network Server - 10.2.2.0 - (485682). It looks like there is a regression between the two versions.
Exception in thread "main" java.sql.SQLException: You cannot invoke other java.sql.Clob/java.sql.Blob methods after calling the free() method or after the Blob/Clob's transaction has been committed or rolled back.
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.Lob.checkValidity(Unknown Source)
at org.apache.derby.client.am.Clob.length(Unknown Source)
at org.apache.derby.client.net.NetStatementRequest.computeProtocolTypesAndLengths(Unknown Source)
at org.apache.derby.client.net.NetStatementRequest.buildSQLDTAcommandData(Unknown Source)
at org.apache.derby.client.net.NetStatementRequest.writeExecute(Unknown Source)
at org.apache.derby.client.net.NetPreparedStatement.writeExecute_(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.writeExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.flowExecute(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.executeX(Unknown Source)
at org.apache.derby.client.am.PreparedStatement.execute(Unknown Source)
at DerbyTest.test(DerbyTest.java:36)
at DerbyTest.main(DerbyTest.java:12)
Caused by: org.apache.derby.client.am.SqlException: You cannot invoke other java.sql.Clob/java.sql.Blob methods after calling the free() method or after the Blob/Clob's transaction has been committed or rolled back.
... 12 more

Below is the test program I used.

import java.io.ByteArrayInputStream;
import java.io.IOException;
import java.io.InputStream;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.SQLException;
import java.sql.Statement;

public class DerbyTest {
public static void main(String[] args) throws SQLException, IOException

{ new DerbyTest().test(); }

private void test() throws SQLException, IOException {
Connection conn = null;

try

{ conn = getConnection(); Statement stmt = conn.createStatement(); dropTable("test1"); dropTable("test2"); String createStr1 = "CREATE TABLE test1 (col0 VARCHAR(8000))"; String createStr2 = "CREATE TABLE test2 (col0 VARCHAR(8000))"; stmt.executeUpdate(createStr1); stmt.executeUpdate(createStr2); stmt.close(); PreparedStatement pstmt1 = conn.prepareStatement("INSERT INTO test1 VALUES (?)"); PreparedStatement pstmt2 = conn.prepareStatement("INSERT INTO test1 VALUES (?)"); InputStream in1 = new ByteArrayInputStream("abcdefghijklmnopqrstuvwxyz0123456789".getBytes()); InputStream in2 = new ByteArrayInputStream("9876543210ZYXWVUTSRQPONMLKJIHGFEDCBA".getBytes()); pstmt1.setAsciiStream(1, in1, in1.available()); pstmt2.setAsciiStream(1, in2, in2.available()); pstmt1.execute(); pstmt2.execute(); pstmt1.close(); pstmt2.close(); System.out.println("Successful"); }

finally

{ if (conn != null) conn.close(); }

}

private Connection getDriverConnection() throws SQLException

{ String connectionURL = "jdbc:derby://localhost:1527/testdb;user=app;password=derby;create=true"; return DriverManager.getConnection(connectionURL); }

private Connection getConnection() throws SQLException

{ return getDriverConnection(); }

public void dropTable(String tableName) throws SQLException {
Connection conn = getConnection();
Statement stmt = conn.createStatement();
try

{ stmt.executeUpdate("DROP TABLE " + tableName); }

catch (SQLException sqle)

{ System.out.println("Error occured when drop table: " + sqle.getMessage()); }

finally {
if (stmt != null)

{ stmt.close(); }

if (conn != null)

{ conn.close(); }

}
}
}

Issue Links

• is related to: DERBY-4312 SQLException XJ215 on insert with setCharacterStream() and autocommit off in mailjdbc test
• is related to: DERBY-3574 With client, attempting to get the lob length after commit or connection close if there was a call to length() before commit does not throw an exception