启动JDBC Debug模式，打印JDBC诊断日志

1.下载Debug版本jar包

首先要下载一个Debug版本的JDBC jar包，Debug版本的jar包命名形式为jdbcX_g.jar

2.启动Logging模式

第一种方式：设置运行环境变量 java -Doracle.jdbc.Trace=true ...（elipse中run->run configurations->arguments一栏）

第二种方式：在程序中控制（建议采用这种方式）

<table border="0" cellpadding="0" cellspacing="0" class="syntaxhighlighter  java " style="border-spacing: 0px; font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; width: 614px; color: rgb(51, 51, 51); border: 1px solid rgb(204, 204, 204) !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: auto !important; position: relative !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; min-height: auto !important; font-size: 13px !important; margin: 0.3em 0px !important; padding: 0px !important; border-radius: 4px !important; background: none rgb(245, 245, 245) !important;"><tbody style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;"><tr style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;"><td class="code" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; width: 577px; margin: 0px !important; padding: 0px !important; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; min-height: auto !important; font-size: 13px !important; border-radius: 0px !important; background: none !important;"><div class="container" style="width: 1100px; margin: 0px auto; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: relative !important; right: auto !important; top: auto !important; vertical-align: baseline !important; box-sizing: content-box !important; min-height: auto !important; padding: 0px !important; border-radius: 0px !important; background: none !important;"><div class="line number1 index0 alt2" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">      MBeanServer mbs = ManagementFactory.getPlatformMBeanServer();</code></div><div class="line number2 index1 alt1" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java spaces" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;">      </code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">String loader = Thread.currentThread().getContextClassLoader().toString().replaceAll(</code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">"[,=:\"]+"</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">, </code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">""</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">);</code></div><div class="line number3 index2 alt2" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java spaces" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;">      </code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">ObjectName pattern = </code><code class="java keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">new</code> <code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">ObjectName(</code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">"com.oracle.jdbc:type=diagnosability,name="</code> <code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">+ loader);</code></div><div class="line number4 index3 alt1" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java spaces" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;">      </code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">ObjectName diag = ((ObjectName[]) (mbs.queryNames(pattern, </code><code class="java keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">null</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">).toArray(</code><code class="java keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">new</code> <code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">ObjectName[</code><code class="java value" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 153, 0) !important; background: none !important;">0</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">])))[</code><code class="java value" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 153, 0) !important; background: none !important;">0</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">];</code></div><div class="line number5 index4 alt2" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java spaces" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;">      </code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">mbs.setAttribute(diag, </code><code class="java keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">new</code> <code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">Attribute(</code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">"LoggingEnabled"</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">, </code><code class="java keyword" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; font-weight: 700 !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(255, 120, 0) !important; background: none !important;">true</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">));</code></div><div class="line number6 index5 alt1" style="border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px 1em !important; border-radius: 0px !important; background: none !important;"><code class="java spaces" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; background: none !important;">      </code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">System.out.println(</code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">"LoggingEnabled = "</code> <code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">+ mbs.getAttribute(diag, </code><code class="java string" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 255) !important; background: none !important;">"LoggingEnabled"</code><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">));</code></div><div><code class="java plain" style="font-family: Monaco, Menlo, Consolas, 'Courier New', monospace; border: 0px !important; bottom: auto !important; float: none !important; left: auto !important; line-height: 1.1em !important; outline: 0px !important; overflow: visible !important; position: static !important; right: auto !important; top: auto !important; vertical-align: baseline !important; width: auto !important; box-sizing: content-box !important; min-height: auto !important; margin: 0px !important; padding: 0px !important; border-radius: 0px !important; color: rgb(0, 0, 0) !important; background: none !important;">
</code></div></div></td></tr></tbody></table><span style="color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif, tahoma, 'Microsoft YaHei'; font-size: 14px; line-height: 24px; background-color: rgb(243, 255, 236);">如果用的是</span><a target=_blank href="https://www.baidu.com/s?wd=Oracle&tn=44039180_cpr&fenlei=mv6quAkxTZn0IZRqIHckPjm4nH00T1YLmW0YnWKbrj6snhDYn1b30ZwV5Hcvrjm3rH6sPfKWUMw85HfYnjn4nH6sgvPsT6KdThsqpZwYTjCEQLGCpyw9Uz4Bmy-bIi4WUvYETgN-TLwGUv3EnW0dnWbznWcYrjD3rHDzPHnYPs" target="_blank" class="baidu-highlight" rel="nofollow" style="color: rgb(45, 100, 179); text-decoration: none; font-family: arial, 宋体, sans-serif, tahoma, 'Microsoft YaHei'; font-size: 14px; line-height: 24px; background-color: rgb(243, 255, 236);">Oracle</a><span style="color: rgb(51, 51, 51); font-family: arial, 宋体, sans-serif, tahoma, 'Microsoft YaHei'; font-size: 14px; line-height: 24px; background-color: rgb(243, 255, 236);"> 10g,直接执行：</span>

      oracle.jdbc.driver.OracleLog.setTrace( true );  // enable logging

       oracle.jdbc.driver.OracleLog.setTrace( false );  // disable logging

