Help with odd error

[[EMAIL PROTECTED]]

I have this code:
...
            TransactionUtil.begin();
            System.out.println("*************************Creating the list
iterator");
                iter = delegator.findListIteratorByCondition("ItemsSold",
conditionList, null, UtilMisc.toList("productId", "facilityId"));
            System.out.println("Creating the list iterator finished");
            TransactionUtil.commit();

...
       if(iter != null)
                           System.out.println("*************************Calling
Next");
                                iItemSold = (GenericValue)iter.next();
                           System.out.println("Calling Next returns product " +
itemSold.getString("productId"));


I am getting this error:
java.sql.SQLException: ResultSet not open. Operation 'next' not permitted.
Verify that autocommit is OFF.

at EntityListIterator.next() line 289 which just calls resultSet.next();

This is with derby.  I have just moved back to a development machine.  This
runs fine on Postgres and I swear it used to work fine on derby.

The debug trace code shows that the iterator gets opened and it fails on the
first call to iter.next();  The only code around the elipses are a catch
block, no db access of any sort.

Anyone have a clue?

Skip


No virus found in this outgoing message.
Checked by AVG.
Version: 7.5.519 / Virus Database: 269.22.13/1377 - Release Date: 4/14/2008
9:26 AM