Components

The DataDirect Connection Pool Manager allows you to pool connections when accessing databases. When your applications use connection pooling, connections are reused rather than created each time a connection is requested. Because establishing a connection is among the most costly operations an application may perform, using Connection Pool Manager to implement connection pooling can significantly improve performance.

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.

DataDirect Test™ is a Java application 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: