[Biojava-dev] JDBCPooledDataSource regression

Richard Holland holland at ebi.ac.uk
Wed Jan 31 12:40:46 UTC 2007


-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

Andy could you make the change to your local copy of the source file and
email the file to me, that way I can make sure I don't get it wrong when
I commit it.

Richard.

PS. You should probably have your own CVS account - email the OBF
helpdesk and ask for one, saying I told you to. :)


Andy Yates wrote:
> 
> Thomas Down wrote:
>> On 31 Jan 2007, at 12:06, Andy Yates wrote:
>>
>>> Hi,
>>>
>>> Sorry I was meaning if that if that method just becomes:
>>>
>>> public static DataSource getDataSource(final String driver,
>>>                                          final String url,
>>>                                          final String user,
>>>                                          final String pass)
>>>     throws Exception {
>>>
>>>     BasicDataSource ds = new BasicDataSource();
>>>     ds.setUrl(url);
>>>     ds.setDriverClassName(driver);
>>>     ds.setUsername(user);
>>>     ds.setPassword(pass);
>>>     // Set BasicDataSource properties such as maxActive and maxIdle, 
>>> as described in
>>>     // 
>>> http://jakarta.apache.org/commons/dbcp/api/org/apache/commons/dbcp/BasicDataSource.html 
>>>
>>>     ds.setMaxActive(10);
>>>     ds.setMaxIdle(5);
>>>     ds.setMaxWait(10000);
>>>
>>>     return ds;
>>>   }
>>>
>>> Does that still work?
>> Hmmm, I was assuming that BasicDataSource didn't actually do any pooling 
>> itself, and that you needed another layer on top to manage a connection 
>> pool -- that seems to be how all previous revisions of 
>> JDBCConnectionPool worked, so I guess I wasn't alone in thinking this.  
>> But yes, BasicDataSource does seem to do pooling itself (confirmed by 
>> reading the source), so maybe your simpler version is a better idea.  It 
>> certainly works okay for me.
>>
>>            Thomas.
> 
> That's what I thought should have happened :). Can I suggest that this 
> revised version goes into CVS? Anyone got any objections?
> 
> Andy
> _______________________________________________
> biojava-dev mailing list
> biojava-dev at lists.open-bio.org
> http://lists.open-bio.org/mailman/listinfo/biojava-dev
> 
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.2.2 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFFwI5O4C5LeMEKA/QRApbHAJ4pfXb4YqqBdCynKNK2Z3xzgGqcvQCfbl2K
6llWxdpbPek1cSCTAakt/5Q=
=0Zam
-----END PGP SIGNATURE-----



More information about the biojava-dev mailing list