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