RE: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Daniel Schwartz
g wrong with these files? Dan -Original Message- From: Christopher Schultz Sent: Wednesday, June 19, 2024 5:10 PM To: users@tomcat.apache.org Subject: Re: Tomcat MySQL Connection Pooling JNDI lookup Daniel, On 6/19/24 16:37, Daniel Schwartz wrote: > I followed you instruction to mo

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Christopher Schultz
years ago, and it had a nice interface for setting up database connection pooling. You just had to input some parameters and it automatically generated all the necessary files in the appropriate directories. That system would not work with any version of Java later than 1.8. Then they upgrader

RE: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Daniel Schwartz
will change this when/if the system goes into production. In the meantime, however, I have explored the current version of Glassfish. I had been using Glassfish 4.1 years ago, and it had a nice interface for setting up database connection pooling. You just had to input some parameters and it

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Terence M. Bandoian
On 6/19/2024 1:02 PM, Chuck Caldarale wrote: On Jun 19, 2024, at 10:09, Daniel Schwartz wrote: Dear Thomas, Your email came with no content. Please try again. Thomas’ message looked fine here as well. Check your e-mail client. - Chuck I saw the quoted message Mark was responding to bu

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Chuck Caldarale
> On Jun 19, 2024, at 10:09, Daniel Schwartz wrote: > > Dear Thomas, > > Your email came with no content. Please try again. Thomas’ message looked fine here as well. Check your e-mail client. - Chuck - To unsubscribe,

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Christopher Schultz
Daniel, On 6/19/24 11:40, Daniel Schwartz wrote: Dear Felix, Thank you for your reply. The connector jar file is at C:\Program Files\apache-tomcat-10.1.24\lib\mysql-connector-j-8.4.0.jar The latest entry in catalina.2024-06-17.log is copied below. The latest entry in localhost.2024-06-

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Christopher Schultz
Daniel, On 6/19/24 11:09, Daniel Schwartz wrote: Dear Thomas, Your email came with no content. Please try again. His reply email looks fine to me. -chris - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org

RE: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Daniel Schwartz
) at org.apache.tomcat.util.threads.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:659) at org.apache.tomcat.util.threads.TaskThread$WrappingRunnable.run(TaskThread.java:63) at java.base/java.lang.Thread.run(Thread.java:1583) -Original Message- From: Felix Schumac

RE: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-19 Thread Daniel Schwartz
Dear Thomas, Your email came with no content. Please try again. Dan Schwartz From: Thomas Hoffmann (Speed4Trade GmbH) Sent: Wednesday, June 19, 2024 2:05 AM To: Tomcat Users List Subject: AW: Tomcat MySQL Connection Pooling JNDI lookup

AW: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-18 Thread Thomas Hoffmann (Speed4Trade GmbH)
Hello Daniel, > Am 17. Juni 2024 22:18:53 MESZ schrieb Daniel Schwartz > : > >Hello, > > > > > > > >I'm trying to set up MySQL 8.0.11 database connection pooling in Tomcat > >10.1.24 on Windows 10. The MySQL database is "holidays" with

Re: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-18 Thread Felix Schumacher
Am 17. Juni 2024 22:18:53 MESZ schrieb Daniel Schwartz : >Hello, > > > >I'm trying to set up MySQL 8.0.11 database connection pooling in Tomcat >10.1.24 on Windows 10. The MySQL database is "holidays" with user name >"root" and password "ro

FW: Tomcat MySQL Connection Pooling JNDI lookup

2024-06-18 Thread Daniel Schwartz
users@tomcat.apache.org Subject: Tomcat MySQL Connection Pooling JNDI lookup Hello, I'm trying to set up MySQL 8.0.11 database connection pooling in Tomcat 10.1.24 on Windows 10. The MySQL database is "holidays" with user name "root" and password "rootpwd". I&

Tomcat MySQL Connection Pooling JNDI lookup

