基于数据库应用的主动释放型连接池的研究与实现

The implementation of the voluntary-release connection pool base on DB used

在释放连接时需要直接调用连接对象的close方法才能关闭,因为连接不会主动释放.如果不这样做,可供分配的连接就会越来越少,池中的资源很快会被耗尽,仍然达不到合理利用资源的目的.要解决这个问题,必须从改进对已分配连接的监控入手,让程序能够根据已分配的连接的数据库访问情况,主动关闭并释放一些已分配但在指定时间内未使用的连接,这样才能真正达到有效利用,节省系统资源的目的.

It is necessary to call the （DB） Connection Object＇s close method directly to release the Connection,prevent the resource in the pool becomes shorter and insufficient,because the Connection Object can not close by itself. This resource usage is improperly. To solve this problem, it must improve the way of supervise, after the connection is provided. The application collect the DB Access information about the provided connection and autorelease some connection which is time out for usage. Then the system resource will be saved and used properly.