11. Understanding JDBC Connectivity : JDBC Tracing : JDBC Driver Tracing Using Java Logging Package : Example Logging Configuration
 
Share this page                  
Example Logging Configuration
A simple logging configuration file to enable JDBC Driver and DBMS logging can use the following settings:
ingres.jdbc.trace.log.handlers = java.util.logging.ConsoleHandler
ingres.jdbc.trace.log.level = INFO
ingres.jdbc.trace.drv.level = FINER
ingres.jdbc.dbms.trace.log.handlers = java.util.logging.ConsoleHandler
ingres.jdbc.dbms.trace.log.level = INFO
If the settings shown above are placed in a file, logging.properties, then the following command line can be used to run a Java program, App, with driver tracing enabled at level 3, DBMS tracing enabled, and output sent to the Java system console:
java -Djava.util.logging.config.file=logging.properties App