2024-06-17 Thread Daniel Schwartz
Hello, I'm trying to set up MySQL 8.0.11 database connection pooling in Tomcat 10.1.24 on Windows 10. The MySQL database is "holidays" with user name "root" and password "rootpwd". I've tried to follow the examples at https://tomcat.apache.org

Re: Database connection pooling ..

2023-04-11 Thread John Dale (DB2DOM)
Good info here. Commons IS very busy, aren't they. Lots of good tools in there .. John On 4/11/23, Christopher Schultz 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

Re: Database connection pooling ..

2023-04-11 Thread Christopher Schultz
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 p

RE: Database connection pooling ..

2023-04-11 Thread BRUNO MELLONI
to re-resolve DNS names to IP every “x amount of time”. From: Christopher Schultz 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 fro

Re: Database connection pooling ..

2023-04-11 Thread Christopher Schultz
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: u

Database connection pooling ..

2023-04-09 Thread John Dale (DB2DOM)
Has anyone tried using the Tomcat 10 DBCP from a standalone java app? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-27 Thread Christopher Schultz
JK, On 11/25/21 04:23, jkla...@iki.fi wrote: On Wednesday, Nov 24, 2021 at 7:37 PM, Christopher Schultz mailto:ch...@christopherschultz.net)> wrote: (on the significance of DBCP overall) It's essentially "failing faster" or, IMO, "failing safer." All right, I think I see it now. A very good

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-25 Thread jkla...@iki.fi
> On Wednesday, Nov 24, 2021 at 7:37 PM, Christopher Schultz > mailto:ch...@christopherschultz.net)> wrote: > (on the significance of DBCP overall) > It's essentially "failing faster" or, IMO, "failing safer." All right, I think I see it now. A very good explanation, thank you. > If I were you,

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-24 Thread Christopher Schultz
JK, On 11/24/21 08:03, jkla...@iki.fi wrote: On Tuesday, Nov 23, 2021 at 4:20 PM, Christopher Schultz mailto:ch...@christopherschultz.net)> wrote: ProxySQL is, mostly, a load-balancing and caching product. Sure, it can provide connection-pooling, but that doesn't mean that you w

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-24 Thread jkla...@iki.fi
> On Tuesday, Nov 23, 2021 at 4:20 PM, Christopher Schultz > mailto:ch...@christopherschultz.net)> wrote: > > ProxySQL is, mostly, a load-balancing and caching product. Sure, it can > provide connection-pooling, but that doesn't mean that you want your > applicatio

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread Mark Thomas
er and for separating read and write traffic to different database instances. After this, we have no need for DBCP or any other Java-level pooling – in fact, having two levels of connection pooling would probably be detrimental to performance, and certainly to our ability to diagnose issues. T

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread Christopher Schultz
recent for your platform. We're in the process of adopting ProxySQL in front of MySQL, to act as the connection pooler and for separating read and write traffic to different database instances. After this, we have no need for DBCP or any other Java-level pooling – in fact, having two levels of con

Re: [OT] Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread Mark Thomas
On 23/11/2021 13:51, Richardson, Diane wrote: I get the emails but how can I send an email for assistance? Please don't hijack threads. See http://tomcat.apache.org/lists.html#taglibs-user Specifically, "Posting questions to the list" Mark ---

Re: [External] Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread Richardson, Diane
I get the emails but how can I send an email for assistance? From: jkla...@iki.fi Sent: Tuesday, November 23, 2021 8:23:50 AM To: users@tomcat.apache.org Subject: [External] Handling database connection pooling outside Java, without DBCP et al? This message

Re: Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread Olaf Kock
write traffic to different > database instances. After this, we have no need for DBCP or any other > Java-level pooling – in fact, having two levels of connection pooling would > probably be detrimental to performance, and certainly to our ability to > diagnose issues. The keyword

Handling database connection pooling outside Java, without DBCP et al?

2021-11-23 Thread jkla...@iki.fi
ase instances. After this, we have no need for DBCP or any other Java-level pooling – in fact, having two levels of connection pooling would probably be detrimental to performance, and certainly to our ability to diagnose issues. Trouble is, based on my reading of the JNDI Resources HOW-TO, the Ja

