To start JDBC Driver Manager Trace, edit the database profile for the connection you want to trace, as described in the following procedure.
To start JDBC Driver Manager Trace:
Open the Database Profile Setup - JDBC dialog box for the JDB connection you want to trace.
On the Options tab, select the Trace JDBC Calls check box.
(Optional) To specify a log file where you want InfoMaker to write the output of JDBC Driver Manager Trace, type the path name in the Trace File box, or click Browse to display the path name of an existing log file in the Trace File box.
By default, if the Trace JDBC Calls check box is selected and no alternative trace file is specified, InfoMaker sends JDBC Driver Manager Trace output to the default JDBC.LOG file.
Click OK or Apply.
The Database Profiles dialog box displays with the name of the edited profile highlighted. InfoMaker saves your settings in the database profile entry in the registry.
For example, here are the DBMS and DBParm string values of a database profile entry for a database named Employee. The settings that start JDBC Driver Manager Trace (corresponding to the TraceFile DBParm parameter) are emphasized.
DBMS "TRACE JDBC"
DbParm "Driver='com.sybase.jdbc3.jdbc.SybDriver', URL='jdbc:sybase:Tds:199.93.178.151: 5007/tsdata',TraceFile='c:\temp\jdbc.log'"
Click Connect in the Database Profiles dialog box to connect to the database
or
Right-click on the connected database and select Re-connect from the drop-down menu in the Database Profiles dialog box.
InfoMaker connects to the database, starts tracing the JDBC connection, and writes output to the log file you specified.
