Re: Tomcat DBCP 8.0.18 issue

2015-06-03 Thread Tweak Ronaldo
Hmm, interesting... Thanks for explanation Mark! 2015-06-03 12:22 GMT+03:00 Mark Thomas : > On 03/06/2015 07:24, Tweak Ronaldo wrote: > > Thanks Mark, yes I have mixed together Tomcat JDBC 8 and DBCP 7, my bad. > > Although I don't understand why Tomcat JDBC don't use DBCP as default > > solution

Re: Tomcat DBCP 8.0.18 issue

2015-06-03 Thread Антон Мацюк
Mark, big thanks for a quick historical review, it was very intreresting! I was thinking that tomcat-jdbc is something new, but wasn't sure about project maintenance. 2015-06-03 12:22 GMT+03:00 Mark Thomas : > On 03/06/2015 07:24, Tweak Ronaldo wrote: > > Thanks Mark, yes I have mixed together To

Re: Tomcat DBCP 8.0.18 issue

2015-06-03 Thread Mark Thomas
On 03/06/2015 07:24, Tweak Ronaldo wrote: > Thanks Mark, yes I have mixed together Tomcat JDBC 8 and DBCP 7, my bad. > Although I don't understand why Tomcat JDBC don't use DBCP as default > solution for connections pooling. Tomcat does - and always has - used Commons DBCP for connection pooling b

Re: Tomcat DBCP 8.0.18 issue

2015-06-02 Thread Tweak Ronaldo
Thanks Mark, yes I have mixed together Tomcat JDBC 8 and DBCP 7, my bad. Although I don't understand why Tomcat JDBC don't use DBCP as default solution for connections pooling. 2015-06-02 16:59 GMT+03:00 Mark Thomas : > On 01/06/2015 14:22, Tweak Ronaldo wrote: > > Hello guys, > > Assuming you do

Re: Tomcat DBCP 8.0.18 issue

2015-06-02 Thread Konstantin Kolinko
2015-06-01 16:22 GMT+03:00 Tweak Ronaldo : > Hello guys, we have migrated to Tomcat DBCP 8.0.18 from 7.0.37 recently and > faced the following issue: > after database restart (Postgres), our application wasn't been able to > restore connectivity to DB, all connections were closed and every time, >

Re: Tomcat DBCP 8.0.18 issue

2015-06-02 Thread Mark Thomas
On 01/06/2015 14:22, Tweak Ronaldo wrote: > Hello guys, Assuming you don't want to limit your question to men only, you would be better to use of of the following greetings: Hello, Hello all, Hello folks, etc. > we have migrated to Tomcat DBCP 8.0.18 from 7.0.37 recently and > faced the followin

Re: Tomcat DBCP Logging

2013-03-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA256 Rahul, On 3/6/13 12:49 PM, Rahul Somasunderam wrote: > I'm running Tomcat 7.0.23. I've got a question about configuring > the logging of DBCP Failures. Echoing Daniel's suggestion: upgrade. > I've go this in my context xml file. > > The "path"

Re: Tomcat DBCP Logging

2013-03-06 Thread Rahul Somasunderam
Thanks Dan, The initialSize brought the logs into my catalina.out. R, rahul On Mar 6, 2013, at 2:21 PM, Daniel Mikusa wrote: > On Mar 6, 2013, at 5:07 PM, Rahul Somasunderam wrote: > >> >> On Mar 6, 2013, at 11:26 AM, Daniel Mikusa wrote: >> >>> On Mar 6, 2013, at 1:49 PM, Rahul Somasunder

Re: Tomcat DBCP Logging

2013-03-06 Thread Daniel Mikusa
On Mar 6, 2013, at 5:07 PM, Rahul Somasunderam wrote: > > On Mar 6, 2013, at 11:26 AM, Daniel Mikusa wrote: > >> On Mar 6, 2013, at 1:49 PM, Rahul Somasunderam wrote: >> >>> Hi, >>> >>> I'm running Tomcat 7.0.23. >> >> This is getting pretty old, you might want to consider upgrading. > > I

Re: Tomcat DBCP Logging

2013-03-06 Thread Rahul Somasunderam
On Mar 6, 2013, at 11:26 AM, Daniel Mikusa wrote: > On Mar 6, 2013, at 1:49 PM, Rahul Somasunderam wrote: > >> Hi, >> >> I'm running Tomcat 7.0.23. > > This is getting pretty old, you might want to consider upgrading. I will, but I don't think this has to do much with tomcat being old. I thi

Re: Tomcat DBCP Logging

2013-03-06 Thread Daniel Mikusa
On Mar 6, 2013, at 1:49 PM, Rahul Somasunderam wrote: > Hi, > > I'm running Tomcat 7.0.23. This is getting pretty old, you might want to consider upgrading. > I've got a question about configuring the logging of DBCP Failures. > > I've go this in my context xml file. > > > name="jd

