Issue #18 resolved

Add support for ConnectionPool

Grace Batumbya
created an issue

From http://code.google.com/p/sqlite-jdbc/issues/detail?id=2

Reported by project member taroleo, Jun 7, 2011

It would be useful if sqlite-jdbc has a support of connection pool like this: http://www.source-code.biz/miniconnectionpoolmanager/

ConnectionPoolDataSource

http://download.oracle.com/javase/1.5.0/docs/api/javax/sql/ConnectionPoolDataSource.html

PooledConnection

http://download.oracle.com/javase/1.5.0/docs/api/javax/sql/PooledConnection.html

Comment 1 by project member taroleo, Jun 9, 2011

Peter Borissow created a sample implementation: http://groups.google.com/group/xerial/browse_thread/thread/8fcfac18a2ee2323?hl=en

Comments (8)

  1. Grace Batumbya reporter

    Looks like this may require a full rewrite in order to comply to current code

    Plus, does any one have experience with copy code from one open source project to another and then modifying it. Concerning licensing, what must be done?

  2. sam_waters

    Thanks for adding JDBC connection pool support. I downloaded the most recent snapshot a couple weeks ago and used it with MiniConnectionPoolManager but found that there was a bug -- connections were being closed after they had already been closed, and this was triggering the manager's ConnectionEventListener#connectionClosed method too many times, messing up the manager's active connections counter. I fixed it in my sqlite-jdbc code by editing SQLitePooledConnection#getConnection such that if isClosed is already set to true, the close code is not executed.

  3. Log in to comment