I frequently turn on logging for the org.jboss.ejb.plugins.cmp category. That works fine without shutting down JBoss, however trying to turn off cmp logging wont work without shutting down JBoss. I can see that the log4j.xml file has been reread after commenting out the category but the SQL keeps appending. Very annoying on live system...
Running JBoss-3.2.7. BR Niklas.
Set your category back to INFO (or WARN, ERROR, FATAL, or OFF) rather than "DEBUG". The level that you choose should be the level you gave the root logger in order to switch back to "default" behavior. Removing a logger from the configuration file does not "remove" it. That does not make sense from a log4j point of view.