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.
Controls
-
JDB JDBC
Syntax
|
1 |
TraceFile='<span>tracefile_name</span>' |
Default
None
Usage
The JDBC Driver Manager Trace logs errors and informational
messages originating from the Driver object currently loaded (such
as the 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 Connecting to Your Database.
Examples
To start the JDBC Driver Manager Trace and specify
a log file:
-
Database
profileSelect 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.DbParameter="TraceFile='c: empjdbctrce.log'"