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 and
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 use
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 com
xamples-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.DataSourceFactory". Tomcat did not
&g
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
those users.
>
> Hope this helps explain how we got to where we are.
>
> As I typed this, I started to wonder if we should even ship tomcat-jdbc
> with Tomcat 9. I'll start a discussion along those lines on the dev list.
>
> mark
>
> >
> > 2015-06-02 16:59 GMT+03:00
tart a discussion along those lines on the dev list.
>
> mark
>
> >
> > 2015-06-02 16:59 GMT+03:00 Mark Thomas :
> >
> >> On 01/06/2015 14:22, Tweak Ronaldo wrote:
> >>> Hello guys,
> >>
> >> Assuming you don't want to limit
ould 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 re
s,
>
> 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
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 clos
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
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 stat
-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.
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?
Re
="foopass" />
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 wen
alina.core.ApplicationContext log
>> INFO: Initializing Spring root WebApplicationContext
>> Mar 06, 2013 11:58:57 AM org.apache.catalina.core.ApplicationContext log
>> INFO: ContextListener: contextInitialized()
>> Mar 06, 2013 11:58:57 AM org.apache.catalina.core.Appli
:57 AM org.apache.catalina.core.ApplicationContext log
> INFO: ContextListener: contextInitialized()
> Mar 06, 2013 11:58:57 AM org.apache.catalina.core.ApplicationContext log
> INFO: SessionListener: contextInitialized()
> Mar 06, 2013 11:58:57 AM org.apache.catalina.core.Application
7 AM org.apache.catalina.core.ApplicationContext log
INFO: ContextListener: contextInitialized()
Mar 06, 2013 11:58:57 AM org.apache.catalina.core.ApplicationContext log
INFO: SessionListener: contextInitialized()
Mar 06, 2013 11:58:57 AM org.apache.catalina.core.ApplicationContext log
>
>>
username="foouser"
> password="foopass"
> />
>
>
> 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.
W
wrong, 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 tomc
>>
>> 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
-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
> 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
-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
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
jdb
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
-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
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
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
-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
在 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
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)
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
-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
이재만,
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
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
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
> > 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 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
> -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
&g
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:
*
t; 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!
>
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.mave
> 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 common
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
> 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
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://vigilbo
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-
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.
>
>>
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
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
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
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
h testWhileIdle set to true, but with
no more success.
Any hint would be much appreciated, 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é
-
-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
bscribe, 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-number-of-conne
-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
-------
> 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-My
-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
aRQCfWQPncqd/ykRg9AD4M43ag8FJ
> UKkAn0sSdb3b/pUDp9RDDV9KJG1noqys
> =MAA7
> -END PGP SIGNATURE-
>
> -
> To unsubscribe, e-mail: users-unsubscr...@tomcat.apache.org
> For additional commands, e-mail: users-h...@tomcat.apache.org
>
-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
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
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
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... ?
ww.geocities.com/evan_j_siegel
and
http://www.qlineorientalist.com/IranRises'>http://www.qlineorientalist.com/IranRises";>http://www.qlineorientalist.com/IranRises
Thank you.
From: Yagnesh Chawda
To: users@tomcat.apache.org
Sent: Mon, November 16, 2009
auto
--
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-tp26372475p26372475.html
Sent from the Tomcat - User mailing list a
-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
cuteUpdate(DelegatingPreparedStatement.java:102)
at
org.springframework.jdbc.core.JdbcTemplate$2.doInPreparedStatement(JdbcTemplate.java:798)
at
org.springframework.jdbc.core.JdbcTemplate.execute(JdbcTemplate.java:591)
--
View this message in context:
http://www.nabble.com/Tomc
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-reposito
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
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
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
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. Thi
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 is
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 tha
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
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 ap
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 that other applicatio
80 matches
Mail list logo