Re: JDBC connection pooling maxActive or MaxTotal

2020-01-08 Thread Zahid Rahman
Hey Dave B. , My question from chris was for your benefit. default configuration is not the same thing as vendor neutral. chris wrote: > If you use both, you should be all set for whichever pool you use at runtime. DOH ! >If you look in your log file, you will notice that when Tomcat starts

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-05 Thread Guang Chao
On Sat, Jan 4, 2020 at 2:47 AM Dave Bothwell wrote: > Hello, > > I am using Tomcat 8.5.11 with JDBC connection pooling. Based on the > documentation it is clear that DBCP pooling has changed the maxActive > attribute to maxTotal. However it is unclear, based on this document >

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
chris, Is commons-dbcp-2.x   a Database pooling component for any container Jetty,Jboss tomcat   etc. ? is commons-dbcp-2.x a third option, separate option from the two pooling options [tomcat-pool and commons-pool] you mentioned ? On 03/01/2020 23:21, Dave Bothwell wrote: Chris, That

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread Dave Bothwell
Chris, That was very helpful. Thank you Dave On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Dave, > > On 1/3/20 13:47, Dave Bothwell wrote: > > I am using Tomcat 8.5.11 with JDBC connection

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Dave, On 1/3/20 13:47, Dave Bothwell wrote: > I am using Tomcat 8.5.11 with JDBC connection pooling. Based on > the documentation it is clear that DBCP pooling has changed the > maxActive attribute to maxTotal. However it is unclear, based on >

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
|I hope these descriptions of the setting helps you in making a decision as to the value. | |maxActive| (int) The maximum number of active connections that can be allocated from this pool at the same time. The default value is |100||| | | On 03/01/2020 18:47, Dave Bothwell wrote: Hello,

Re: JDBC Connection pooling

2016-01-26 Thread Felix Schumacher
Am 22.01.2016 um 12:35 schrieb R. Sriram: Hello I am trying to establish connection pooling. Should I be using dbcp? If you want to use db connection pooling, it is probably a good idea to use the pooling method the container gives you, as it will be used by a lot of people and therefore has

Re: jdbc connection pooling

2008-01-04 Thread Diego
I'm using the connection pooling on Tomcat 6. And in my case i had to put the jar from the jdbc driver on. $CATALINA_HOME/lib On Jan 4, 2008 2:05 PM, Scott McClanahan [EMAIL PROTECTED] wrote: We are about to start testing the jdbc connection pooling capabilities within tomcat. I don't have

Re: jdbc connection pooling

2008-01-04 Thread David Smith
As you've described it using tomcat's JNDI resources, the driver has to be in common/lib. If the application defines and manages it's own pool separate from tomcat, then you could put it in the app's WEB-INF/lib folder. This has everything to do with how the classloaders work. Since tomcat

RE: jdbc connection pooling

2008-01-04 Thread Caldarale, Charles R
From: Scott McClanahan [mailto:[EMAIL PROTECTED] Subject: jdbc connection pooling The developer says that the jar file containing the database driver should be published within the web applications WEB-INF/lib folder while I say it should be in $CATALINA_HOME/common/lib. You are

RE: jdbc connection pooling

2008-01-04 Thread Scott McClanahan
On Fri, 2008-01-04 at 10:23 -0600, Caldarale, Charles R wrote: From: Scott McClanahan [mailto:[EMAIL PROTECTED] Subject: jdbc connection pooling The developer says that the jar file containing the database driver should be published within the web applications WEB-INF/lib folder

Re: jdbc connection pooling

2008-01-04 Thread Scott McClanahan
On Fri, 2008-01-04 at 14:12 -0200, Diego wrote: I'm using the connection pooling on Tomcat 6. And in my case i had to put the jar from the jdbc driver on. $CATALINA_HOME/lib On Jan 4, 2008 2:05 PM, Scott McClanahan [EMAIL PROTECTED] wrote: We are about to start testing the jdbc

RE: jdbc connection pooling

2008-01-04 Thread Caldarale, Charles R
From: Scott McClanahan [mailto:[EMAIL PROTECTED] Subject: RE: jdbc connection pooling I'm going to try my best to not sound ignorant but can you better explain what you mean when you say tomcat manages the connections compared to if the application (using the same apache commons projects

RE: jdbc connection pooling

2008-01-04 Thread Scott McClanahan
On Fri, 2008-01-04 at 11:16 -0600, Caldarale, Charles R wrote: From: Scott McClanahan [mailto:[EMAIL PROTECTED] Subject: RE: jdbc connection pooling I'm going to try my best to not sound ignorant but can you better explain what you mean when you say tomcat manages the connections

RE: jdbc connection pooling

2008-01-04 Thread Propes, Barry L
NOT in the WEB-INF/lib -- put in the common/lib - that's where it goes. You might get very erratic performance putting the jar file in both places. make sure you know how to configure either your server.xml file or respective META-INF/ .xml file appropriately. Depends on which TC version you

Re: JDBC connection pooling problem

2006-05-02 Thread Marc Farrow
This sounds like poor coding to me. Your application should get the connection object from the pool and immediately release when done. Having an application hold onto a connection (especially in client/server) world is bound to cause you to run out of connections or reach timeouts. On 5/2/06,

Re: JDBC connection pooling problem

2006-05-02 Thread Michal Fleischhans
You're absolutelly right Marc, but the connection is being described by the connection context containing the username and the password. Each application has its own DB account, so as you have written bellow, the application gives the connection back to the pool BUT only the same