Primrose is a mature open source database connection pool; written in Java; for standalone and web-based Java applications.
Features include :
- 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.
其他Java 对象池与连接池 开源项目资源: