TraceFile
database parameter
Description
Specifies that the JDBC Driver Manager Trace tool should trace a
connection to the database you access through the PowerBuilder JDBC
interface.
Applies to
JDB JDBC
Syntax
|
1 |
TraceFile='tracefile_name' |
Default value
None
Usage
The JDBC Driver Manager Trace logs errors and informational
messages originating from the Driver object currently loaded (such as
the SAP Sybase jConnect JDBC driver) when PowerBuilder connects to a
database through the JDBC interface. It writes this information to a log
file (default is JDBC.LOG) or to a file you specify. The amount of trace
output varies depending on the JDBC driver being used.
You can start and stop the JDBC Driver Manager Trace in the
PowerBuilder development environment by editing the database profile for
the connection you want to trace. You can also start and stop the JDBC
Driver Manager Trace in a PowerBuilder application by specifying the
TraceFile parameter in the appropriate script.
For more information about using the JDBC Driver Manager Trace
tool, see the section called “Using the
JDBC Driver Manager Trace tool” in Connecting to Your Database.
Examples
To start the JDBC Driver Manager Trace and specify a log
file:
-
Database profile
Select the Trace JDBC Calls check box and type the following
in the Trace File box on the Options page in the Database Profile
Setup dialog box:1c: empjdbctrce.log -
Application
Type the following in code:
1SQLCA.DBParm="TraceFile='c: empjdbctrce.log'"