DataDirect Test™ is a pure Java software component developed by Progress DataDirect to test JDBC applications. You can use DataDirect Test to test your connections. It can also be used as a tool to help developers learn the JDBC API.
DataDirect Test menu items correspond to specific JDBC functions, for example, connecting to a database or passing a SQL statement. DataDirect Test allows you to execute single or multiple JDBC methods simultaneously, so that you can easily perform common tasks, such as returning result sets. DataDirect Test displays the results of JDBC calls in one window, while displaying fully commented, JDBC code in an alternate window.
DataDirect Spy™ is a feature for tracking and logging detailed information about JDBC calls made by the driver at runtime. DataDirect Spy provides the following advantages:
Logging is compliant with JDBC 4.0
All parameters and results for JDBC calls can be logged
Logging can be enabled without changing the application
You can use the DataDirect Statement Pool Monitor to load statements into and remove statements from a statement pool as well as generate information to help you troubleshoot statement pooling performance. The Statement Pool Monitor is an integrated component of the drivers. It is implemented as a Java Management Extensions (JMX) MBean. Applications can access the Statement Pool Monitor using the standard JMX API or using methods in the DataDirect-specific ExtConnection interface. Because the Statement Pool Monitor is implemented as a JMX MBean, it can easily be used by any JMX-compliant tool, such as JConsole.
See Statement Pool Monitor for more information about managing statement pools with the DataDirect Statement Pool Monitor.
Logging is compliant with JDBC 4.0