RE: [dbcp] setting connection defaults

2015-09-06 Thread Martin Gainty 
Container usually define attributes of DataSource it will support SO Tomcat 
will configure connection-pool thusly:
https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html
HTH
Martin 
__ 

  


> Subject: Re: [dbcp] setting connection defaults
> To: user@commons.apache.org
> From: phil.ste...@gmail.com
> Date: Thu, 3 Sep 2015 18:57:27 -0700
> 
> On 9/3/15 12:26 PM, Pruitt, Byron S wrote:
> > What is the best to set properties like auto commit.  The DataSource 
> > interface doesn't expose anything.  The only thing I can find that supports 
> > these properties is BasicDataSource.
> 
> This depends on your application, but it's good to start with the
> defaults, which as of DBCP 2.x are the defaults set by the database
> driver.  You can change the default connection properties by
> specifying them in the BasicDataSource config or by setting them on
> the PoolableConnectionFactory if you are manually creating the
> PoolingDataSource.
> 
> Phil
> >
> > Thanks in advance.
> >
> >
> > Steve Pruitt
> >
> > -
> > To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> > For additional commands, e-mail: user-h...@commons.apache.org
> >
> >
> 
> 
> 
> -
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
>

[dbcp] setting connection defaults

2015-09-03 Thread Pruitt, Byron S 
What is the best to set properties like auto commit.  The DataSource interface 
doesn't expose anything.  The only thing I can find that supports these 
properties is BasicDataSource.

Thanks in advance.


Steve Pruitt

-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org

Re: [dbcp] setting connection defaults

2015-09-03 Thread Phil Steitz 
On 9/3/15 12:26 PM, Pruitt, Byron S wrote:
> What is the best to set properties like auto commit.  The DataSource 
> interface doesn't expose anything.  The only thing I can find that supports 
> these properties is BasicDataSource.

This depends on your application, but it's good to start with the
defaults, which as of DBCP 2.x are the defaults set by the database
driver.  You can change the default connection properties by
specifying them in the BasicDataSource config or by setting them on
the PoolableConnectionFactory if you are manually creating the
PoolingDataSource.

Phil
>
> Thanks in advance.
>
>
> Steve Pruitt
>
> -
> To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
> For additional commands, e-mail: user-h...@commons.apache.org
>
>



-
To unsubscribe, e-mail: user-unsubscr...@commons.apache.org
For additional commands, e-mail: user-h...@commons.apache.org