Re: Tomcat DBCP & SQLServer failover

2012-10-12 Thread Jose María Zaragoza
>> >> I agree with you. Because of that, I've got that question :-) > > Hopefully I've answered it..? > > - -chris A lof of thanks, Chris. I'm going to test it and I'll make feedback to the list Regards - To unsubscribe, e-mail

Re: Tomcat DBCP & SQLServer failover

2012-10-12 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jose, On 10/11/12 3:31 PM, Jose María Zaragoza wrote: >> How can you tell the difference between a primary server being >> "down" and the primary server needing to (otherwise?) fail-over >> to the backup? I'm confused about your nomenclature (primary

Re: Tomcat DBCP & SQLServer failover

2012-10-11 Thread Jose María Zaragoza
> How can you tell the difference between a primary server being "down" > and the primary server needing to (otherwise?) fail-over to the > backup? I'm confused about your nomenclature (primary failover means > mirror -> primary?). Well, I'm newbie in SQLServer but I think that primary and mirror

Re: Tomcat DBCP & SQLServer failover

2012-10-10 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Jose María, On 10/10/12 3:00 PM, Jose María Zaragoza wrote: > I want to add database failover to my web application I use Tomcat > 6 and SQLServer database + JDBC Driver 3.0 > > But my doubts are about what happen with pooled connections. The > scen

Re: Tomcat DBCP Connection pool issue

2012-06-28 Thread Kiran Badi
On 6/27/2012 8:35 PM, Christopher Schultz wrote: 100 active db connections sounds like a lot. Do you really need to support 100 simultaneous connections to your database? Can your database support that many connections with active queries from each? Do you have a cluster? Remember that each membe

Re: Tomcat DBCP Connection pool issue

2012-06-27 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kiran, On 6/26/12 7:24 PM, Kiran Badi wrote: > type="javax.sql.DataSource" maxActive="100" maxIdle="30" > maxWait="1" 100 active db connections sounds like a lot. Do you really need to support 100 simultaneous connections to your database? Can y

Re: Tomcat DBCP Connection pool issue

2012-06-26 Thread Kiran Badi
Probably waited too long for a connection. What does your pool configuration look like? Look in META-INF/context.xml or, I suppose, in conf/server.xml for elements. type="javax.sql.DataSource" maxActive="100" maxIdle="30" maxWait="1" username="user" password

Re: Tomcat DBCP Connection pool issue

2012-06-26 Thread Kiran Badi
On 6/26/2012 12:09 PM, Steven Sinclair wrote: > You can use java jmx console to monitor the number of db connections. Thanks Steven, I will check this.Actually servlet was leaking connection and I had forgot to close connection.Fixed it now. But I still need to monitor DB side.I will check jmx con

Re: Tomcat DBCP Connection pool issue

2012-06-26 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Kiran, On 6/26/12 1:11 AM, Kiran Badi wrote: > While testing the pagination links ,I am getting below error, > > SEVERE: null org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot > get a connection, pool error Timeout waiting for idle object Proba

Re: Tomcat DBCP Connection pool issue

2012-06-25 Thread Steven Sinclair
在 2012-6-26,13:11,Kiran Badi 写道: > Hi All, > > While testing the pagination links ,I am getting below error, > > SEVERE: null > org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot get a connection, pool > error Timeout waiting for idle object >at > org.apache.tomcat.dbcp.dbcp.PoolingDa

RE: tomcat dbcp encryption

2012-03-28 Thread Filip Hanik (mailing lists)
10:25 AM > To: Tomcat Users List > Subject: Re: tomcat dbcp encryption > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Ognjen, > > On 3/27/12 6:32 AM, Ognjen Blagojevic wrote: > > 이재만, > > > > On 27.3.2012 9:54, 이재만 wrote: > >> ho

Re: tomcat dbcp encryption

2012-03-28 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ognjen, On 3/27/12 6:32 AM, Ognjen Blagojevic wrote: > 이재만, > > On 27.3.2012 9:54, 이재만 wrote: >> how do i encrypt my datasource's user and password in server.xml >> ?? > > Read this: http://wiki.apache.org/tomcat/FAQ/Password No, he didn't like th

Re: tomcat dbcp encryption

2012-03-27 Thread Ognjen Blagojevic
이재만, On 27.3.2012 9:54, 이재만 wrote: how do i encrypt my datasource's user and password in server.xml ?? Read this: http://wiki.apache.org/tomcat/FAQ/Password -Ognjen - To unsubscribe, e-mail: users-unsubscr...@tomcat.apache

Re: tomcat dbcp encrption

