Starting JDBC Driver Manager Trace in the development environment

To start JDBC Driver Manager Trace in the PowerBuilder development environment, edit the database profile for the connection you want to trace, as described in the following procedure.

StepsTo start JDBC Driver Manager Trace by editing the database profile:

  1. Open the Database Profile Setup - JDBC dialog box for the JDB connection you want to trace.

  2. On the Options tab, select the Trace JDBC Calls check box.

  3. (Optional) To specify a log file where you want PowerBuilder 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, PowerBuilder sends JDBC Driver Manager Trace output to the default JDBC.LOG file.

    The sample shows the Options tab page of the Database Profile Setup for J D B C. The Jave V M box displays Sun J R E 1 dot 3. Under J D B C Trace Options, the Trace J D B C Calls check box is selected and the Trace File box  displays c :  temp  j d b c dot log
  4. Click OK or Apply.

    The Database Profiles dialog box displays with the name of the edited profile highlighted. PowerBuilder 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'"
    
  5. 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.

    PowerBuilder connects to the database, starts tracing the JDBC connection, and writes output to the log file you specified.