CODEWITHSUNDEEP
javaoracle-databasejdbc
ab11
ab11

Reputation: 20090

How to enable oracle jdbc logging?

I have done the below, but I do not see any jdbc logging:

-Doracle.jdbc.Trace=true -Djava.util.logging.config.file=/tmp/OracleLog.properties

my OracleLog.properties file

.level=SEVERE oracle.jdbc.level=INFO 
oracle.jdbc.handlers=java.util.logging.ConsoleHandler 
java.util.logging.ConsoleHandler.level=INFO 
java.util.logging.ConsoleHandler.formatter=java.util.logging.SimpleFormatter

Any suggestions of anything else I should try?

Upvotes: 1

Views: 4653

Answers (1)

Marmite Bomber
Marmite Bomber

Reputation: 21063

I can reproduce the problem using your properties file

.level=SEVERE oracle.jdbc.level=ALL
oracle.jdbc.handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=ALL
java.util.logging.ConsoleHandler.formatter=java.util.logging.SimpleFormatter

I receive only

 Bad level value for property: .level

You must use this properies file (note the new line after SEVERE)

.level=SEVERE 
oracle.jdbc.level=ALL
oracle.jdbc.handlers=java.util.logging.ConsoleHandler
java.util.logging.ConsoleHandler.level=ALL
java.util.logging.ConsoleHandler.formatter=java.util.logging.SimpleFormatter

Upvotes: 2

Related Questions