PooledStatement (ID #24195)

OOP-Reserch Corporation

The main class of this API is PooledPS. PoolesPS caches the pairs of JDBC Connection and JDBC PreparedStatement in its pools.
Because the same SQL statement is called again and again on the typical online transaction system, the pooling mechanism can avoid the I/O overhead on opening new connections repeatedly.
PooledPS takes care of all the tasks related with JDBC Connection and JDBC PreparedStatement. And the source code of your Java program can be as simple as possible.

PooledStatement home page