Important Notice: Our web hosting provider recently started charging us for additional visits, which was unexpected. In response, we're seeking donations. Depending on the situation, we may explore different monetization options for our Community and Expert Contributors. It's crucial to provide more returns for their expertise and offer more Expert Validated Answers or AI Validated Answers. Learn more about our hosting issue here.

How do I use java.util.logging to get trace output from the Oracle JDBC drivers?

April 26, 2017Drivers javautillogging JDBC Oracle output trace

0

10 Posted

How do I use java.util.logging to get trace output from the Oracle JDBC drivers?

2 Answers

0

Posted

First, you must use either ojdbc14_g.jar or ojdbc14dms_g.jar. These are the only jar files that include logging code. ojdbc14.jar and ojdbc14dms.jar do not include any logging or trace code. classes12_g.jar and classes12dms_g.jar use OracleLog to provide trace output. See the section on the Oracle JDBC Trace Facility for information on how to use OracleLog. Be sure that there are no extra Oracle JDBC jar files in your classpath. Second, you must turn on Oracle JDBC logging.

0

Posted

I thought you’d never ask.First, you must use either ojdbc14_g.jar or ojdbc14dms_g.jar. These are the only jar files that include logging code. ojdbc14.jar and ojdbc14dms.jar do not include any logging or trace code. classes12_g.jar and classes12dms_g.jar use OracleLog to provide trace output. See the section on the Oracle JDBC Trace Facility for information on how to use OracleLog. Be sure that there are no extra Oracle JDBC jar files in your classpath.Second, you must turn on Oracle JDBC logging. You do this by calling oracle.jdbc.driver.OracleLog.setTrace(true). You can turn off all Oracle JDBC trace output by calling setTrace(false). This will generate minimal trace output. To get more and more useful output you need to configure java.util.logging.