Just a stab in the dark, but I think you can only have one resultset open in a connection at a time.  I suggest using a connection pool and multiple connections.

On Dec 17, 2007 1:45 PM, Eduardo S.E. de Castro <estima@gmail.com> wrote:
Hello,

  I have a question about using two PreparedStatements in the same
connection. When I use the following line, I get an exception
java.sql.SQLException: ResultSet not open. Operation 'next' not
permitted. Verify that autocommit is OFF.

       String strQuery = ...
       PreparedStatement pstmt = ...
       ResultSet rs = pstmt.executeQuery();

       while (rs.next()){
           Integer key = rs.getInt("LINE_ID");

           String strQuery2 = ...
           PreparedStatement pstmt2 = ...
           ResultSet rs2 = pstmt2.executeQuery();

           while (rs2.next()){
               ...
           }
           rs2.close();
           pstmt2.close();
       }
       rs.close();
       pstmt.close();

 I tried to set autoCommit to false, but it remains.

Thanks,
Eduardo