Mailing-List: contact derby-user-help@db.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Derby Discussion" <derby-user@db.apache.org>
Received-SPF: pass (asf.osuosl.org: local policy)
Message-ID: <4384EE0B.7040006@nuix.com.au>
Date: Thu, 24 Nov 2005 09:32:43 +1100
From: Daniel Noll <daniel@nuix.com.au>
Organization: NUIX Pty Limited
User-Agent: Mozilla Thunderbird 1.0.7 (Windows/20050923)
MIME-Version: 1.0
To: Derby Users Mailing List <derby-user@db.apache.org>
Subject: Strange error: "ResultSet not open. Operation 'next' not permitted."
Content-Type: text/plain; charset=ISO-8859-1; format=flowed
Content-Transfer-Encoding: 7bit

Got this exception while two threads were rapidly querying a single 
database:

Caused by: SQL Exception: ResultSet not open. Operation 'next' not 
permitted. Verify that autocommit is OFF.
    at org.apache.derby.impl.jdbc.Util.generateCsSQLException(Util.java:195)
    at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.wrapInSQLException(TransactionResourceImpl.java:381)
    at 
org.apache.derby.impl.jdbc.TransactionResourceImpl.handleException(TransactionResourceImpl.java:346)
    at 
org.apache.derby.impl.jdbc.EmbedConnection.handleException(EmbedConnection.java:1296)
    at 
org.apache.derby.impl.jdbc.ConnectionChild.handleException(ConnectionChild.java:88)
    at 
org.apache.derby.impl.jdbc.EmbedResultSet.closeOnTransactionError(EmbedResultSet.java:3715)
    at 
org.apache.derby.impl.jdbc.EmbedResultSet.movePosition(EmbedResultSet.java:385)
    at 
org.apache.derby.impl.jdbc.EmbedResultSet.next(EmbedResultSet.java:299)
    ...

The code we called it from was checking for existence of a row, like this:

    PreparedStatement ps = conn.prepareStatement("SELECT ...");
    ps.setLong(1, id);
    ResultSet rs = ps.executeQuery;
    try
    {
        return rs.next();    <-- This line did it.
    }
    finally
    {
        rs.close();
    }

Autocommit is indeed off, but regardless of that, we're not actually 
updating this database at any point in time, just reading data out of it 
to put it in another.

Daniel

-- 
Daniel Noll

NUIX Pty Ltd
Level 8, 143 York Street, Sydney 2000
Phone: (02) 9283 9010
Fax:   (02) 9283 9020

This message is intended only for the named recipient. If you are not
the intended recipient you are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
message or attachment is strictly prohibited.