commons-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Dirk Verbeeck <>
Subject Re: [DBCP] configuration confusion..
Date Sat, 24 Jul 2004 11:24:21 GMT
Answers inline...

James Blashill wrote:

> Hello,
> I'm hoping someone can clarify some things about configuring DBCP for
> me. I've been reading through the documentation on the web page and I
> seem to be missing something. :(
> I am trying to make use of configuration properties specified here:
> However, I am not sure exactly how to do that. Here is my code for
> creating a DataSource.
>         ObjectPool connectionPool = new GenericObjectPool(null);
>         ConnectionFactory connectionFactory = new
> DriverManagerConnectionFactory(MessageFormat.format(connectUri, args),
> user, password);
>         PoolableConnectionFactory poolableConnectionFactory = new
> PoolableConnectionFactory(connectionFactory, connectionPool, null, null,
> false, true);
>         PoolingDataSource dataSource = new
> PoolingDataSource(connectionPool);
> Looking through javadocs, I realized that most of the configuration
> options above can be specified in the constructors for either
> GenericObjectPool or PoolableConnectionFactory. However, I still have a
> few problems:
> 1) How is prepared statement pooling enabled/disabled? The above link
> describes a poolPreparedStatements property that I have figure out where
> to specify. It seems to me that if you pass a KeyedObjectPool as the
> third parameter of PoolableConnectionFactory's constructor you will
> enable prepared statement pooling. Is this correct?

You pass a KeyedObjectPoolFactory as the third parameter. Each 
PoolableConnection needs its own KeyedObjectPool to pool the prepared 
statements so the PoolableConnectionFactory needs a factory to create 
these pools.

> 2) How do I specify the loginTimeout value? PoolingDataSource gives me
> an UnsupportedOperationException when I try to invoke it's
> setLoginTimeout() method.

You can use a DataSourceConnectionFactory and set the login timeout on 
the original non-pooling datasource. Also set the maxWait property.

> 3) Just out of curiosity, what goes into the Properties parameter for
> the constructor of DriverManagerConnectionFactory? Parameters you want
> to use to initialize your driver?

I will add the following javadoc:
      * Constructor for DriverManagerConnectionFactory.
      * @param connectUri a database url of the form
      * <code> jdbc:<em>subprotocol</em>:<em>subname</em></code>
      * @param props a list of arbitrary string tag/value pairs as
      * connection arguments; normally at least a "user" and "password"
      * property should be included.

> Sorry for the long email, but I appreciate any words of wisdom out
> there! :)

Hope this helps


To unsubscribe, e-mail:
For additional commands, e-mail:

View raw message