I don't care about the logging, I can turn that off. The part that concerns me is that we seem to be repeatly retrieving the permissions and roles form the database on every request.
> -----Original Message----- > From: Chris Kimpton [mailto:[EMAIL PROTECTED]] > Sent: Wednesday, April 17, 2002 11:52 PM > To: Jetspeed Developers List > Subject: Re: Sql select statements in log > > > Hi, > > --- David Sean Taylor <[EMAIL PROTECTED]> wrote: > > Anyone know why the following select statements are now logged with > > every request.... > > > > [22:19:22,415 DEBUG] SELECT TURBINE_ROLE.ROLE_ID FROM TURBINE_ROLE > > WHERE > > (TURBINE_ROLE.ROLE_NAME='turbine') > > [22:19:22,425 DEBUG] SELECT TURBINE_PERMISSION.PERMISSION_ID, > > TURBINE_PERMISSION.PERMISSION_NAME, > TURBINE_PERMISSION.OBJECTDATA FROM > > TURBINE_PERMISSION, TURBINE_ROLE_PERMISSION WHERE > > (TURBINE_ROLE_PERMISSION.ROLE_ID=6) AND > > > TURBINE_ROLE_PERMISSION.PERMISSION_ID=TURBINE_PERMISSION.PERMISSION_ID > > ORDER BY UPPER(TURBINE_PERMISSION.PERMISSION_NAME) ASC > > > > Its do with the logging level - if its set to DEBUG, you get > the SQL ops - I presume from torque. > > You could either switch it to INFO. Which basically means > less logging. > > Or you can get fancier with the log4j config and just select > DEBUG for your classes/categories... > > If you put %c in the output pattern, this will show you which > logger/category a log line is from and thus you could use the > appender config to filter to that category. > > HTH, > Chris > > ===== > ------------------------------------------ > http://www.soccer2002.org.uk > > __________________________________________________ > Do You Yahoo!? > Yahoo! Tax Center - online filing with TurboTax http://taxes.yahoo.com/ -- 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]>
