Welcome to Primrose
- a mature open source database connection pool for Java & J2EE
Primrose supports :
Current containers supported are Tomcat 4 & 5, JBoss 3,4 & 5, Resin 3, Jetty 5 and Glassfish 2.
There is a standalone version of primrose that can be used for applications not running inside a container - giving your Java applications the benefit of JNDI based pooling.
Features include :
- Highly adaptable configuration file - see the config file documentation 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.
