Hello Boris, Wednesday, July 24, 2002, 11:23:26 PM, you wrote:
BT> In this case can we change commit option on the fly in run time. BT> I.E. before command "delete all" make commit option "B", at the end change BT> back to "A"? BT> Otherwise it makes option "A" not usable in production environment Why is it so? You, probably, meant in your production environment. As for me, commit option A is just that option for production environment. While developing, it's often needed/convenient to insert/change test data in the db manually. And the app should see this data immediately. But when the app is ready for production and data in the database is accessed only through the app, option A is the best choice. You can also consider option D that invalidates cache periodically. alex BT> Boris BT> Date: Wed, 24 Jul 2002 12:25:38 -0500 BT> From: Dan Christopherson <[EMAIL PROTECTED]> BT> To: [EMAIL PROTECTED] BT> Subject: Re: [JBoss-user] Deleting all records BT> Reply-To: [EMAIL PROTECTED] BT> You'll have ghosts in the cache. BT> Boris Tamarkin wrote: >> Dain, >> Could You please explain why You don't recommend to "delete all" with >> option A? >> >> Thanks, >> Boris >> >> Date: Tue, 23 Jul 2002 23:06:08 -0500 >> From: Dain Sundstrom <[EMAIL PROTECTED]> >> To: [EMAIL PROTECTED] >> Subject: Re: [JBoss-user] Deleting all records >> Reply-To: [EMAIL PROTECTED] >> >> I don't know of any other way then executing "DELETE FROM BLAH". I >> don't recomend you try this in commit option A. >> >> -dain >> >> Dimitri PISSARENKO wrote: >> > Hello! >> > >> > How can one delete all records of a certain table (when using CMP >> > beans) ? >> > >> > Is calling "findAll" and then "remove" for each record the only >> > choice? Isn't there a more elegant solution? >> > >> > Thanks >> > >> > Dimitri Pissarenko >> > >> -- Best regards, Alex Loubyansky ------------------------------------------------------- This sf.net email is sponsored by: Jabber - The world's fastest growing real-time communications platform! Don't just IM. Build it in! http://www.jabber.com/osdn/xim _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