Re: Details of connection pooling

2020-11-20 Thread Phil Steitz
On 11/20/20 10:25 AM, Rob Sargent wrote: I'm using tomcat 9.0.+ and wish to use the built in connection pooling to connect to a postgres server. I would like to understand the lookup mechanism for the next available connection. I create a context    contextResource.setName("

Details of connection pooling

2020-11-20 Thread Rob Sargent
I'm using tomcat 9.0.+ and wish to use the built in connection pooling to connect to a postgres server. I would like to understand the lookup mechanism for the next available connection. I create a context contextResource.setName("jdbc/sgsdb"); contextR

Re: Question regarding servlet lifecycle and connection pooling ..

2020-08-02 Thread Mark Thomas
On July 25, 2020 3:25:18 PM UTC, John Dale wrote: >Greetings; > >We've wrapped my connection pool interface in a Factory. Can you >confirm how the current request's thread is used by JDBC connection >pooling to MyS

Re: Question regarding servlet lifecycle and connection pooling ..

2020-07-27 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 John, On 7/25/20 11:25, John Dale wrote: > We've wrapped my connection pool interface in a Factory. Can you > confirm how the current request's thread is used by JDBC > connection pooling to MySQL? Are you using Tomcat to man

Question regarding servlet lifecycle and connection pooling ..

2020-07-25 Thread John Dale
Greetings; We've wrapped my connection pool interface in a Factory. Can you confirm how the current request's thread is used by JDBC connection pooling to MySQL? Sincerely, John - To unsubscribe, e-mail: user

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-08 Thread Zahid Rahman
> > > 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 Both

Re: [OT] JDBC connection pooling maxActive or MaxTotal

2020-01-06 Thread Christopher Schultz
hat was very helpful. >> >> Thank you Dave >> >> >> >> On Fri, Jan 3, 2020 at 5:29 PM Christopher Schultz < >> ch...@christopherschultz.net> wrote: >> > Dave, > > On 1/3/20 13:47, Dave Bothwell wrote: >>>>> I am using Tomcat

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 d

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
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 pooling. Based

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 Tomc

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,

Re: JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread zahid
, 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 https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html, if JDBC pooling has also changed

JDBC connection pooling maxActive or MaxTotal

2020-01-03 Thread Dave Bothwell
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 https://tomcat.apache.org/tomcat-8.5-doc/jdbc-pool.html, if JDBC pooling has also

Re: Tomcat 8 Connection Pooling

2017-07-18 Thread Riccardo Cohen
he Tomcat 8.5.15 "Tomcat JDBC Connection Pool" using the steps mentioned in the guide. Can some one help me to understand how this connection pooling has to be done. Is the Plain Java Method,by implementing Pool Properties is an alternative to the JNDI lookup based pooling ? When

Re: Tomcat 8 Connection Pooling

