I tried that out and added your lines at the bottom of tr.props. Nothing is written to the log-file thou. Did you remove anything in tr.props?
Marc > -----Ursprungliche Nachricht----- > Von: Jeffery Painter [mailto:[EMAIL PROTECTED]] > Gesendet: Freitag, 17. Januar 2003 18:45 > An: Turbine Users List > Betreff: Re: show sql statements in logfile > > > 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]> -- To unsubscribe, e-mail: <mailto:[EMAIL PROTECTED]> For additional commands, e-mail: <mailto:[EMAIL PROTECTED]>
