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 <[EMAIL PROTECTED]> 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
>
