On Mar 31, 2014, at 7:05 AM, Saurabh Saraswat ssaras...@pivotalindia.com
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 me
-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 way or not.
Glad
Dear All,
Please accept my heartily thanks for your valuable responses.
*Daniel / Chris*,
Thank you so much. You both gave me a vary helpful explanation. I have read
many forums but still was confused but you guys have cleared my doubts and
also gave me new ideas to do better.
Thank you again.
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA256
Barry,
On 3/28/14, 11:58 AM, Propes, Barry L wrote:
Hi folks,
I'm using Tomcat 6.0.29 for an app I've had in place for years. I
run the Java app I have on a Windows 2003 server for my production
region, but have local builds on both my
On 03/28/2014 11:58 AM, Propes, Barry L wrote:
Hi folks,
I'm using Tomcat 6.0.29 for an app I've had in place for years. I run the Java
app I have on a Windows 2003 server for my production region, but have local
builds on both my desktop and laptop, both of which are Windows XP Pro. Yes, I
-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
-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 an app I've had
On Fri, Mar 28, 2014 at 12:31 PM, Propes, Barry L
barry.l.pro...@citi.comwrote:
-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
=
Thanks, Mark, I
On 21 Nov 2011, at 09:28, app...@dsl.pipex.com app...@dsl.pipex.com wrote:
Hello
I don't think this is a Tomcat issue but I thought I would post here just in
case.
I have a Java, JSP and MySQL application running under Apache Tomcat 6.0.26
which I've been testing with JMeter.
What I
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
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
[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.MySQLNonTransientConnectionException:
Data source
On 21 Nov 2011, at 16:11, Terence M. Bandoian tere...@tmbsw.com 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
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
Are you able to provide any more information about what I am actually
looking for in VisualVM?
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
On 21 Nov 2011, at 20:09, Martin O'Shea app...@dsl.pipex.com 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
On 21 Nov 2011, at 21:25, Martin O'Shea app...@dsl.pipex.com 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
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
-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
- -chris
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 pool.exe
framework. But now
you can use commons dbcp or c3p0 that are available openly.
Will
On Thu, Nov 4, 2010 at 12:50 PM, mike houston mike.housto...@gmail.comwrote:
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
Can you please explain to me in detail.
Thanks,
M
On Thu, Nov 4, 2010 at 10:43 AM, Will Sumekar will.sume...@gmail.comwrote:
you can use commons dbcp or c3p0 that are available openly.
Will
On Thu, Nov 4, 2010 at 12:50 PM, mike houston mike.housto...@gmail.com
wrote:
Hi..
Is there
--- On Wed, 11/3/10 at 10:30 PM, mike houston mike.housto...@gmail.com wrote:
Can you please explain to me in
detail.
Thanks,
M
http://lmgtfy.com/?q=tomcat+6+dbcpl=1
- Bob
-
To unsubscribe, e-mail:
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chuck,
On 3/31/2009 10:57 PM, Caldarale, Charles R wrote:
From: allen.ir...@smartintegration.com.au
Subject: Connection Pooling questions
I do close the connections within my program using conn.close();
The evidence suggests otherwise. You
Yes! And also, close out any other connections that may be embedded, like a
prepared statement, result set or stored procedure. These will also show that a
connection is still opened if not explicitly closed!
-Original Message-
From: allen.ir...@smartintegration.com.au
!
Original Message:
-
From: Caldarale, Charles R chuck.caldar...@unisys.com
Date: Tue, 31 Mar 2009 22:44:32 -0500
To: users@tomcat.apache.org
Subject: RE: Connection Pooling questions
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir...@smartintegration.com.au]
Subject: RE
Pretty sure it's a rogue connection that stays open.
-Original Message-
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Sent: Wednesday, April 01, 2009 9:13 AM
To: Tomcat Users List; allen.ir...@smartintegration.com.au;
chuck.caldar...@unisys.com
Subject: RE: Connection Pooling
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Subject: RE: Connection Pooling questions
What happens when the statement isn't closed but the
connection is returned to the pool?
The connection object your code sees isn't the real connection; it's a wrapper
created by the pool to control
Pooling questions
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Subject: RE: Connection Pooling questions
What happens when the statement isn't closed but the
connection is returned to the pool?
The connection object your code sees isn't the real connection; it's a wrapper
created by the pool
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Subject: RE: Connection Pooling questions
Are there any changes to DBCP other than package moves?
No, just the package renaming to avoid collisions.
Can I utilize the DBCP source package and expect that it's
the same code tomcat is using
Caldarale, Charles R wrote:
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Subject: RE: Connection Pooling questions
What happens when the statement isn't closed but the
connection is returned to the pool?
The connection object your code sees isn't the real connection; it's
: Shaun Farrugia [mailto:sfarru...@fry.com]
Sent: Wednesday, April 01, 2009 11:00 AM
To: Tomcat Users List
Subject: RE: Connection Pooling questions
Sweet,
I set up a test.jsp page that will Connection.close() without rs.close() and
ps.close(). Will let you know the results..
And I know you
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Chuck,
On 4/1/2009 10:47 AM, Caldarale, Charles R wrote:
From: Shaun Farrugia [mailto:sfarru...@fry.com]
Subject: RE: Connection Pooling questions
What happens when the statement isn't closed but the
connection is returned to the pool
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
David,
On 4/1/2009 11:25 AM, David Smith wrote:
This is assuming the developer didn't unwrap any of the DBCP objects to
access driver specific features. In that case, the original wrapped
objects need to be maintained and closed instead of the
From: Christopher Schultz [mailto:ch...@christopherschultz.net]
Subject: Re: Connection Pooling questions
I think the JDBC spec should strengthen your faith at least
in the correctness of this behavior...
I wasn't questioning the correctness of the intended behavior, and certainly
From: Christopher Schultz [mailto:ch...@christopherschultz.net]
Subject: Re: Connection Pooling questions
Actually, I can't think of a reason why you'd have to use the unwrapped
version of the statement or result set (or even connection) to perform
state management (i.e. calling close
the configuration you describe only defines parameters to be passed to the
Connection Pool Library..which connection pool library are you using?
are you using Thread starve algorithm? or explicit no-activity-on-connection
algorithm?
Most connection pools with close the connection only after
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir...@smartintegration.com.au]
Subject: Connection Pooling questions
I configure it using the suggested /META-INF/context.xml with:
maxActive=30 maxIdle=10
Post your entire context.xml so we can see the rest of the Resource element.
:
-
From: Martin Gainty mgai...@hotmail.com
Date: Tue, 31 Mar 2009 22:33:36 -0400
To: users@tomcat.apache.org
Subject: RE: Connection Pooling questions
the configuration you describe only defines parameters to be passed to the
Connection Pool Library..which connection pool library are you
To: users@tomcat.apache.org
Subject: RE: Connection Pooling questions
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir...@smartintegration.com.au]
Subject: Connection Pooling questions
I configure it using the suggested /META-INF/context.xml with:
maxActive=30 maxIdle=10
Post your
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir...@smartintegration.com.au]
Subject: RE: Connection Pooling questions
Resource name=jdbc/AttunitySProcDS auth=Container
type=javax.sql.DataSource
driverClassName=com.attunity.jdbc.NvDriver
url
:
-
From: Caldarale, Charles R chuck.caldar...@unisys.com
Date: Tue, 31 Mar 2009 22:44:32 -0500
To: users@tomcat.apache.org
Subject: RE: Connection Pooling questions
From: allen.ir...@smartintegration.com.au
[mailto:allen.ir...@smartintegration.com.au]
Subject: RE: Connection
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Katilie,
Katilie, John wrote:
| Basically, I have a web application that communicates with Teradata
| under Tomcat using a DBCP pooled connection. In my context.xml file I
| have:
[snip]
| validationQuery=Select 1
[snip]
| Via JNDI we get
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John,
Katilie, John wrote:
| Chris, Thanks for your reply. I'll do some more testing. May i ask a
| dumb question? How did you turn on your tracing to get:
I used the tracing provided by my JDBC driver (Connector/J), so you
won't have this exact
Regards, John Katilie.
-Original Message-
From: Christopher Schultz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 1:16 PM
To: Tomcat Users List
Subject: Re: Connection Pooling and Teradata
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John,
Katilie, John wrote:
| Chris, Thanks
There real unfortunate part with regard to log4j is the actual manual
has to be purchased. The site docs are horribly lacking.
Having said that ... I suspect because the DBCP pool is created by
tomcat in tomcat's internal code, it has a different log factory
instance and as a result, a
From: Christopher Schultz [mailto:[EMAIL PROTECTED]
Subject: Re: Connection Pooling and Teradata
Perhaps it's because DBCP is loaded by TC before my
webapp, so it's using a differently-configured logger.
I believe that's the case - different classloader, different logger. The DBCP
classes
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John,
Christopher Schultz wrote:
| I use log4j, and have it correctly configured to use log4j in my
| application, so I added:
|
| log4j.category.org.apache.tomcat.dbcp=ALL
I followed the instructions on this page
-Original Message-
From: Christopher Schultz [mailto:[EMAIL PROTECTED]
Sent: Wednesday, June 18, 2008 4:05 PM
To: Tomcat Users List
Subject: Re: Connection Pooling and Teradata
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
John,
Christopher Schultz wrote:
| I use log4j, and have it correctly
I haven't looked at the source, but I'm willing to bet there is at least
one sync block -- the pooling implementation would have to perform a
brief sync when it borrows a connection object from the pool. In
addition, if this is from a fresh startup of tomcat without a minIdle
setting
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| No, my test is done with threads that connect using sockets. Server
| listen with ServerSocket and 30 Threads are started connecting to it.
Er... did you write your own server, or are you using Tomcat?
I'm
Hmm. I think the answer here is one of resource starvation - the
resource in this case being the CPU. It seems that core of your test is
'Select * from table1'
Where is the database? Is it another application on the same box? What
mechanism do you use to connect between the database and the
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: Connection pooling again
i think i don't get the utility of a connection pooling,
since i have this situation: 30 threads try to perform at
same time a db access with the call:
Are you running the 30 client requests from a
(mine)?
-- Initial Header ---
From : Caldarale, Charles R [EMAIL PROTECTED]
To : Tomcat Users List users@tomcat.apache.org
Cc :
Date : Wed, 9 Apr 2008 06:18:40 -0500
Subject : RE: Connection pooling again
From: [EMAIL PROTECTED] [mailto:[EMAIL
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| i think i don't get the utility of a connection pooling, since i have
this situation: 30 threads try to perform at same time a db access with
the call:
|
| new Database().doSomething()
Are you sure you're using your
[EMAIL PROTECTED] wrote:
i think i don't get the utility of a connection pooling, since i have this
situation: 30 threads try to perform at same time a db access with the call:
new Database().doSomething()
JNDI lookups are expensive. You should get DataSource object from JNDI
first, and
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Mikolaj,
Mikolaj Rydzewski wrote:
| JNDI lookups are expensive.
No, they're not. We're not talking about using a remote JNDI server or
AD or anything like that. This is all local and the lookups are very fast.
To convince yourself, run this simple
to partecipate... thanks
-- Initial Header ---
From : Christopher Schultz [EMAIL PROTECTED]
To : Tomcat Users List users@tomcat.apache.org
Cc :
Date : Wed, 09 Apr 2008 10:58:58 -0400
Subject : Re: Connection pooling again
-BEGIN PGP SIGNED MESSAGE
Christopher Schultz wrote:
Mikolaj Rydzewski wrote:
| You should get DataSource object from JNDI
| first, and then pass it to other threads. Every thread should just call
| DataSource.getConnection().
That's a bad idea. The reason you store the DataSource in JNDI is so
that it is universally
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| I missed some messages seems.. So is the enqueuing thing a bad
| behaviour of pooling or is it just normal?
I suspect you have a problem with your code, somewhere. Are you creating
a new Database object every time?
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: Re: Connection pooling again
So is the enqueuing thing a bad behaviour of pooling or is it
just normal?
Your queueing problem most likely has nothing to do with the pooling
capability but rather with your app, your database
Your queueing problem most likely has nothing to do with the pooling
capability but rather with your app, your database, or your test driver.
1) If the test driver is browser based (e.g., Java script), you're
limited to two connections to a given server. If your test driver is
using some
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling again
what should i ask to check to the db admin?
Start with: does the db limit the number of connections from a given
client (which in this case, is the box Tomcat is running on)?
How? Should i use
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| I missed some messages seems.. So is the enqueuing thing a bad
| behaviour of pooling or is it just normal?
I suspect you have a problem with your code, somewhere. Are you creating
a new Database object every
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling again
what should i ask to check to the db admin?
Start with: does the db limit the number of connections from a given
client (which in this case, is the box Tomcat is running on)?
Is there a specific
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| i think i don't get the utility of a connection pooling, since i have
this situation: 30 threads try to perform at same time a db access with
the call:
|
| new Database().doSomething()
Are you sure you're
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| No, my test is done with threads that connect using sockets. Server
| listen with ServerSocket and 30 Threads are started connecting to it.
Er... did you write your own server, or are you using Tomcat?
I'm sorry...
-BEGIN PGP SIGNED MESSAGE-
Hash: SHA1
Daad,
[EMAIL PROTECTED] wrote:
| i'm using tomcat 5.5.9 for a web server application where many
| clients connect and do stuffs. each time they login to the server,
| for example, a database query is performed. Application works, but
| reading
|
PROTECTED]
An: Tomcat Users List users@tomcat.apache.org
Betreff: Re: Connection Pooling
thanks Mr Adam Gordon for the reply,
Can u tell me how to determine why oracle is generating those many
processes?
Also tell me where to check the number of oracle processes in use and
how to reduce
I sent him the driver.
-Original Message-
From: Dirk Weigenand [mailto:[EMAIL PROTECTED]
Sent: Wednesday, February 27, 2008 7:16 AM
To: Tomcat Users List
Subject: Re: Connection Pooling
Hi,
you should try to use a dedicated worker process for connections.
Oracle by defaults spawns
Hi, I think you may be confusing the number of allowable processes with
the number of allowable threads.
Per Tomcat's documentation, maxActive refers to the maximum number of DB
connections whereas the Oracle error you are seeing refers to the
maximum number of processes (threads?) which are
nametestWhileIdle/name
valuetrue/value
/parameter
/ResourceParams
-Original Message-
From: Adam Gordon [mailto:[EMAIL PROTECTED]
Sent: Tuesday, February 26, 2008 4:49 PM
To: Tomcat Users List
Subject: Re: Connection Pooling
Hi, I think you may be confusing the number of allowable processes
PM
To: Tomcat Users List
Subject: Re: Connection Pooling
Hi, I think you may be confusing the number of allowable processes with
the number of allowable threads.
Per Tomcat's documentation, maxActive refers to the maximum number of DB
connections whereas the Oracle error you
From: Andrew Hole [mailto:[EMAIL PROTECTED]
Subject: Re: Connection pooling
With the following configuration i get the
error:DatasourceConnectionProvider - Could not find datasource:
java:/comp/env/ehr
Resource name=jdbc/ehr auth=Container
That's because Martin gave you bad information
Every db execution creates a new session.
Each session dropped correctly after db execution.
Is it supposed I see 5 (new) connections to database after tomcat restart?
Thanks
On Jan 11, 2008 2:24 PM, Caldarale, Charles R
[EMAIL PROTECTED] wrote:
From: Andrew Hole [mailto:[EMAIL PROTECTED]
From: Andrew Hole [mailto:[EMAIL PROTECTED]
Subject: Connection pooling
The following configuration was not supposed to be created 5
connections at first get connection execution?
Not quite sure how to parse the above sentence, but the config should
have created five connections at
Hi! Thanks...
With the following configuration i get the
error:DatasourceConnectionProvider - Could not find datasource:
java:/comp/env/ehr
Resource name=jdbc/ehr auth=Container
type=oracle.jdbc.pool.OracleDataSource
factory=oracle.jdbc.pool.OracleDataSourceFactory
Andrew-
The first thing I noticed is your Resource name shoule be jdbc/ehr
replace server_name with the actual server name
replace the SID with the Service ID you will be using (check the
tnsnames.ora for SID)
http://www.microdeveloper.com/html/JNDI_Orcl_Tomcat1p.html
Martin
- Original
Message-
From: Andrew Hole [mailto:[EMAIL PROTECTED]
Sent: Friday, January 11, 2008 8:24 AM
To: Tomcat Users List
Subject: Re: Connection pooling
Hi! Thanks...
With the following configuration i get the
error:DatasourceConnectionProvider - Could not find datasource:
java:/comp/env/ehr
Resource
Caldarale, Charles R wrote:
Looks like the analogous constraint on the docBase attribute has
disappeared from the doc. When docBase is specified and the target is
under the Host appBase directory, the deployment is likely to become
corrupted or occur twice.
I have updated the docs.
Mark
Caldarale, Charles R wrote:
Looks like the analogous constraint on the docBase attribute has
disappeared from the doc. When docBase is specified and the target is
under the Host appBase directory, the deployment is likely to become
corrupted or occur twice.
I have updated the docs.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: Re: Connection pooling, is it the right way to do it?
Which docs?
The ones in SVN. You won't see it on the web site until the next
release is made.
- Chuck
THIS COMMUNICATION MAY CONTAIN CONFIDENTIAL AND/OR OTHERWISE
From: Caldarale, Charles R [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
The ones in SVN. You won't see it on the web site until
the next release is made.
Here's the SVN link:
http://svn.apache.org/repos/asf/tomcat/tc6.0.x/trunk/webapps/docs
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
I'm using Tomcat 5.5.9.
Which is nearly 2.5 years old. Anytime you utilize invalid parameters,
you run the risk of encountering undefined behavior in any level
Sorry I didn't respond earlier -- it's been a busy weekend. Comments
inline...
--David
[EMAIL PROTECTED] wrote:
Hi.
1. Your docBase and path attributes are at best optional. As long as
your context.xml is delivered in your webapp's META-INF folder, it
should be used automagically.
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
at this link
http://www.onjava.com/pub/a/onjava/2006/04/19/database-connect
ion-pooling-with-tomcat.html i see the two parameters, but i
suppose there are correct since
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
I can find the part where doc says that context shouldn't be
put in server.xml but in context.xml, but can't see the part
where docbase and path shouldn't be specified.
http
ok thanks
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
I can find the part where doc says that context shouldn't be
put in server.xml but in context.xml, but can't see the part
where docbase and path shouldn't
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
I can find the part where doc says that context shouldn't be
put in server.xml but in context.xml, but can't see the part
where docbase and path shouldn't be specified
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: Re: Connection pooling, is it the right way to do it?
So context.xml and web.xml are fine?
Not quite - you definitely should remove the path and docBase
attributes. They are not allowed when the Context element is in
META-INF
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: Re: Connection pooling, is it the right way to do it?
So context.xml and web.xml are fine?
Not quite - you definitely should remove the path and docBase
attributes. They are not allowed when the Context element is in
META-INF
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
Ok, once remove those 2 attributes, the rest is fine and good
to be used?
Probably, but you'll have to try it. You never did mention what version
of Tomcat you're using
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
Ok, once remove those 2 attributes, the rest is fine and good
to be used?
Probably, but you'll have to try it. You never did mention what version
of Tomcat you're using
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling, is it the right way to do it?
I'm using Tomcat 5.5.9.
Which is nearly 2.5 years old. Anytime you utilize invalid parameters,
you run the risk of encountering undefined behavior in any level of the
software
Hi.
1. Your docBase and path attributes are at best optional. As long as
your context.xml is delivered in your webapp's META-INF folder, it
should be used automagically.
2. I would trade the autoReconnect=true parameter to the database url
with a validationQuery attribute in the Resource
Add a validationQuery attribute to your Resource ... / definition with
a very basic query like select 1. That'll test your connections on
borrow and re-create them as necessary.
--David
Alper Sarı wrote:
Dear All,
We have configured a portal system on Linux. In our system we uses
-Original Message-
From: Marc Farrow [mailto:[EMAIL PROTECTED]
Sent: Monday, February 19, 2007 3:56 PM
To: tomcat-users
Subject: Connection Pooling Question
Slightly off topic, but the core of what I want is being done in the
source
code of Tomcat. I am trying to use the Apache
With maxWait=1, I believe on pool exhaustion, it'll wait for up to
10 seconds for one to become available. Failing that, I'm not sure.
The request might get a null connection back or an exception. Honestly
I've never looked at the internals of DBCP, but I have done some
programming work on
On JNDI connection problems: We'll need to see more. Specifically the
jsp code calling for the sql connection and the web.xml. A full stack
trace of the error you get would be excellent as well. Lastly, confirm
the mysql jdbc driver is in common/lib of the tomcat directory, not
WEB-INF/lib
1 - 100 of 118 matches
Mail list logo
