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]>
