The other thing you can do is use p6spy (believe that's the name, www.p6spy.org or google it). It acts externally to any code. Basically it acts as a JDBC driver/datasource. Instead of referencing an Oracle driver for example within your database.xml reference the p6spy component. Then the p6spy component knows the oracle driver and passes the call on.
Then when you want it turned off simply refer to the Oracle driver within the database.xml. You could probably write an ANT task that changes the setting within database.xml between the normal driver and the p6spy driver Mark DeLanoy, Architect Technical Architecture Team Technology Solutions Group Home Loans & Insurance Services Business Solution Partner Washington Mutual, Mailstop VHF4A01 340 N. Milwaukee, Vernon Hills, IL 60061 www.wamu.com 847 393 5156 direct | 847 845 9031 cell -----Original Message----- From: Bruce Snyder [mailto:[EMAIL PROTECTED]] Sent: Wednesday, January 15, 2003 7:55 PM To: [EMAIL PROTECTED] Subject: Re: [castor-dev] How to log sql of executed queries? This one time, at band camp, Janina Rubacha said: JR>I need to know if I could log the sql expression that is executed when I JR>execute an OQL query. JR>Thanks in advance, Janina, Please see the following message in the archive to see if it answers your question: http://www.mail-archive.com/[email protected]/msg10801.html HTH. Bruce -- perl -e 'print unpack("u30","<0G)U8V4\@4VYY9&5R\"F9E<G)E=\$\!F<FEI+F-O;0\`\`");' ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev ----------------------------------------------------------- If you wish to unsubscribe from this mailing, send mail to [EMAIL PROTECTED] with a subject of: unsubscribe castor-dev
