Yes, updating multiple tables in the same transaction is very frequent. Thanks for the info! I'm looking forward working with it, it seems a real improvement.
Pascal. -----Original Message----- From: Christian Haul [mailto:[EMAIL PROTECTED]] Sent: Saturday, February 23, 2002 3:23 PM To: [EMAIL PROTECTED] Subject: Re: howto make use of default database add, delete, update action for mutilple table at a time On 22.Feb.2002 -- 11:13 PM, Pascal Davoust wrote: > I read in a post a few days ago (or was it in the archive?) that there were > some serious limitations with these actions, and that some work is currently > done to overcome those (something is already available in the scratchpad to > have a look, I believe). A word of warning: The way the actions are used (declaration of modes and all classnames will change very shortly. Actually, that work is already done but since I haven't found the (spare) time to check they still work as expected it's not in the CVS, yet. Hope to find some time over this weekend though.) What is "better" with the new ones: *) all actions work on arbitrary number of tables *) all actions may work on arbitrary number of tuples *) configuration is done in one file, table-sets select the tables to work on *) autoincrement columns work better (currently mysql, hsqldb, informix, but it's very easy to support any other as well) *) values can be obtained from arbitrary sources, source can be specified per table-set and column *) results can be written to arbitrary destinations *) in- / output helper modules can be used with other components like matchers, selectors, actions (currently, only one example exists) *) currently available modules: request attributes (in/out), request parameters (in), request header (in) session attributes (in/out) more to come... What is "worse" with the new ones: *) descriptor file syntax has changed *) uses additional components -> more complex -> slower (?) *) changes are on the way > Does anybody know if this *serious* limitation could be part of the new, > future, top-notch database actions? What limitation are you refering to? Updating multiple tables / rows? Yes, that should be possible. Chris. -- C h r i s t i a n H a u l [EMAIL PROTECTED] fingerprint: 99B0 1D9D 7919 644A 4837 7D73 FEF9 6856 335A 9E08 --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]> _________________________________________________________ Do You Yahoo!? Get your free @yahoo.com address at http://mail.yahoo.com --------------------------------------------------------------------- Please check that your question has not already been answered in the FAQ before posting. <http://xml.apache.org/cocoon/faqs.html> To unsubscribe, e-mail: <[EMAIL PROTECTED]> For additional commands, e-mail: <[EMAIL PROTECTED]>