You are viewing a plain text version of this content. The canonical link for it is here.
Posted to users@tomcat.apache.org by "John Dale (DB2DOM)" <jc...@gmail.com> on 2023/04/10 04:40:34 UTC
Database connection pooling ..
Has anyone tried using the Tomcat 10 DBCP from a standalone java app?
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
Re: Database connection pooling ..
Posted by "John Dale (DB2DOM)" <jc...@gmail.com>.
Good info here.
Commons IS very busy, aren't they.
Lots of good tools in there ..
John
On 4/11/23, Christopher Schultz <ch...@christopherschultz.net> wrote:
> Bruno,
>
> On 4/11/23 12:51, BRUNO MELLONI wrote:
>> I used org.apache.commons.dbcp2.BasicDataSource as my default
>> DataSource for over a decade in both Tomcat and standalone apps.
>> Very reliable.
> Note that you are talking about commons-dbcp2 and John was asking about
> tomcat-pool (which is a different product).
>
> Tomcat uses commons-dbcp2 by default, but can be configured to use its
> own tomcat-pool as well.
>
> IMHO I would prefer commons-dbcp2 over tomcat-pool just because it has
> such a huge user-base in comparison, and it's got a dedicated team
> working on it. tomcat-pool doesn't get much attention around here...
> it's just kind of "done".
>
> -chris
>
> ---------------------------------------------------------------------
> 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
Re: Database connection pooling ..
Posted by Christopher Schultz <ch...@christopherschultz.net>.
Bruno,
On 4/11/23 12:51, BRUNO MELLONI wrote:
> I used org.apache.commons.dbcp2.BasicDataSource as my default
> DataSource for over a decade in both Tomcat and standalone apps.
> Very reliable.
Note that you are talking about commons-dbcp2 and John was asking about
tomcat-pool (which is a different product).
Tomcat uses commons-dbcp2 by default, but can be configured to use its
own tomcat-pool as well.
IMHO I would prefer commons-dbcp2 over tomcat-pool just because it has
such a huge user-base in comparison, and it's got a dedicated team
working on it. tomcat-pool doesn't get much attention around here...
it's just kind of "done".
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org
RE: Database connection pooling ..
Posted by BRUNO MELLONI <Br...@chickasaw.net>.
I used org.apache.commons.dbcp2.BasicDataSource as my default DataSource for over a decade in both Tomcat and standalone apps. Very reliable. I do remember that “permanently running” apps like a custom job scheduler that we run would occasionally require a restart, sometimes once a week or once a month, although that eventually went away without any code changes so it was probably unrelated to DBCP. Now we only have to restart if the app relies on Java’s default caching of DNS names to IPs and there is a server IP change, but I understand that there is code we can use to force Java to re-resolve DNS names to IP every “x amount of time”.
From: Christopher Schultz <ch...@christopherschultz.net>
Sent: Tuesday, April 11, 2023 10:30 AM
To: users@tomcat.apache.org
Subject: Re: Database connection pooling ..
John, On 4/10/23 00: 40, John Dale (DB2DOM) wrote: > Has anyone tried using the Tomcat 10 DBCP from a standalone java app? I have not, but there isn't really anything Tomcat-specific about it. -chris ---------------------------------------------------------------------
ZjQcmQRYFpfptBannerStart
CAUTION: This Message Is From an External Source
This message originated outside the Chickasaw Nation. Do not click links or open attachments unless you recognize the sender and know the content is safe!
Report Suspicious <https://us-phishalarm-ewt.proofpoint.com/EWT/v1/IMeFMrRG1GeY!JFtUdprQfAHa4kOtKmfNtprnTq19zR0uNP4ME3tW_Zo5fAQfVuccR8Y-fz-aL6AcGqOIQad5Hjfhr2PIuNaKiRQYZ369nYv1PGBmBNx8YmxEnZSXiPCxCPdw$>
ZjQcmQRYFpfptBannerEnd
John,
On 4/10/23 00:40, John Dale (DB2DOM) wrote:
> Has anyone tried using the Tomcat 10 DBCP from a standalone java app?
I have not, but there isn't really anything Tomcat-specific about it.
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org<ma...@tomcat.apache.org>
For additional commands, e-mail: users-help@tomcat.apache.org<ma...@tomcat.apache.org>
Re: Database connection pooling ..
Posted by Christopher Schultz <ch...@christopherschultz.net>.
John,
On 4/10/23 00:40, John Dale (DB2DOM) wrote:
> Has anyone tried using the Tomcat 10 DBCP from a standalone java app?
I have not, but there isn't really anything Tomcat-specific about it.
-chris
---------------------------------------------------------------------
To unsubscribe, e-mail: users-unsubscribe@tomcat.apache.org
For additional commands, e-mail: users-help@tomcat.apache.org