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: firstname.lastname@example.org > Date: Tue, 13 Aug 2013 15:52:06 -0700 > CC: email@example.com > To: firstname.lastname@example.org > > 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 > > email@example.com > > https://lists.sourceforge.net/lists/listinfo/c3p0-users >