3.配置log文件

jdbc使用的是 java.util.logging包中的Logger对象打印log。

/**配置log文件*/

      Handler fh =  new  FileHandler( "./oracle_jdbc_log.log" );

      fh.setLevel(Level.ALL);

      fh.setFormatter( new  SimpleFormatter());

      Logger.getLogger( "" ).addHandler(fh);

      Logger.getLogger( "" ).setLevel(Level.ALL);

完成的Demo

import  javax.management.Attribute;

import  javax.management.AttributeNotFoundException;

import  javax.management.InstanceNotFoundException;

import  javax.management.InvalidAttributeValueException;

import  javax.management.MBeanException;

import  javax.management.MBeanServer;

import  javax.management.MalformedObjectNameException;

import  javax.management.ObjectName;

import  javax.management.ReflectionException;

public  void  run()  throws  SQLException {

    DriverManager.registerDriver( new  OracleDriver());

    //需在加载OracleDriver之后开启log

    enableOracleLogging();

    Connection conn =  null ;

    Statement stmt =  null ;

    ResultSet rset =  null ;

    try  {

      conn = getConnection();

      System.out.println( "Connection retrieved.." );

      stmt = conn.createStatement();

      rset = stmt.executeQuery( "select empno from emp" );

      while  (rset.next()) {

        System.out.println(rset.getInt( 1 ));

      }

    }  catch  (SQLException sqle) {

      sqle.printStackTrace();

    }  finally  {

      if  (rset !=  null ) {

        rset.close();

      }

      if  (stmt !=  null ) {

        stmt.close();

      }

      if  (conn !=  null ) {

        conn.close();

      }

    }

  }

public  static  void  enableOracleLogging() {

    try  {

      /** 配置log文件 */

      Handler fh =  new  FileHandler( "./oracle_jdbc_log.log" );

      fh.setLevel(Level.ALL);

      fh.setFormatter( new  SimpleFormatter());

      Logger.getLogger( "" ).addHandler(fh);

      Logger.getLogger( "" ).setLevel(Level.ALL);

      /** oracle 11g 启动方法 */

      MBeanServer mbs = ManagementFactory.getPlatformMBeanServer();

      String loader = Thread.currentThread().getContextClassLoader().toString().replaceAll( "[,=:\"]+" ,  "" );

      ObjectName pattern =  new  ObjectName( "com.oracle.jdbc:type=diagnosability,name="  + loader);

      ObjectName diag = ((ObjectName[]) (mbs.queryNames(pattern,  null ).toArray( new  ObjectName[ 0 ])))[ 0 ];

      mbs.setAttribute(diag,  new  Attribute( "LoggingEnabled" ,  true ));

      System.out.println( "LoggingEnabled = "  + mbs.getAttribute(diag,  "LoggingEnabled" ));

      /** oracle 10g 启动方法 */

      // oracle.jdbc.driver.OracleLog.setTrace(true); // enable logging

      // oracle.jdbc.driver.OracleLog.setTrace(false); // disable logging

 

    }  catch  (Exception e) {

      e.printStackTrace();

    }

  }