How to set logging level for JDBCDriverLogging

Posted by Scott on Stack Overflow See other posts from Stack Overflow or by Scott
Published on 2010-05-26T14:38:20Z Indexed on 2010/05/29 18:52 UTC
Read the original article Hit count: 183

Filed under:
|
|

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.

© Stack Overflow or respective owner

Related posts about java

Related posts about logging