To display this dialog, select Tools|JDBC Monitor, then select Source in the main Monitor window.
Choose the appropriate checkbox for the source you want to monitor. Notice that the three check boxes are mutually exclusive.
To monitor more than one source, you must bring up another instance of the Monitor window.
The JDBC Monitor will monitor any JDBC driver (i.e. any subclass of java.sql.Driver). However, the monitor is most informative with Borland's DataGateway JDBC drivers.
After you define a server, JDBC Monitor displays a list of URLs for every alias defined on that machine, including an option to monitor all aliases on that machine. This gives instant connectivity to all BDE drivers running on another machine (i.e., the "middle tier"). Selection of a single alias will restrict monitoring to that alias.
To monitor more than one source, you must bring up another instance of the Monitor window.
The following table describes the output you will see in the JDBC Monitor depending on which source is selected. In this table and in this document, Local and Bridge are synonymous and Remote and Broker are synonymous. The log output from DataGateway is quite different from the output from JDBC.
Driver Class | Output Intercepted | Description |
java.sql.Driver | DriverManager.getLogStream() | Standard JDBC driver class. The logStream is supported by the single driver Manager, so there is just one log stream for all of the JDBC drivers running under a VM. |
borland.jdbc.Bridge.LocalDriver | borland.jdbc.Bridge.Monitor | A monitor is a streamable output which can be attached at one of two levels:
|
borland.jdbc.Broker.RemoteDriver | borland.jdbc.Broker.Monitor | The Broker monitor works similarly to the Bridge monitor, but for remote connections. To use the remote monitor, you must first specify a server name where the Borland Broker is running. You may then attach the monitor at one of two levels:
|
For more information on JDBC Monitor, consult Borland's DataGateway Online User's Guide, available from the DataGateway group when DataGateway is installed.