DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT <http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16718>. ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND INSERTED IN THE BUG DATABASE.
http://nagoya.apache.org/bugzilla/show_bug.cgi?id=16718 [PATCH] Using only one connection in SQLTransformer Summary: [PATCH] Using only one connection in SQLTransformer Product: Cocoon 2 Version: 2.0.4 Platform: All OS/Version: All Status: NEW Severity: Enhancement Priority: Other Component: sitemap components AssignedTo: [EMAIL PROTECTED] ReportedBy: [EMAIL PROTECTED] In the current implementation of the SQLTransformer, a new db connection is created for each <execute-query/> element. This makes it impossible to use transactions, temporary tables etc in db:s without stored procedures, e.g. MySQL. It is also a waste of cpu cycles. See the thread: http://marc.theaimsgroup.com/?t=103978793000002&r=1&w=2 for more details. The current patch uses only one connection for each use of the SQLTransformer. There is still one connection for each sub query, but there is not much to do about that. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, email: [EMAIL PROTECTED]
