[Opensource] deleteAll() error?

[Larry Hamel]

hi Gabor,

deleteAll() was changed to call delete() for each item, so that deleteDetails() would be called for each item.

probably the transaction needs more attention in this case (my guess--haven't looked yet).

would you consider creating some junit test case that would help me know if changes I make solve the problem?

larry

At 05:00 AM 9/24/2003, Gabor Nagypal wrote:
>Hi,
>
>I use Expresso5.3rc3. Trying to run deleteAll() in a transaction yields the following error message:
>ERROR [main] dbobj.DBObject (DBObject.java:1818) - Error performing deleteAll
>com.jcorporate.expresso.core.db.DBException: com.jcorporate.expresso.core.db.DBConnection.next():Error retrieving next row for statement DELETE FROM Resource WHERE id = 'expressoTest:#i-1064404574995-16294950' (org.vicodi.expresso.dbobj.LinkResourceResRoleDBO):Connection is closed.  Operation is not permitted.
>
>"In transaction" means using the
>myPool = DBConnectionPool.getInstance(TestSystemInitializer.getTestContext());
>myConnection = myPool.getConnection();
>myConnection.setAutoCommit(false);
>xxxDBO resource = new xxxDBO(myConnection);
>pattern.
>
>As all of the other operations work such way (including simple delete()) I suppose it is an error in Expresso.
>
>Regards,
>
>Gabor
>
>_______________________________________________
>Opensource mailing list
>Opensource at jcorporate.com
>http://mail.jcorporate.com/mailman/listinfo/opensource
>Archives: http://mail.jcorporate.com/pipermail/opensource/
>