I found this a bit confusing at first too. the answer is not apparent in documentation, but easy to fix.
I created a seperate log file just for my sql statements. services.LoggingService.sql.destination.file=/logs/app-sql.log and then add sql to your services.LoggingService.facilities service.LoggingService.facilities=system,sql,debug,security services.LoggingService.sql.destination.file=/logs/app-sql.log services.LoggingService.sql.className=org.apache.turbine.services.logging.FileLogger services.LoggingService.sql.level=DEBUG all sql statements will then be logged. HTH! Jeff Painter [EMAIL PROTECTED] On Fri, 17 Jan 2003, Johnny Quazar wrote: > Hey Rick, > > I too want this, just saw an alternative that looks good though I > haven't tried it. Also there's a thread about it on this list some > where, I don't know if it concludes "hey that works" or not. > > But the better answer seems to be at http://www.p6spy.com/ > > Good luck. > > At 2:38 PM +0100 1/17/03, peter riegersperger wrote: > >-----BEGIN PGP SIGNED MESSAGE----- > >Hash: SHA1 > > > >hi! > > > >i've set > >services.LoggingService.system.level=DEBUG > >services.LoggingService.sql.level=DEBUG > >in order to see all sql statements generated by torque, not just SELECTs. > >yet, i still see only select-statements. > > > >i'm interesting in seeing UPDATE and INSERT as well. how can i enable them in > >the logs? > > -- > To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> > For additional commands, e-mail: <mailto:[EMAIL PROTECTED]> > -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
