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