Welcome to Primrose
- a mature open source database connection pool for Java SE and J2EE
17 November 2007 : Primrose 3 is here ... a completely rewritten codebase, simplified installs, better documentation, more features, better logging, a lighter framework and the same stable service.
Primrose 2 has been deprecated. We will only be supporting Primrose 2 for critical bug fixes. No further feature development will occur on the codebase. We urge all users to upgrade to Primrose 3 at the earliest convenience.
If you are looking for the old Primose 2 site, then follow this link
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.