2017-07-18 Thread Avinash Krishnan
gt; >>> javax.sql.DataSource >>> >>> >>> >>> and in a java class add this : >>> >>> public class T3Servlet extends HttpServlet >>> { >>> @Resource(name="jdbc/tomcattest") >>> p

Re: Tomcat 8 Connection Pooling

2017-07-18 Thread Riccardo Cohen
onnection Pool" using the steps mentioned in the guide. Can some one help me to understand how this connection pooling has to be done. Is the Plain Java Method,by implementing Pool Properties is an alternative to the JNDI lookup based pooling ? When I implement using Pool Properties, there isn

Re: Tomcat 8 Connection Pooling

2017-07-18 Thread Avinash Krishnan
/tomcattest") > public DataSource ds; > > > You will normally have a data source in your class, by injection, using > tomcat database pool. > > > On 18/07/2017 12:26, Avinash Krishnan wrote: > >> I am trying to implement Apache Tomcat 8.5.15 "Tomcat JD

Re: Tomcat 8 Connection Pooling

2017-07-18 Thread Riccardo Cohen
nnection Pool" using the steps mentioned in the guide. Can some one help me to understand how this connection pooling has to be done. Is the Plain Java Method,by implementing Pool Properties is an alternative to the JNDI lookup based pooling ? When I implement using Pool Properties, there isn&

Tomcat 8 Connection Pooling

2017-07-18 Thread Avinash Krishnan
I am trying to implement Apache Tomcat 8.5.15 "Tomcat JDBC Connection Pool" using the steps mentioned in the guide. Can some one help me to understand how this connection pooling has to be done. Is the Plain Java Method,by implementing Pool Properties is an alternative to the JNDI lo

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

JDBC Connection pooling

2016-01-22 Thread R. Sriram
Hello I am trying to establish connection pooling. Should I be using dbcp? - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org For additional commands, e-mail: users-h...@tomcat.apache.org

Re: Tomcat 8 DB Connection Pooling

2015-06-15 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Douglas, On 6/12/15 8:13 PM, Douglas Schaible wrote: > Hi Chris, > > I have the connection pool defined in /etc/tomcat8/context.xml. Is > that the wrong place the define it? Most likely. That file (if I'm guessing correctly about your package man

Re: Tomcat 8 DB Connection Pooling

2015-06-12 Thread Douglas Schaible
Hi Chris, I have the connection pool defined in /etc/tomcat8/context.xml. Is that the wrong place the define it? Is what is defined there being copied into each application? I underplayed some sample application and I am now seeing 10 time the number of apps being deployed DB connections.

Re: Tomcat 8 DB Connection Pooling

2015-06-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Douglas, In addition to what Filip posted... On 6/11/15 12:18 PM, Douglas Schaible wrote: > Good Day All, > > I am having a problem with a connection pool and I was hoping for > some guidance. > > I have defined the connection pool below for two

Re: Tomcat 8 DB Connection Pooling

2015-06-11 Thread Filip Hanik
Configuration reference: https://tomcat.apache.org/tomcat-7.0-doc/jdbc-pool.html On Thu, Jun 11, 2015 at 6:58 PM, Filip Hanik wrote: > set the properties > > logAbandoned="true" > removeAbandoned="true" > removeAbandonedTimeout="60" (value is in seconds, should be larger than > your longest runn

Re: Tomcat 8 DB Connection Pooling

2015-06-11 Thread Filip Hanik
set the properties logAbandoned="true" removeAbandoned="true" removeAbandonedTimeout="60" (value is in seconds, should be larger than your longest running transaction) timeBetweenEvictionRunsMillis="15000" (value is in milliseconds) if you have a leak (meaning your code is not returning the conne

Tomcat 8 DB Connection Pooling

2015-06-11 Thread Douglas Schaible
Good Day All, I am having a problem with a connection pool and I was hoping for some guidance. I have defined the connection pool below for two deployed applications to use. When I bounce the server I can see that it immediately crates 100 connections to the DB. (I am ok with this, but that i

Tomat: 8.0.9 Question related to MySql Connection Pooling

2014-08-03 Thread Richeek Arya
Hey guys, First of all my bad to asking the question on main page here, I did not go through the guidelines section. Here is my query: I want to retry MySql queries in cases of deadlock which will be removed if I can simply retry. I use apache tomcat jdbc pool library for mysql connection

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Saurabh Saraswat
Chris, Thanks for your regular guidance and valuable suggestions! On Fri, Apr 11, 2014 at 11:33 AM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Daniel, > > On 4/8/14, 6:36 AM, Daniel Mikusa wrote: > > On Apr 8, 2014, at 8:22

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Daniel, On 4/8/14, 6:36 AM, Daniel Mikusa wrote: > On Apr 8, 2014, at 8:22 AM, Saurabh Saraswat > wrote: > >> Dear Dan, >> >> Thanks for taking time to respond me. >> >> My updated Resource Tag is - >> >> > type="javax.sql.DataSource" maxActive

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Saurabh, On 4/8/14, 6:22 AM, Saurabh Saraswat wrote: > Thanks for taking time to respond me. > > My updated Resource Tag is - > > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="1" That's a lot of connections. Are you sur

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Daniel Mikusa
On Apr 8, 2014, at 8:22 AM, Saurabh Saraswat wrote: > Dear Dan, > > Thanks for taking time to respond me. > > My updated Resource Tag is - > >maxActive="100" maxIdle=“30" As Chris mentioned, set maxActive 1 in your dev environment. That will help you find the problem more qu

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Saurabh Saraswat
Dear Dan, Thanks for taking time to respond me. My updated Resource Tag is - I have also cross checked my code. I am closing the connection properly in finally block. Also have set the max_connection=250 in etc/my.cnf for MySql. Even now i am not getting any Exception but my Application gets

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Daniel Mikusa
On Apr 8, 2014, at 5:46 AM, Saurabh Saraswat wrote: > On Fri, Apr 4, 2014 at 8:39 PM, Christopher Schultz < > ch...@christopherschultz.net> wrote: > >> -BEGIN PGP SIGNED MESSAGE- >> Hash: SHA256 >> >> Daniel, >> >> On 4/4/14, 8:57 AM, Daniel Mikusa wrote: >>> On Apr 4, 2014, at 8:22 AM

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-08 Thread Saurabh Saraswat
On Fri, Apr 4, 2014 at 8:39 PM, Christopher Schultz < ch...@christopherschultz.net> wrote: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA256 > > Daniel, > > On 4/4/14, 8:57 AM, Daniel Mikusa wrote: > > On Apr 4, 2014, at 8:22 AM, Saurabh Saraswat > > wrote: > > > >> Dear Dan, > >> > >> Thanks f

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Daniel, On 4/4/14, 8:57 AM, Daniel Mikusa wrote: > On Apr 4, 2014, at 8:22 AM, Saurabh Saraswat > wrote: > >> Dear Dan, >> >> Thanks for your response! >> >> I have cross checked the user / password configuration. All is >> correct. > > If you’

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Saurabh, On 4/4/14, 1:19 AM, Saurabh Saraswat wrote: > I am doing connection pooling with tomcat 7.0.39 and MySQL > 5.5.After searching on google and with your help i have done the > below things. Even i am able to get the connection suc

RE: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Propes, Barry L
-Original Message- From: Saurabh Saraswat [mailto:ssaras...@pivotalindia.com] Sent: Friday, April 04, 2014 7:23 AM To: Tomcat Users List Subject: Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39 Dear Dan, Thanks for your response! I have cross checked the user

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Daniel Mikusa
a wrote: > >> On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat >> wrote: >> >>> Dear All, >>> >>> I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After >>> searching on google and with your help i have done the below things. >>

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread David kerber
you run out of connections before you get any of them back. *Best Regards,* *Saurabh Sarasvat* On Fri, Apr 4, 2014 at 5:16 PM, Daniel Mikusa wrote: On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat wrote: Dear All, I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.Aft

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Saurabh Saraswat
blem. Can you please let me know what others reason can cause this exception. *Best Regards,* *Saurabh Sarasvat* On Fri, Apr 4, 2014 at 5:16 PM, Daniel Mikusa wrote: > On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat > wrote: > > > Dear All, > > > > I am doing

Re: SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-04 Thread Daniel Mikusa
On Apr 4, 2014, at 1:19 AM, Saurabh Saraswat wrote: > Dear All, > > I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After > searching on google and with your help i have done the below things. > Even i am able to get the connection successfully using this but

SQLNestedException in Connection Pooling With Tomcat 7.0.39

2014-04-03 Thread Saurabh Saraswat
Dear All, I am doing connection pooling with tomcat 7.0.39 and MySQL 5.5.After searching on google and with your help i have done the below things. Even i am able to get the connection successfully using this but getting some trouble and exception. I am explaining you all steps done by me- *1

Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Saurabh Saraswat
. *Best Regards,* *Saurabh Sarasvat* On Mon, Mar 31, 2014 at 6:50 PM, Daniel Mikusa wrote: > On Mar 31, 2014, at 7:05 AM, Saurabh Saraswat > wrote: > > > Dear All, > > > > I am doing connection pooling with tomcat 6. And i am doing this very > first >

Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Saurabh, On 3/31/14, 7:05 AM, Saurabh Saraswat wrote: > I am doing connection pooling with tomcat 6. And i am doing this > very first time before today i had no idea about connection > pooling. I want to ensure that it is the correct w

Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Daniel Mikusa
On Mar 31, 2014, at 7:05 AM, Saurabh Saraswat wrote: > Dear All, > > I am doing connection pooling with tomcat 6. And i am doing this very first > time before today i had no idea about connection pooling. I want to ensure > that it is the correct way or not. > Please do

Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Saurabh Saraswat
Dear All, I am doing connection pooling with tomcat 6. And i am doing this very first time before today i had no idea about connection pooling. I want to ensure that it is the correct way or not. Please do me correct if i am doing wrong anywhere. I am explaining you all steps done by me- *1

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Leo Donahue
On Fri, Mar 28, 2014 at 12:31 PM, Propes, Barry L wrote: > > > -Original Message- > From: Mark Shifman [mailto:mark.shif...@yale.edu] > Sent: Friday, March 28, 2014 12:34 PM > To: Tomcat Users List > Subject: Re: Connection pooling issue on Tomcat > > ===

RE: Connection pooling issue on Tomcat

2014-03-28 Thread Propes, Barry L
-Original Message- From: Mark Shifman [mailto:mark.shif...@yale.edu] Sent: Friday, March 28, 2014 12:34 PM To: Tomcat Users List Subject: Re: Connection pooling issue on Tomcat On 03/28/2014 11:58 AM, Propes, Barry L wrote: > Hi folks, > > I'm using Tomcat 6.0.29 for a

RE: Connection pooling issue on Tomcat

2014-03-28 Thread Propes, Barry L
-Original Message- From: Christopher Schultz [mailto:ch...@christopherschultz.net] Sent: Friday, March 28, 2014 11:13 AM To: Tomcat Users List Subject: Re: Connection pooling issue on Tomcat -BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Barry, On 3/28/14, 11:58 AM, Propes, Barry L

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Mark Shifman
ro. Yes, I do realize that the Tomcat version is old, but we'll be retiring the app in a few months so there's no need (at this time) to upgrade it. I use connection pooling, specifically Tomcat's DBCP class. This app has worked for years, but is suddenly encountering a strange c

Connection pooling issue on Tomcat

2014-03-28 Thread Propes, Barry L
s old, but we'll be retiring the app in a few months so there's no need (at this time) to upgrade it. I use connection pooling, specifically Tomcat's DBCP class. This app has worked for years, but is suddenly encountering a strange connection error and issue to the PROD region onl

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Christopher Schultz
e local builds on both my desktop and laptop, both > of which are Windows XP Pro. Yes, I do realize that the Tomcat > version is old, but we'll be retiring the app in a few months so > there's no need (at this time) to upgrade it. > > I use connection pooling, specifically

Re: JMX enabled - not able to monitor connection pooling

2012-02-09 Thread Daniel Mikusa
hat you were able to connect. Were you able to see the mbeans for the connection pool? > I want to be able to monitor the connection pool. Can you include your configuration for the connection pool? Dan > Is there an option that I have to enable to be able to > monitor connection po

JMX enabled - not able to monitor connection pooling

2012-02-09 Thread Josh Gooding
ing I need to. I also checked in JConsole, just to make sure it wasn't an initial id10t error. I want to be able to monitor the connection pool. Is there an option that I have to enable to be able to monitor connection pooling in Tomcat via JMX and Hyperic? I checked the Hyp. forums to no re

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
ive should have? -Original Message- From: Terence M. Bandoian [mailto:tere...@tmbsw.com] Sent: 21 Nov 2011 16 11 To: Tomcat Users List Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp On 1:59 PM, Martin O'Shea wrote: Caused by: com.mysql.j

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 21:25, Martin O'Shea wrote: Well, I hope I’m reading VisualVM correctly, because when I run the JMeter test first time around, I see 40 ‘connector’ threads created in VisualVM, all of which run for so long and then return to a wait state. I always forget to tell people to get

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 20:09, Martin O'Shea wrote: > Are you able to provide any more information about what I am actually > looking for in VisualVM? Depends how you defined the Db. Did you define a global Resource in server.xml? Or perhaps in conf/context.xml? p > -

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Well, I hope I'm reading VisualVM correctly, because when I run the JMeter test first time around, I see 40 'connector' threads created in VisualVM, all of which run for so long and then return to a wait state. And if I run the test again several times in succession, the number of connector th

FW: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Are you able to provide any more information about what I am actually looking for in VisualVM?

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
Tomcat > maxActive should have? > > -Original Message- > From: Terence M. Bandoian [mailto:tere...@tmbsw.com] > Sent: 21 Nov 2011 16 11 > To: Tomcat Users List > Subject: Re: Connection pooling issue with > MySQLNonTransientConnectionException and Java weba

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 16:11, "Terence M. Bandoian" wrote: > > On 1:59 PM, Martin O'Shea wrote: >> Caused by: >> com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data >> source rejected establishment of connection, message from server: "Too many >> connections" > > I'd check int

RE: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
. Bandoian [mailto:tere...@tmbsw.com] Sent: 21 Nov 2011 16 11 To: Tomcat Users List Subject: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp On 1:59 PM, Martin O'Shea wrote: > Caused by: > com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionExce

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
On 1:59 PM, Martin O'Shea wrote: Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Data source rejected establishment of connection, message from server: "Too many connections" I'd check into this. -Terence Bandoian ---

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Usually the connection is initialised as null and then assigned inside the try block. What happens if the method above throws an error after a connection is removed from the pool? To try to answer this, the sample code provided is illustrative of my DAO classes generally. The following is

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
es. Giving up. > > So this indicates that there's an issue either with the connection pooling > through Apache Tomcat 6.0.26 or MySQL > Community Server 5.X. > > The relevant part of the application's context.xml file in the project reads > as follows: > logAbandone

Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread appy74
as follows: com.mysql.jdbc.exceptions.jdbc4.MySQLNonTransientConnectionException: Could not create connection to database server. Attempted reconnect 3 times. Giving up. So this indicates that there's an issue either with the connection pooling through Apache Tomcat 6.0.26 or MySQL Community Server 5.X

Re: connection pooling configuration for DB2 in tomcat

2011-09-29 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Krish, On 9/28/2011 5:51 PM, rad muthu wrote: > I am looking for DB2 connection pooling configuration used in DB2. http://lmgtfy.com/?q=DB2+connection+pooling+configuration+used+in+DB2 http://catb.org/~esr/faqs/smart-questions.html - -ch

connection pooling configuration for DB2 in tomcat

2011-09-28 Thread rad muthu
All, I am looking for DB2 connection pooling configuration used in DB2. Thanks Krish

Re: connection Pooling in tomcat 6

2010-11-04 Thread Pid
On 04/11/2010 05:50, mike houston wrote: > Hi.. > > Is there a framework for implementing database connection pooling in tomcat > 6? > I am migrating my application from tomcat 4 to 6. There is already a > connection pooling implemented for the sql2000 server using the MS po

Re: connection Pooling in tomcat 6

2010-11-03 Thread Bob Hall
--- On Wed, 11/3/10 at 10:30 PM, mike houston wrote: > Can you please explain to me in > detail. > > Thanks, > M http://lmgtfy.com/?q=tomcat+6+dbcp&l=1 - Bob - To unsubscribe, e-mail: users-unsubscr...@tomcat.apach

Re: connection Pooling in tomcat 6

2010-11-03 Thread mike houston
t; > Is there a framework for implementing database connection pooling in > tomcat > > 6? > > I am migrating my application from tomcat 4 to 6. There is already a > > connection pooling implemented for the sql2000 server using the MS > pool.exe > > framework. But now thats not quite compatible. > > > > Please suggest. > > > > Thanks, > > Mike > > >

  1   2   3   4   5   6   >