Re: [c3p0-users] Integrating c3p0 with a custom datasource

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

I think that may be exactly what I'm looking for. After reviewing the site, I'm not sure how I overlooked this. Steve, thanks for the speedy reply. 

> Subject: Re: [c3p0-users] Integrating c3p0 with a custom datasource
> From: swa...@mc...
> Date: Tue, 13 Aug 2013 15:52:06 -0700
> CC: c3p...@li...
> To: bri...@ho...
> 
> 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
> > c3p...@li...
> > https://lists.sourceforge.net/lists/listinfo/c3p0-users
>