Hi,
In the java application (using tomcat 7, JDK 7u51,
tomcat-dbcp-8.0.3.jar, ojdbc6.jar) there is a certain connection leak.
After the connection pool was exhausted (pool reached maxTotal active
connections), I took heap dump. On analyzing heap dump, as expected
maxTotal PoolableConnection
.org/tomcat-8.0-doc/jndi-datasource-examples-howto.html#Database_Connection_Pool_(DBCP_2)_Configurations,
> we switched to using the new param values like: maxTotal and maxWaitMillis.
>
> Then, we switched to using the Tomcat DBCP by adding
> factory="org.apache.tomcat.jdbc.pool.DataSour
Did not what?
We added "factory='org.apache.tomcat.jdbc.pool.DataSourceFactory'". That
switched us to Tomcat DBCP, correct?
At that time, we were using the updated "maxWaitMillis" and "maxTotal" in
our context.xml and Tomcat didn't seem to complain on startu
On 07/10/2015 19:54, Bradley Wagner wrote:
> Did not what?
>
> We added "factory='org.apache.tomcat.jdbc.pool.DataSourceFactory'". That
> switched us to Tomcat DBCP, correct?
No. There is no such thing as Tomcat DBCP.
There is Apache Commons DBCP 1. This is used by d
switched to using the new param values like: maxTotal and maxWaitMillis.
Then, we switched to using the Tomcat DBCP by adding
factory="org.apache.tomcat.jdbc.pool.DataSourceFactory". Tomcat did not
seem to have a problem with using Tomcat DBCP with the updated param names.
Then, I modified a te
,
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 following issue:
after database restart (Postgres
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,
after failed attempt to execute some SQL statement, returned back to
pool
,
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 following issue:
after database restart (Postgres), our
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,
after failed attempt to execute some SQL statement, returned back
2015-06-01 16:22 GMT+03:00 Tweak Ronaldo twea...@gmail.com:
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
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 following
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,
after failed attempt to execute some SQL statement
Hi,
reading tomcat 8.x documentation, I don't find anything about tomcat-dbcp. The
use of tomcat-jdbc is described at [1].
Some of the disadvantages just apply for DBCP 1.x.
Is the use of tomcat-jdbc still recommended compared to the repackaged DBCP 2.x
in tomcat-dbcp package?
Regards
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Christian,
On 11/28/14 7:57 AM, Christian wrote:
reading tomcat 8.x documentation, I don't find anything about
tomcat-dbcp. The use of tomcat-jdbc is described at [1]. Some of
the disadvantages just apply for DBCP 1.x. Is the use of
tomcat
, I get no indication of why it went wrong. I suppose
Tomcat/DBCP is catching the exception and not logging it.
When I try from outside of tomcat using jdbc, I see Oracle returning a
ORA-01017 error code and jdbc throwing an exception.
What must I do in the logging.properties to make tomcat log
the DB?
I suppose Tomcat/DBCP is catching the exception and not logging it.
Hard to say for sure, but it's possible that DBCP may not even be connecting to
the Database. The initialSize parameter defaults to 0, so on startup it
won't make any connections. Maybe try setting initialSize to 1 and see
org.apache.catalina.core.ApplicationContext log
I suppose Tomcat/DBCP is catching the exception and not logging it.
Hard to say for sure, but it's possible that DBCP may not even be connecting
to the Database. The initialSize parameter defaults to 0, so on startup it
won't make any connections. Maybe try
? That should force DBCP to create a connection at startup and, if that
connection fails, it should log it. I tested this in my Tomcat setup, with an
out-of-the-box logging configuration, and it worked fine.
I suppose Tomcat/DBCP is catching the exception and not logging it.
Hard to say
, with
an out-of-the-box logging configuration, and it worked fine.
I suppose Tomcat/DBCP is catching the exception and not logging it.
Hard to say for sure, but it's possible that DBCP may not even be
connecting to the Database. The initialSize parameter defaults to 0, so
on startup
/
Resource looks good: you confirm that it works properly when
username/password are correct.
When the username and password are correct, I have no trouble
connecting and my application works as expected. However when this
is wrong, I get no indication of why it went wrong. I suppose
Tomcat/DBCP
-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
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:
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 are
Hi:
I want to add database failover to my web application
I use Tomcat 6 and SQLServer database + JDBC Driver 3.0
I'm getting connections from datasource with
DataSource ds = ic.lookup(java:comp/env/jdbc/mydb);
Connection con = ds.getConnection();
I know that I've got to define a DN like
-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
scenario
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
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Kiran,
On 6/26/12 7:24 PM, Kiran Badi wrote:
Resource name=jdbc/mysitedb auth=Container
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
在 2012-6-26，13:11，Kiran Badi ki...@poonam.org 写道：
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
-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
Probably
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
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 Resource elements.
Resource name=jdbc/mysitedb auth=Container
type=javax.sql.DataSource
maxActive=100 maxIdle=30
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.PoolingDataSource.getConnection(PoolingDataSource.java:114)
-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 that
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:
how do i encrypt my datasource's user and password in server.xml
??
Read this: http
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:
이재만,
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:
On 11/03/2012 02:08, Jim Garrison wrote:
-Original Message-
From: Jim Garrison [mailto:jim.garri...@troux.com]
Sent: Saturday, March 10, 2012 7:07 PM
To: users@tomcat.apache.org
Subject: Source jar for tomcat-dbcp?
I have a problem I need to debug by stepping into tomcat-dbcp
It would have been nice if this was noted in the docs :-)
Sounds like you're pretty close to being able to make a patch. ;)
I'm willing to write something up, but am not sure how to contribute it to the
doc website. I rummaged through the ASF svn and found the tomcat/site
stuff, but it
On 11/03/2012 21:41, Jim Garrison wrote:
It would have been nice if this was noted in the docs :-)
Sounds like you're pretty close to being able to make a patch. ;)
I'm willing to write something up, but am not sure how to contribute it to the
doc website. I rummaged through the ASF svn
I have a problem I need to debug by stepping into tomcat-dbcp (6.0.35). I tried
downloading the Apache commons-dbcp source but it seems the version in Tomcat
has the classes in different packages, so I can't get Eclipse to recognize the
source.
I've searched the following areas:
* the tomcat
-Original Message-
From: Jim Garrison [mailto:jim.garri...@troux.com]
Sent: Saturday, March 10, 2012 7:07 PM
To: users@tomcat.apache.org
Subject: Source jar for tomcat-dbcp?
I have a problem I need to debug by stepping into tomcat-dbcp (6.0.35). I
tried downloading the Apache
Hello Tomcat users,
I have couple of tomcat-dbcp related questions:
1) Can tomcat-dbcp be used outside of tomcat e.g. in non-web apps?
2) If yes, are all features available as when used within tomcat?
3) Most importantly are custom interceptors supported when tomcat-dbcp
is used outside tomcat
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
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
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
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/2009
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://svn.apache.org/viewvc/tomcat
-
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 hold of the source code? I found
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 hold of the source code? I found some svn
links that point to 404.
http://svn.apache.org/viewvc/tomcat/trunk/modules/jdbc-pool
Hello.
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-jdb
c.html
http://www.tomcatexpert.com
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
, especially on the logging side
(Tomcat / DBCP), since I cant see how to get more information on what is
going on with those buggy connections.
Thank you,
José
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
2010/3/10 José Paumard jose.paum...@orange.fr:
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
-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 through
-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
-
-
To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
For additional commands, e-mail: users-h...@tomcat.apache.org
--
View this message in context:
http://old.nabble.com/Tomcat-DBCP-Connection-Pooling-to-MySQL-limited
-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
://old.nabble.com/Tomcat-DBCP-Connection-Pooling-to-MySQL-limited-number-of-connection-issue-in-Spring2.5-%2B-Hibernate3-%2B-commons-DBCP1.2-tp26372475p26402989.html
Sent from the Tomcat - User mailing list archive at Nabble.com
this message in context:
http://old.nabble.com/Tomcat-DBCP-Connection-Pooling-to-MySQL-limited-number-of-connection-issue-in-Spring2.5-%2B-Hibernate3-%2B-commons-DBCP1.2-tp26372475p26372475.html
Sent from the Tomcat - User mailing list archive at Nabble.com
, 2009 9:09:51 AM
Subject: Tomcat DBCP Connection Pooling to MySQL limited number of connection
issue in Spring2.5 + Hibernate3 + commons-DBCP1.2
Hi,
I am using Spring 2.5, Hibernate 3 and MySQL (5.0.45 (32 Bit), 5.0.84(64
Bit)) with commons-DBCP 1.2 in Tomcat-5.5
My issue is that even after
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... ?
2009/11/16 Pid p...@pidster.com:
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
Peter Crowther wrote:
2009/11/16 Pid p...@pidster.com:
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
-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:
bean id=dataSource destroy-method=close
class=org.apache.commons.dbcp.BasicDataSource
!--property name=driverClassName
--
View this message in context:
http://old.nabble.com/Tomcat-DBCP-Connection-Pooling-to-MySQL-limited-number-of-connection-issue-in-Spring2.5-%2B-Hibernate3-%2B-commons-DBCP1.2-tp26372475p26384679.html
Sent from the Tomcat - User mailing list archive at Nabble.com
logAbandoned=true validationQuery=select
count(*) from dual/
--
View this message in context:
http://www.nabble.com/Tomcat-DBCP%3A-Getting-java.sql.SQLException%3A-Closed-Statement-tp23416137p23416137.html
Sent from the Tomcat - User mailing list archive
-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
Env: Redhat, jre6, Tomcat 6.0.14
In migrating a webapp using commons-dbcp from Tomcat 5.5.x to Tomcat 6.0.x,
I find that my database fails to obtain connections from the pool.
This is a long shot: is there any interplay between tomcat-dbcp (located in
${CATALINA_BASE}/lib and commons-dbcp
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
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
repo1.maven.org...am I just missing another maven repository that I should
be looking at, or must I manually install this JAR into my own local
Hi all,
Need help on this. We are using Tomcat 5.5 with DBCP to reach
Oracle DB. When this DB goes down for an hour or so and comes back up
(like maintenance etc), Tomcat server is not able to connect back to DB
and the only way out is restarting the tomcat server.
I am trying to find
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.
Hi all,
Need help on this. We are using Tomcat 5.5 with DBCP to reach
Oracle DB. When this DB goes down for an hour or so and comes back up
(like maintenance etc), Tomcat server is not able to connect back to DB
and the only way out is restarting the tomcat server.
I am trying to find
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 the
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 trying to find
Foo Shyn wrote:
Hi guys,
Currently i'm using Tomcat 4.1 and my application uses the Tomcat's DBCP to
connect to a Derby database.
However, since the Derby database only allow one application to connect to it
at a time, is it possible that i could configure the Tomcat's DBCP connection
so
Foo Shyn wrote:
Currently i'm using Tomcat 4.1 and my application uses the Tomcat's DBCP to
connect to a Derby database.
However, since the Derby database only allow one application to connect to it
at a time, is it possible that i could configure the Tomcat's DBCP connection
so that other
Mikolaj''s response may seem a bit curt, but the point is that one
connection to a database is very limiting and not real practical.
On 9/14/06, Mikolaj Rydzewski [EMAIL PROTECTED] wrote:
Foo Shyn wrote:
Currently i'm using Tomcat 4.1 and my application uses the Tomcat's DBCP
to connect to a
78 matches
Mail list logo
