Oracle JDBC debugging

Introduction:
Sometimes it can be very useful to debug Oracle JDBC driver connection workflow.



To do so in scope of Oracle 10g:

1. Replace  ojdbc14.jar with ojdbc14_g.jar. 
2. Get  OracleLog.properties from demo.tar
3. Add Java Runtime arguments: -Doracle.jdbc.Trace=true -Djava.util.logging.config.file=\some_path\OracleLog.properties

See references to download resources 



Logs are going to look like:
Apr 17, 2010 2:44:44 PM oracle.jdbc.pool.OracleDataSource
FINE: OracleDataSource.OracleDataSource()
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setURL
FINE: OracleDataSource.setURL(jdbc:oracle:thin:********
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setUser
FINE: OracleDataSource.setUser(****): returned null
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setPassword
FINE: OracleDataSource.setPassword(*****): returned ngrowner
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setConnectionProperties
FINE: OracleDataSource.setConnectionProperties (value={oracle.net.CONNECT_TIMEOUT=5000} )
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setConnectionCachingEnabled
FINE: OracleDataSource.setConnectionCachingEnabled(true)
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setFastConnectionFailoverEnabled
FINE: OracleDataSource.setFastConnectionFailoverEnabled(true)
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setConnectionCacheName
FINE: OracleDataSource.setCacheName(cacheName=DBIPool)
Apr 17, 2010 2:44:45 PM oracle.jdbc.pool.OracleDataSource setConnectionCacheProperties

References:

1. http://www.oracle.com/technology/software/tech/java/sqlj_jdbc/htdocs/jdbc_10201.html