2012-03-27 Thread Mark Thomas
On 27/03/2012 08:53, 이재만 wrote: > hello everybody... > > somebody help me..please.. > > how do i encrypt my datasource's user and password in server.xml ?? http://wiki.apache.org/tomcat/FAQ/Password - To unsubscribe, e-mail: u

Re: tomcat-dbcp interceptors

2011-11-11 Thread Daniel Mikusa
Stevo, OK, in the context of tomcat-jdbc, your questions do make more sense. Glad you were able to find the answers. BTW, I would strongly recommend tomcat-jdbc over DBCP. Been working with it for a while and it's very nice. Dan On Fri, 2011-11-11 at 06:44 -0800, Stevo Slavić wrote: > Hello D

Re: tomcat-dbcp interceptors

2011-11-11 Thread Stevo Slavić
Hello Daniel, You're right, commons-dbcp and tomcat-dbcp seem to be same, I missed tomcat-jdbc module which seems to provide extensions and judging by the pom (see [1]) it depends only on tomcat-juli. I found the answers at [2] and [3]. Thanks! Regards, Stevo. [1] http://repo1.maven.org/maven2

Re: tomcat-dbcp interceptors

2011-11-11 Thread Daniel Mikusa
> 1) Can tomcat-dbcp be used outside of tomcat e.g. in non-web apps? Yes, but tomcat-dbcp is exactly the same as commons-dbcp. You would probably just want to use commons-dbcp. > 2) If yes, are all features available as when used within tomcat? It has the same feature set as commons-dbcp.

RE: Tomcat DBCP

2010-07-01 Thread Caldarale, Charles R
> From: Bill Davidson [mailto:bill...@gmail.com] > Subject: Re: Tomcat DBCP > > If we don't want to buy SpringSource tc, do we need to check > it out from SVN and build it? Not sure what the official status of the package is right now, but you can get it here: http://s

Re: Tomcat DBCP

2010-07-01 Thread Mark Thomas
On 01/07/2010 23:31, Bill Davidson wrote: On 6/9/2010 2:15 AM, Altanis Alexandros wrote: >I have been reading about the new Tomcat DBCP in a couple of blogs >lately, as I am interested in Connection Pooling for an application I am >working on. Here they are: > >http://vigilbose.blogspot.com/

Re: Tomcat DBCP

2010-07-01 Thread Bill Davidson
On 6/9/2010 2:15 AM, Altanis Alexandros wrote: >I have been reading about the new Tomcat DBCP in a couple of blogs >lately, as I am interested in Connection Pooling for an application I am >working on. Here they are: > >http://vigilbose.blogspot.com/2009/03/apache-commons-dbcp-and-tomcat-jdbc.html

Re: Tomcat DBCP

2010-06-10 Thread Mark Thomas
Mark Thomas [mailto:ma...@apache.org] > Sent: Wednesday, June 09, 2010 1:31 PM > To: Tomcat Users List > Subject: Re: Tomcat DBCP > > On 09/06/2010 10:15, Altanis Alexandros wrote: >> My question is this: can I use this feature with Tomcat 6? > > Yes. > >>

RE: Tomcat DBCP

2010-06-10 Thread Altanis Alexandros
Original Message- From: Mark Thomas [mailto:ma...@apache.org] Sent: Wednesday, June 09, 2010 1:31 PM To: Tomcat Users List Subject: Re: Tomcat DBCP On 09/06/2010 10:15, Altanis Alexandros wrote: > My question is this: can I use this feature with Tomcat 6? Yes. > Where can I get a

Re: Tomcat DBCP

2010-06-09 Thread Mark Thomas
On 09/06/2010 10:15, Altanis Alexandros wrote: > My question is this: can I use this feature with Tomcat 6? Yes. > Where can I get a hold of the source code? I found some svn > links that point to 404. http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool/ Mark

Re: Tomcat DBCP : testOnBorrow not working (?)

