Clarity

Hello,

I am looking for a tool that can give me more granular JDBC log details between Clarity/Apache Tomcat and Oracle.

DataDirect Spy has the ability to give more granular log details but the latest release has removed the spy.jar from the product (Progress KB - Where is spy.jar?). All the documentation I found references this jar file for you to use Spy, but has anyone used this product to log JDBC calls? If so can you share any documentation you used to get it working?

Cheers

Found that Clarity has inbuilt JDBC Logging
See below:

Data Direct JDBC Logging

Activating JDBC logging at the Data Direct level can provide some low level logging.   (This should only be done for really low level problems and could result is huge logs)

1) Access the CSA

2) Choose the server to change connection for

3) Choose the database link

4) Under your Internal Connection, choose the specify URL checkbox.

5) Now modify the JDBC URL by appending the following line to it. 

;SpyAttributes=(log=(file)C:\\temp\\spy.log;linelimit=255;logTName=yes;timestamp=yes)

Note: if the URL already ends in a semi-colon just omit the one above preceeding the SpyAttributes.

  For Unix based environments, you would use a log file such as: /tmp/spy.log instead of the C:\\ reference.