Primrose 2.7.1 review

Primrose is a database connection pool which supports all databases that have JDBC drivers. It provides control over SQL transacti

License: LGPL (GNU Lesser General Public License) File size: 106K Developer: Primrose Team

0

Primrose is a database connection pool which supports all databases that have JDBC drivers.

It provides control over SQL transaction monitoring, configuration, and dynamic pool management via a Web interface.

Here are some key features of "Primrose":
Optional notification of crisis events.
Highly adaptable configuration file - see the config file for all the options.
SQL statement monitoring for connections, including what connection is called from what code and the precise SQL it is performing, including '?' parameters.
Starting/Stopping pools without application restarts
Adding / removing connections on the fly
Automated retrieval of duff connections
A web interface for pool management
Queueing of connection requests during heavy load.
Statistics for types of SQL statements executed and executiion times, to provide a complete overview of webapp-db interaction
Multiple pool instances, managed through one interface.
No more forgotton unclosed Statement and ResultSet objects - primrose closes them for you.
Easy deployment and integration with your webapp container.
No need to rewrite your client code to utilise the pool.
Enhances debug of poor performing client code - if a connection hangs, the precise connection, and the exact SQL it is performing is logged, including what client Java code called it.

What's New in This Release:
This release adds the ability to add a SQL statement to a run before handing a connection out, the ability specify an encryption key file, and a minor bugfix.