[Opensource] deleteAll() error?

[fangjm]

Hi,

   We use Expresso 5.0.5 version£¬and we have problems when 
trying to run deleteAll() and delete() in a transaction!

   We can't figure out the problem, and finally replace deleteAll() and 
delete() with plain SQL DELETE statements.

   Has anyone encounted the same problem ?

>the following error message:	

======= 2003-09-24 14:00:00 £º=======

>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/

= = = = = = = = = = = = = = = = = = = =
			

				 
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡fangjm
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡fzxfjl at public.cz.js.cn
¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡¡2003-09-25