2010-03-10 Thread Konstantin Kolinko
2010/3/10 José Paumard : > To be sure that DBCP is not providing closed connections to Hibernate, I > added the following to the Resource element, but with no success : (...) Note, that META-INF/context.xml of a web application is copied to ${catalina.base}/conf/Catalina/localhost/.xml when your a

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yagnesh, On 11/18/2009 1:32 AM, Yagnesh Chawda wrote: > There is no difference in the outcome when I use "com.mysql.jdbc.Driver" > >max_connections=200 is still same in MySQL. That is very strange. Can you try to configure the data source thr

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-17 Thread Yagnesh Chawda
Hi, There is no difference in the outcome when I use "com.mysql.jdbc.Driver" max_connections=200 is still same in MySQL. I confirmed that MySQL is able to handle that much load by running JMeter load testing which causes my application to create even 95 connection if I set "maxActive" connec

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yagnesh, On 11/17/2009 10:51 AM, Yagnesh Chawda wrote: > Thanks for reply. I had tried using "com.mysql.jdbc.Driver" as well > earlier. But no luck :( What does happen when you use com.mysql.jdbc.Driver? What are the current values for max_connect

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-17 Thread Yagnesh Chawda
Hi Chris, Thanks for reply. I had tried using "com.mysql.jdbc.Driver" as well earlier. But no luck :( Christopher Schultz-2 wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Yagnesh, > > On 11/17/2009 12:32 AM, Yagnesh Chawda wrote: >> Thanks Chris, That was just a typo. Than

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yagnesh, On 11/17/2009 12:32 AM, Yagnesh Chawda wrote: > Thanks Chris, That was just a typo. Thanks for pointing it out. But in real > configuration was was not commented. It was some other config which I was > trying and forgot to uncomment it in po

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Yagnesh Chawda
Hey, Thanks Chris, That was just a typo. Thanks for pointing it out. But in real configuration was was not commented. It was some other config which I was trying and forgot to uncomment it in posting. Christopher Schultz-2 wrote: > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > Yagnes

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Yagnesh, On 11/16/2009 9:09 AM, Yagnesh Chawda wrote: > My bean definition is as follows for DBCP: > > class="org.apache.commons.dbcp.BasicDataSource"> > > Your bean appears to be almost entirely commented-out. Is this your r

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Mark Thomas
Peter Crowther wrote: > 2009/11/16 Pid : >> You managed to subscribe to the list, can't you follow the instructions on >> how to unsubscribe? Clues at the bottom of every email. > > We keep saying that, and it keeps being a problem for users. > > The email-based unsubscribe appears to be unrelia

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Peter Crowther
2009/11/16 Pid : > You managed to subscribe to the list, can't you follow the instructions on > how to unsubscribe?  Clues at the bottom of every email. We keep saying that, and it keeps being a problem for users. The email-based unsubscribe appears to be unreliable, I suspect due to an overzealo

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Pid
On 16/11/2009 14:12, Evan Siegel wrote: UNSUBSCRIBE ME! I have been emailing you guys for over a week to unsubcribe me. > PLEASE CEASE AND DESIST FROM SENDING ME MORE MAILINGS FROM THIS LIST! "You guys"? There's only one email from you, that I can see to this list, which is this one. So... ?

Re: Tomcat DBCP Connection Pooling to MySQL limited number of connection issue in Spring2.5 + Hibernate3 + commons-DBCP1.2

2009-11-16 Thread Evan Siegel
UNSUBSCRIBE ME! I have been emailing you guys for over a week to unsubcribe me. PLEASE CEASE AND DESIST FROM SENDING ME MORE MAILINGS FROM THIS LIST! Please visit our websites at http://www.geocities.com/evan_j_siegel'>http://www.geocities.com/evan_j_siegel";>http://www.geocities.com/evan_j_sie

Re: Tomcat DBCP: Getting java.sql.SQLException: Closed Statement

2009-05-06 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Ashoknan, On 5/6/2009 5:43 PM, ashoknan wrote: > This app was running fine in Weblogic but after migrating to Tomcat > 6+ DBCP we are seeing the below exception. Which version of TC 6 are you using? Are you using the stock DBCP or Filip's new-fangled

Re: tomcat-dbcp from Maven

2007-05-21 Thread Filip Hanik - Dev Lists
the maven jars/upload is still in process, if you want to contribute help, take a look at res/maven in the tomcat 6 tree Filip lightbulb432 wrote: The tomcat-dbcp library doesn't seem to be available from the Maven repository for Tomcat at http://tomcat.apache.org/dev/dist/m2-repository or rep

RE: Tomcat / DBCP / Oracle / Reconnect

2007-01-18 Thread Krishna Paparaju
I could make this work with 'validationQuery' parameter. Thanks -Original Message- From: Mark Thomas [mailto:[EMAIL PROTECTED] Sent: Thursday, January 18, 2007 7:08 PM To: Tomcat Users List Subject: Re: Tomcat / DBCP / Oracle / Reconnect Krishna Paparaju wrote: > I am t

Re: Tomcat / DBCP / Oracle / Reconnect

2007-01-18 Thread Mark Thomas
Krishna Paparaju wrote: > I am trying to find is there anyway Tomcat can be configured to > reconnect back to DB once it is up. I know autoReconnect flag works for > mySQL. Is there any equivalent in Oracle/thin driver? You could use testOnBorrow="true" and a validationQuery to achieve this. Check

Re: Tomcat / DBCP / Oracle / Reconnect

2007-01-18 Thread Mark Thomas
When starting a new thread (ie sending a message to the list about a new topic) please do not reply to an existing message and change the subject line. To many of the list archiving services and mail clients used by list subscribers this makes your new message appear as part of the old thread. Thi