community.borland.com

Article #28529: invalid statement handle

If you prepare a PreparedStatement, and then execute some DDL over the same connection, the handle to your PreparedStatement is damaged. When you try to use the PreparedStatement, an exception is thrown.

For example:

    PreparedStatement pstmt = conn.prepareStatement ("Select * from employee where emp_no = ?" );
    pstmt.setInt(1, 2);

    Statement stmt2 = conn.createStatement();
    stmt2.executeUpdate("Grant all on DEPARTMENT to PUBLIC " );

    ResultSet rs = pstmt.executeQuery();  /* EXCEPTION THROWN */
This is corrected in InterClient 2.5.

Last Modified: 21-MAR-02