How to set logging level for JDBCDriverLogging
- by Scott
I am trying to change the logging level to stop showing millions of this:
<May 26, 2010 10:26:02 AM EDT> <Debug> <JDBCDriverLogging> <000000> <2336: 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 20 | |>
I have tried adding this to my java line:
-Djava.util.logging.config.file=/foo/bar/logging.properties
With this as my logging.properties file:
handlers = java.util.logging.ConsoleHandler
.level = OFF
java.util.logging.ConsoleHandler.level = INFO
No luck. I have tried this:
Logger logger = Logger.getLogger("com.microsoft.sqlserver.jdbc");
Handler handler = new ConsoleHandler();
handler.setLevel(Level.INFO);
logger.addHandler(handler);
logger.setLevel(Level.INFO);
logger.setUseParentHandlers(false);
No luck. I have searched around and all ideas center around one of these two options, so I must be doing something else wrong
I am using jtds-1.2.2.jar.
Thanks for any suggestions.