Hello Steve,
No worries. Unfortunately, that wouldn't work. Due to time constraints, I had to think of something and switching to BoneCP resolved the issue.

> Subject: Re: [c3p0-users] Integrating c3p0 with a custom datasource
> From: swaldman@mchange.com
> Date: Tue, 20 Aug 2013 22:09:50 -0700
> CC: c3p0-users@lists.sourceforge.net
> To: briansanders1979@hotmail.com
>
> sorry for the slooow reply.
>
> can you supply values for overrideDefaultUser and overrideDefaultPassword that would work? that'd be the easiest fix.
>
> http://www.mchange.com/projects/c3p0/index.html#overrideDefaultUser
> http://www.mchange.com/projects/c3p0/index.html#overrideDefaultPassword
>
> smiles,
> steve
>
>
>
>
> On Aug 14, 2013, at 8:05 AM, Brian Sanders wrote:
>
> > I'm running into a little roadblock and it seems like this could be a simple fix... When attempting to acquire a connection, C3P0 is passing the username/password to the nested datasource, but the password isn't available.
> >
> > On com.mchange.v2.c3p0.impl.C3P0PooledConnectionPool$1PooledConnectionResourcePoolManager.acquireResource():137, there is a condition: auth.equals( C3P0ImplUtils.NULL_AUTH ) which evaluates to false, thus causing the username/password override to be called. What can I do to make it evaluate to true?
> >
> > > Subject: Re: [c3p0-users] Integrating c3p0 with a custom datasource
> > > From: swaldman@mchange.com
> > > Date: Tue, 13 Aug 2013 15:52:06 -0700
> > > CC: c3p0-users@lists.sourceforge.net
> > > To: briansanders1979@hotmail.com
> > >
> > > hi,
> > >
> > > i'm not sure whether this will work in your setup, but you can use the factory method DataSources.pooledDataSource( ... ) to wrap a cep0 PooledDataSource around an existing, unpooled DataSource.
> > >
> > > See http://www.mchange.com/projects/c3p0/apidocs/com/mchange/v2/c3p0/DataSources.html
> > >
> > > smiles,
> > > steve
> > >
> > >
> > >
> > >
> > > On Aug 13, 2013, at 2:09 PM, Brian Sanders wrote:
> > >
> > > > 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
> > > > ------------------------------------------------------------------------------
> > > > Get 100% visibility into Java/.NET code with AppDynamics Lite!
> > > > It's a free troubleshooting tool designed for production.
> > > > Get down to code-level detail for bottlenecks, with <2% overhead.
> > > > Download for free and get started troubleshooting in minutes.
> > > > http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk_______________________________________________
> > > > c3p0-users mailing list
> > > > c3p0-users@lists.sourceforge.net
> > > > https://lists.sourceforge.net/lists/listinfo/c3p0-users
> > >
> > ------------------------------------------------------------------------------
> > Get 100% visibility into Java/.NET code with AppDynamics Lite!
> > It's a free troubleshooting tool designed for production.
> > Get down to code-level detail for bottlenecks, with <2% overhead.
> > Download for free and get started troubleshooting in minutes.
> > http://pubads.g.doubleclick.net/gampad/clk?id=48897031&iu=/4140/ostg.clktrk_______________________________________________
> > c3p0-users mailing list
> > c3p0-users@lists.sourceforge.net
> > https://lists.sourceforge.net/lists/listinfo/c3p0-users
>