Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: <derby-dev@db.apache.org>
Message-ID: <762405804.1242111645553.JavaMail.jira@brutus>
Date: Tue, 12 May 2009 00:00:45 -0700 (PDT)
From: "Simon Meng (JIRA)" <jira@apache.org>
To: derby-dev@db.apache.org
Subject: [jira] Created: (DERBY-4224) Got SQLException
MIME-Version: 1.0
Content-Type: text/plain; charset=utf-8
Content-Transfer-Encoding: 7bit

Got SQLException
----------------

                 Key: DERBY-4224
                 URL: https://issues.apache.org/jira/browse/DERBY-4224
             Project: Derby
          Issue Type: Bug
          Components: JDBC
    Affects Versions: 10.4.2.0
            Reporter: Simon Meng


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();
			}
		}
	}
}

-- 
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.