BEA WebLogic JDBC Spy is a wrapper that wraps a BEA WebLogic Type 4 JDBC driver. It logs detailed information about JDBC calls issued by an application and then passes the calls to the wrapped WebLogic Type 4 JDBC driver. You can use the information in the logs to help troubleshoot problems in your application. WebLogic JDBC Spy provides the following advantages:
Note: The WebLogic JDBC Spy implements standard JDBC APIs only. It does not implement JDBC extensions implemented in other WebLogic Type 4 JDBC drivers. If your application uses JDBC extensions, you may see errors when using the WebLogic JDBC Spy.
To use WebLogic JDBC Spy with WebLogic Server, you add JDBC Spy attributes to the end of the URL in the JDBC connection pool configuration. Follow these instructions for modifying your connection pool configuration:
WL_HOME
/server/lib/wlspy.jar
to your CLASSPATH, where WL_HOME
is the directory in which you installed the WebLogic Server software, typically C:\bea\weblogic81
.config.xml
file for your WebLogic domain, append the WebLogic JDBC Spy options to the connection pool URL. Enclose all JDBC Spy options in one set of parentheses; separate multiple options with a semi-colon.In the Administration Console on the JDBCConnectionPool spyAttributes
to the end of the existing URL. For example:
jdbc:bea:DB2://db2host:50000;user=john;
spyAttributes=(log=(file)d:\spy.log;timestamp=yes)
Alternatively, in the config.xml
file, update the URL in the JDBC connection pool entry. For example:
<JDBCConnectionPool Name="datasource"
Password="{3DES}0zvizFP1" Targets="myserver"
InitialCapacity="10" MaxCapacity="10"
DriverName="weblogic.jdbcx.db2.DB2DataSource"
Properties="user=john;DatabaseName=wls;PortNumber=50000;
ServerName=db2host;batchPerformanceWorkaround=true"
URL="jdbc:bea:DB2://db2host:50000;user=john;
spyAttributes=(log=(file)d:\spy.log;timestamp=yes)"
SupportsLocalTransaction="true"
KeepXAConnTillTxComplete="true"
/>
Table E-1 lists the options available for configuring WebLogic JDBC Spy. Use these options as attributes for the spyAttributes property for an XA driver or in the URL for a non-XA driver.
The superscript Numbers are note indicators. See the notes following the example for the referenced text.
All rights reserved.1
registerDriver:driver[className=weblogic.jdbcspy.SpyDriver,
context=null,weblogic.jdbcspy.SpyDriver@1ec49f]2
*Driver.connect(jdbc:spy:{jdbc:bea:sqlserver://QANT:4003;
databaseName=Test;})
trying driver[className=weblogic.jdbcspy.SpyDriver,
context=null,weblogic.jdbcspy.SpyDriver@1ec49f]3
spy>> Driver.connect(String url, Properties info)
spy>> url = jdbc:spy:{jdbc:bea:sqlserver://QANT:4003;databaseName=Test;
OSUser=qauser;OSPassword=null12}
spy>> info = {password=tiger, user=scott}
spy>> OK (Connection[1])4
getConnection returning driver[className=weblogic.jdbcspy.SpyDriver,
context=null,weblogic.jdbcspy.SpyDriver@1ec49f]5
spy>> Connection[1].getWarnings()
spy>> OK6
spy>> Connection[1].createStatement
spy>> OK (Statement[1])7
spy>> Statement[1].executeQuery(String sql)
spy>> sql = select empno,ename,job from emp where empno=7369
spy>> OK (ResultSet[1])8
spy>> ResultSet[1].getMetaData()
spy>> OK (ResultSetMetaData[1])9
spy>> ResultSetMetaData[1].getColumnCount()
spy>> OK (3)10
spy>> ResultSetMetaData[1].getColumnLabel(int column)
spy>> column = 1
spy>> OK (EMPNO)11
spy>> ResultSetMetaData[1].getColumnLabel(int column)
spy>> column = 2
spy>> OK (ENAME)12
spy>> ResultSetMetaData[1].getColumnLabel(int column)
spy>> column = 3
spy>> OK (JOB)13
spy>> ResultSet[1].next()
spy>> OK (true)14
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 1
spy>> OK (7369)15
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 2
spy>> OK (SMITH)16
spy>> ResultSet[1].getString(int columnIndex)
spy>> columnIndex = 3
spy>> OK (CLERK)17
spy>> ResultSet[1].next()
spy>> OK (false)18
spy>> ResultSet[1].close()
spy>> OK19
spy>> Connection[1].close()
spy>> OK20
1 The BEA WebLogic JDBC Spy driver is registered. The spy>> prefix indicates that this line has been logged by BEA WebLogic JDBC Spy.
2 The JDBC Driver Manager logs a message each time a JDBC driver is registered.
3 This is the logging of the JDBC Driver Manager. It logs a message each time a JDBC application makes a connection.
4 The application connects with the specified URL. The User Name and Password are specified using properties.
5 This is the logging of the JDBC Driver Manager. It logs a message each time a successful connection is made.
6 The application checks to see if there are any warnings. In this example, no warnings are present.
7, 8 The statement "select empno,ename,job from emp where empno=7369" is created.
9, 10, 11, 12, 13 Some metadata is requested.
14, 15, 16, 17 The first row is fetched and its data retrieved.
18 The application attempts to fetch the second row, but the database returned only one row for this query.