Luc Dewavrin's weblog

Enable Logging for JDBC's Thin Driver in Weblogic

| Comments

Here’s a quick and dirty tip to enable JDBC logging for Oracle thin drivers.Enabling JDBC logging for connections of a pool is straightforward with JDBC connection proxies like p6spy tool. Sadly some applications still don’t use connection pools configured on J2EE application server and connect directly to database without retrieving a connection from a pool and with the JDBC URL hardcoded. For the latters, you can still trace JDBC activity.

To do so:

  • 1) Configure Weblogic server, to use the Oracle’s debug thin driver which is called ojdbc14_g.jar and its located in the $WEBLOGIC_HOME/server/ext/jdbc/oracle/ directory. Just add it in the server’s CLASSPATH the path to this library.

  • 2) Put the following class in the server’s CLASSPATH to control the logging level. The default one (2) is very high it creates a huge amount of log. This class takes as first argument the log levelwhich should go from 1 (lower) to 3 (higher)

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50

    import oracle.jdbc.driver.OracleLog;
    import weblogic.logging.NonCatalogLogger;

    /**
     Class that sets the Oracle thin driver log level 
    */

    public class OracleLoggingSetter {

	   protected final static NonCatalogLogger logger = new NonCatalogLogger("OracleLoggingSetter");
	   static final int LOWLOGLEVEL=1;
	   static final int MEDIUMLOGLEVEL=2;
	   static final int HIGHLOGLEVEL=3;

	   public static void main(String[] args) {

	   	int loglevel=0;

	   	try {
	   		loglevel=Integer.parseInt(args[0]);
	   	}
	   	catch(NumberFormatException e) {
	   		logger.error("Wrong oracle log level");
	   		return;
	   	}

	   	switch (loglevel) {
		case 1:
			logger.info("Setting oracle low log level ");
			OracleLog.setLogVolume(LOWLOGLEVEL);
			break;

		case 2:
			logger.info("Setting oracle default log level ");
			OracleLog.setLogVolume(MEDIUMLOGLEVEL);
			break;

		case 3:
			logger.info("Setting oracle high log level ");
			OracleLog.setLogVolume(HIGHLOGLEVEL);
			break;

		default:
			logger.info("log level is incorrect or unspecified, no action performed ");
			break;
		}

	   }

}

  • 3) Configure Weblogic to use this startup class and give the log level as an argument (1 is fineand doesn’t fill too quickly).(On the Startup & shutdown node of the adminisration console )

  • 4) Enable JDBC logging for the Weblogic server in the administration console.(Server node -> Logging tab -> JDBC tab )

  • 5) Restart the server

Now you should see the connection string used, the SQL (prepared)statementsand the Oracle’s session attributes in the JDBC log file.Note that enabling logging has a great impact on performance even when the logging levelis low.

Comments