[c3p0-users] Integrating c3p0 with a custom datasource

[Brian S. <bri...@ho...>]

Greetings,I have a problem that I'm hoping someone can help me solve or, at the very least, give me some direction. I have implemented a custom datasource which can be thought of as a pool/router. At the login screen, the user enters their iSeries login/password and selects an environment which is really a key/alias for a Library List. Once they have authenticated, a com.ibm.as400.access.User object, and environment String are placed into the HTTP session. Once that has occurred, DataSource.getConnection() will work.
See: http://pastebin.com/2LNNcFNT
There is a com.ibm.as400.access.AS400JDBCConnectionPoolDataSource, but it doesn't accept an AS400 object like its super class does.
So, what I'm looking to do is somehow implement connection pooling on a per targetDataSource basis. Please advise. Thanks!
Brian Sanders