Tracking JDBC Calls Using Spy Driver for a WebSphere Application Server V4.0 DataSource with DataDirect SequeLink JDBC Driver 5.x or Connect JDBC Driver
 Technote (FAQ)
 
Problem
How to enable a spy log for the DataDirect SequeLink JDBC or Connect JDBC driver within WebSphere® Application Server V4.0.
 
Solution
What is Spy?
Spy is a tracking tool for JDBC calls. It doesn't come with WebSphere Application Server. You can get the tool (spy.jar) from the attachment in this technote.

How to enable Spy with a WebSphere DataSource Using the SequeLink JDBC or Connect JDBC Driver
  1. Put the spy.jar in the WAS_HOME\lib directory (this requires the AdminServer to be restarted)
  2. When creating the Data Source, and specify the Custom Properties, set the following value for the 'spyAttributes':

    log=(file)C:\temp\spy.log;logTName=yes

    Note: Substitute c:\temp and spy.log with desired directory and filename respectively.


 
spy.jar
 
 


Document Information


Product categories: Software > Application Servers > Distributed Application & Web Servers > WebSphere Application Server > Java 2 Connectivity (J2C)
Operating system(s): HP-UX
Software version: 4.0
Software edition:
Reference #: 1104501
IBM Group: Software Group
Modified date: Dec 16, 2004