Mailing-List: contact users-help@tomcat.apache.org; run by ezmlm
Precedence: bulk
Reply-To: "Tomcat Users List" <users@tomcat.apache.org>
Received-SPF: pass (athena.apache.org: domain of anuprab2@gmail.com designates
 209.85.219.66 as permitted sender)
MIME-Version: 1.0
In-Reply-To: <1427F4AE-94FD-41FF-9FE1-348D7154E866@gopivotal.com>
References: 
 <CAF0CH4vgtNhTD2-4QtPE0T-aoA_=v-xeATRZLWJbcmSDYWvarQ@mail.gmail.com>
	<CEBD045F-1B52-4A99-B6AA-249088EC79E2@gopivotal.com>
	<5244AF04.30809@christopherschultz.net>
	<1427F4AE-94FD-41FF-9FE1-348D7154E866@gopivotal.com>
Date: Fri, 27 Sep 2013 09:44:09 +0530
Message-ID: 
 <CAF0CH4uy+oG1T75g72ASTYtqZGYYLBmh42H0VLixczA=nCRDTw@mail.gmail.com>
Subject: Re: Reg: Connection pool
From: Anu Prab <anuprab2@gmail.com>
To: Tomcat Users List <users@tomcat.apache.org>
Content-Type: multipart/alternative; boundary=089e013cbdc4da5a9e04e755b7ea

--089e013cbdc4da5a9e04e755b7ea
Content-Type: text/plain; charset=ISO-8859-1

On Sep 26, 2013, at 6:02 PM, Christopher Schultz <
chris@christopherschultz.net> wrote:

> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA256
>
> Daniel,
>
> On 9/26/13 9:18 AM, Daniel Mikusa wrote:
>> On Sep 26, 2013, at 2:22 AM, Anu Prab <anuprab2@gmail.com> wrote:
>>
>>> I am using Tomcat version 7.
>>
>> For future reference, please include the exact version of Tomcat
>> you are running.  There are 40+ different versions.
>>
>>> Is it possible to update connection pool properties without
>>> restarting the Tomcat server?
>>
>> Please also include specific details like which connection pool
>> are you using.  There are two included with Tomcat, DBCP and
>> tomcat-jdbc.
>>
>> To give a general answer to your question, you can update some of
>> the properties through JMX.  It'll depend on the version of Tomcat
>> and which pool you are using as to which properties you can update.
>> Try connecting with jconsole or jvisualvm w/MBeans plugin and see
>> if the properties you need are exposed and editable.
>
> While most properties are not immutable (e.g. you can change their
> values via JMX), changing them usually has no effect because the
> connection pool is not re-initialized when those values change.

Good point.  It's important to be realistic about what you can do at
runtime.

> Perhaps Anu can give us a use case for when this kind of thing would
> be appropriate... what would you want to change during runtime in a
> stable system?

+1 definitely need more info here.

Dan


Hi,

The Tomcat version I am using is 7.0.40 and the connection pool is
tomcat-jdbc.

Well, one case would be to increase the maxActive property.

-Anu


On Fri, Sep 27, 2013 at 7:48 AM, Daniel Mikusa <dmikusa@gopivotal.com>wrote:

> On Sep 26, 2013, at 6:02 PM, Christopher Schultz <
> chris@christopherschultz.net> wrote:
>
> > -----BEGIN PGP SIGNED MESSAGE-----
> > Hash: SHA256
> >
> > Daniel,
> >
> > On 9/26/13 9:18 AM, Daniel Mikusa wrote:
> >> On Sep 26, 2013, at 2:22 AM, Anu Prab <anuprab2@gmail.com> wrote:
> >>
> >>> I am using Tomcat version 7.
> >>
> >> For future reference, please include the exact version of Tomcat
> >> you are running.  There are 40+ different versions.
> >>
> >>> Is it possible to update connection pool properties without
> >>> restarting the Tomcat server?
> >>
> >> Please also include specific details like which connection pool
> >> are you using.  There are two included with Tomcat, DBCP and
> >> tomcat-jdbc.
> >>
> >> To give a general answer to your question, you can update some of
> >> the properties through JMX.  It'll depend on the version of Tomcat
> >> and which pool you are using as to which properties you can update.
> >> Try connecting with jconsole or jvisualvm w/MBeans plugin and see
> >> if the properties you need are exposed and editable.
> >
> > While most properties are not immutable (e.g. you can change their
> > values via JMX), changing them usually has no effect because the
> > connection pool is not re-initialized when those values change.
>
> Good point.  It's important to be realistic about what you can do at
> runtime.
>
> > Perhaps Anu can give us a use case for when this kind of thing would
> > be appropriate... what would you want to change during runtime in a
> > stable system?
>
> +1 definitely need more info here.
>
> Dan
>
> >
> > - -chris
> > -----BEGIN PGP SIGNATURE-----
> > Version: GnuPG v1.4.14 (Darwin)
> > Comment: GPGTools - http://gpgtools.org
> > Comment: Using GnuPG with Thunderbird - http://www.enigmail.net/
> >
> > iQIcBAEBCAAGBQJSRK8EAAoJEBzwKT+lPKRYkMEP/A04GloLJdT4u/Jlgh13Svw+
> > jFhmRHwxHP93bTtglyr0CQ98YW4VqW/LwiYJLP7hZLW1yKr9Fd9WJi+jiW6qni6A
> > dQUo4jCVn5AChkjvUKSwMPi2AHrJ79SrGdyAivyW8LpqCK28Q50bDFc8bZU4rms4
> > UumIQ6dNashLDj2PDQhdtaCO5PD+aw269kPI6tQtpwEwe/+cW1kNCcfG7HO/8eav
> > /xmGwMZNwwhrhV6mWIB9KojR2sQghOh68QHFO9VXUCe3UgY7nQmN6D3iEWRM5Bo2
> > WFKMQF3mTpsnBOM9NN6hd4SBuDK6XqUGz/7KQ4ucfl+Y6vMl4NTwGFQy+A+tDamh
> > Py+j5XxTxUIj+bxjfDySKy7qqUz97RuYSVSzmlI5la9p+uPQZpz7xPSCkuaQ7xIr
> > ihLKg1dGsUz7XfdIHVOlKmFxovkuifu/6GM0yw320Jmp/GUaEfiYbcz6xoxLZob0
> > RljlwowyYelnv92OHYZp9vSfYkyi+BznVd6YV0/yPdCm2E3kgNVJlkgAERST4nBB
> > gYkBaciEJvsdPS67TjoR5DFNPqGbWcNKD2qL4T8J67OciP6cZjiWpE7Tmee1xb6J
> > eIiolTiKBxCgq7qKx8GubDk/9gcQ9AsvwVL9mux6x1zNN3vZOawTZucxdIUL3ziQ
> > oLpb46SghgIqevBDYmFd
> > =/0XG
> > -----END PGP SIGNATURE-----
> >
> > ---------------------------------------------------------------------
> > To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> > For additional commands, e-mail: users-help@tomcat.apache.org
> >
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
> For additional commands, e-mail: users-help@tomcat.apache.org
>
>

--089e013cbdc4da5a9e04e755b7ea--