Brian,
What is it that you're looking to accomplish with that cast? It makes
it hard for others to respond with suggestions when they don't know
what your criteria are. Also, how does it fail when you try it (ie
ClassCastException)?
Personally, I haven't run into any issues, but I just stick with
Krishnakant Mane wrote:
hello,
I refered to the docs in tomcat 5 for connection
pooling. the document is pritty comprehencive and I
understood the server.xml part of it.
but now I want to know how exactly can I use a
connection from the pool in my servlet.
the example in tomcat documentation is
On Sat, Apr 02, 2005 at 08:21:24PM +0100, Krishnakant Mane wrote:
: the example in tomcat documentation is on a jsp based
: applicatio. but I don't understand how I use a pooled
: connection in a servlet.
: [snip]
: should I initialise the connection in the Init method?
: how and when should I
Hi,
Please follow the directions by user rmorriso on the following link.
It should work fine.
http://forums.devshed.com/archive/t-120081
On Fri, 25 Mar 2005 19:11:15 + (GMT), Krishnakant Mane
[EMAIL PROTECTED] wrote:
hello all,
im going to put a web application in java servlets
with
Hi
All the connection pool properties should be configured in server.xml. You
dont have to initialize connections etc. in your init method. you just have
to make sure you close your resultset and connection after you are done.
Closing it will return it back to the pool.
Here is one link from
On Thu, Mar 10, 2005 at 10:31:41AM -0800, Mark Winslow wrote:
: Hi, I have a sort of theoretical question. I'm
: wondering about the pros and cons of using a one
: connection per tomcat session strategy for connecting
: to a Postgresql server rather than connection pooling.
The great benefit of
OK, I see your points and they are well taken. A lot
of my concern has to do with this
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/printer/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
There is one problem with connection pooling. A web
On Thu, Mar 10, 2005 at 12:30:22PM -0800, Mark Winslow wrote:
:
http://jakarta.apache.org/tomcat/tomcat-5.5-doc/printer/jndi-datasource-examples-howto.html#Database%20Connection%20Pool%20(DBCP)%20Configurations
:
: There is one problem with connection pooling. A web
: application has to
I'm still not entirely sure about this issue. The
close/=null + finally blocks make for pretty ugly and
error prone code if you ask me.
Why doesn't the connection pool encapsulate closing
anyway? Can't it encapsulate closing into the
finalize() methods? Are there ordering issues for
closing
On Thu, Mar 10, 2005 at 10:31:41AM -0800, Mark Winslow wrote:
2. Have better control of connection releases via the
finalize() method in a session helper class that
contains the one single connection.
I hope you meant finally clause rather than finalize() method. A
finalize() method is
if ever.??? Is that really the case? My personal
experience with Tomcat is that it does indeed have
memory leak problems. In theory, shouldn't all
objects created in a web user session eventually be
garbage collected after the session ends?
I in fact did mean the finalize() method. Is that the
From: Mark Winslow [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling verse one connection per session
if ever.??? Is that really the case? My personal
experience with Tomcat is that it does indeed have
memory leak problems.
Nearly all the memory leaks I've seen have been
On Thu, Mar 10, 2005 at 01:52:02PM -0800, Mark Winslow wrote:
: I'm still not entirely sure about this issue. The
: close/=null + finally blocks make for pretty ugly and
: error prone code if you ask me.
Well, certainly no one's forcing you to code that way. It's just a
fairly standard
I don't know. I have one pure Tomcat (no Apache)
server that all it does is serve about 300,000 static
files per day. The memory usage grows and grows
unexplicably. I run a cron job that restarts it
everyday, which I had to started running with version
5.0.something or else it would eventually
Sorry, just had one other question about the use of
static variables. Can this really be a problem? I
thought that a static variable only gets a single copy
per JVM/Context. For instance the use of static
variables to define formats shouls save on memory
usage shouldn't it?
public class Helper
From: Mark Winslow [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling verse one connection per session
The memory usage grows and grows unexplicably.
Modern JVMs also try to avoid doing GC if they can. So, if you've given the
JVM a large amount of memory, it will use it all before
From: Mark Winslow [mailto:[EMAIL PROTECTED]
Subject: RE: Connection pooling verse one connection per session
Sorry, just had one other question about the use of
static variables. Can this really be a problem? I
thought that a static variable only gets a single copy
per JVM/Context
Everything you did with the driver,server.xml,web.xml is ok.
But it sounds like your driver of sql server 2000 doesnt support
connection pooling ...
did you tried to connect without the connection pool?
i also recommend going to tomcat 5... i had a couple of issues with
connection pooling in
!
-Original Message-
From: Friedrich Gonzalez [mailto:[EMAIL PROTECTED]
Sent: Thursday, January 06, 2005 6:10 AM
To: Tomcat Users List
Subject: Re: Connection Pooling with Tomcat 4.1 and SQL Server 2000
Everything you did with the driver,server.xml,web.xml is ok.
But it sounds like your driver
: Re: connection pooling
Date: Thu, 16 Dec 2004 16:13:03 -0600
depends on what connection pool you use. but in almost all causes, its a
pretty trivial thing (unless your code is funky of course)
in our system, all we did was to switch the driver name (to the pooled
driver), and it would pick up our
depends on what connection pool you use. but in almost all causes, its a pretty
trivial thing (unless your code is funky of course)
in our system, all we did was to switch the driver name (to the pooled driver),
and it would pick up our connection pool.
so it was a one line change.
Filip
-
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: Friday 05 November 2004 18:34
To: Steve Kirk
Cc: Tomcat Users List
Subject: Re: connection pooling
Steve, I am trying to use DBCP(hence the subject of the thread) and I
believe I have a driver that supports
Kirk
Cc: Tomcat Users List
Subject: Re: connection pooling
Steve, I am trying to use DBCP(hence the subject of the thread) and I
believe I have a driver that supports it. Especially considering that
the connection works when I wrap my data resource in a DefaultContext
tag inside
What escapes me is, why is this not more obviously documented?
Perhaps it's in the Tomcat docs but I mostly abandoned those some time
ago as they are so amazingly detailed and lengthy that unless you want
to become a TC guru, which I am inspired to try and be more like,
there is simply too
: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are
reported
via stack trace as I posted in response to Atishay's suggestion that I
add
this. I'll try
your problem might be the
driver. Where did you drop off your informix jdbc jar?
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different
to do connection pooling. In other words you don't need to set any Resource
or Context to get it to work.
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: Friday 05 November 2004 05:57
To: Tomcat Users List; Atishay Kumar
Subject: Re: connection pooling
Thx
Hi,
Eric - you are correct, you do not need both resource-ref and
Resource
That's only because we try to accommodate less able
developers/administrators. You DO need resource-ref if you want your
app to be compliant with the Servlet Specification and portable to other
containers.
Yoav
[mailto:[EMAIL PROTECTED]
Sent: Friday 05 November 2004 13:32
To: Tomcat Users List
Subject: RE: connection pooling
Hi,
Eric - you are correct, you do not need both resource-ref and
Resource
That's only because we try to accommodate less able
developers/administrators. You DO need
is for the manager webapp.
-Original Message-
From: Nick Pellow [mailto:[EMAIL PROTECTED]
Sent: Friday 05 November 2004 07:40
To: Tomcat Users List
Subject: AW: {an alternative}Re: connection pooling
HI Eric,
I have seen the same error your are getting. I am using tomcat 5.0.28
.
-Ursprungliche Nachricht-
Von: Eric Wulff [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 5. November 2004 07:35
An: Atishay Kumar
Cc: Tomcat Users List
Betreff: Re: {an alternative}Re: connection pooling
Atishay, the DefaultContext does work once I
comment out the other
Engine element. You
7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now
different errors are reported
via stack trace as I posted in response to
Atishay's suggestion that I add
this. I'll try adding your
An: Atishay Kumar
Cc: Tomcat Users List
Betreff: Re: {an alternative}Re: connection pooling
Atishay, the DefaultContext does work once I comment out the other
Engine element. You mentioned that means something is wrong with my
Context? So what next?
many thx
Eric
On Thu, 4 Nov
that many params. I think your problem might be the
driver. Where did you drop off your informix jdbc jar?
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes
that many params. I think your problem might be the
driver. Where did you drop off your informix jdbc jar?
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are reported
via stack trace as I posted in response to Atishay's suggestion that I add
]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are reported
via stack trace as I posted in response to Atishay's suggestion that I add
this. I'll try adding your
[mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are reported
via stack trace as I posted in response to Atishay's suggestion that I add
this. I'll
informix jdbc jar?
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are reported
and make sure that they do not define a context with path=/wms.
Cheers,
nick.
-Ursprungliche Nachricht-
Von: Eric Wulff [mailto:[EMAIL PROTECTED]
Gesendet: Freitag, 5. November 2004 07:35
An: Atishay Kumar
Cc: Tomcat Users List
Betreff: Re: {an alternative}Re: connection pooling
Atishay
link, and it should work.
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday 13 October 2004 15:26
To: Tomcat Users List
Subject: RE: Connection Pooling using JNDI DataSource
Hi,
Yeah, it works. Note that your choice of words is a bit
misleading
I guess the issue is with compilation or JNI.
-Original Message-
From: Marot Laurent [mailto:[EMAIL PROTECTED]
Sent: October 15, 2004 5:13 AM
To: Tomcat Users List
Subject: RE: Connection Pooling using JNDI DataSource
uh ...
it works fine from our side. But as i saw so many posts
Hi,
Yeah, it works. Note that your choice of words is a bit misleading: you
don't configure anything in web.xml, you only declare a resource
reference there. The declaration and configuration of the resource
itself is all in server.xml.
Yoav Shapira http://www.yoavshapira.com
-Original
.
-Original Message-
From: Shapira, Yoav [mailto:[EMAIL PROTECTED]
Sent: Wednesday 13 October 2004 15:26
To: Tomcat Users List
Subject: RE: Connection Pooling using JNDI DataSource
Hi,
Yeah, it works. Note that your choice of words is a bit
misleading: you
don't configure anything
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have added Resource name=... . Now different errors are reported
via stack trace as I posted in response to Atishay's suggestion that I add
this. I'll try adding your suggestions and see what happens. Also, you
suggest adding many
Detail, detail, detail.
1. your context.xml
2. your web.xml
3. how do you obtain connection from pool, java code pls.
4. can you connect using pool
5. commons-pool version
Etc. etc.
You need to provide details otherwise we can't help.
-Original Message-
From: Eric Wulff [mailto:[EMAIL
On Wed, 6 Oct 2004 14:37:58 -0700, Eric Wulff [EMAIL PROTECTED] wrote:
I have gone over some of the tomcat docs and googled errors
but there is SO much information covering JNDI, connection pooling,
and Datasources. Can someone review the info below and consult or
point me in the right
Hi Phillip,
On Thu, 7 Oct 2004 09:29:09 -0400, you wrote:
Detail, detail, detail.
1. your context.xml
2. your web.xml
3. how do you obtain connection from pool, java code pls.
4. can you connect using pool
5. commons-pool version
Etc. etc.
You need to provide details otherwise we
Hi Atishay, added your suggestion to the server.xml. While it is not
the fix, I do have a different error listing. Is this a clue to you?
Eric
current last listing of stack trace...
Caused by: java.lang.NullPointerException at
com.informix.jdbc.IfxDriver.checkURL(IfxDriver.java:473) at
To: Tomcat Users List
Subject: Re: connection pooling
Hi Phillip,
On Thu, 7 Oct 2004 09:29:09 -0400, you wrote:
Detail, detail, detail.
1. your context.xml
2. your web.xml
3. how do you obtain connection from pool, java code pls.
4. can you connect using pool
5. commons-pool version
Etc. etc
: October 7, 2004 4:34 PM
To: Tomcat Users List
Subject: Re: connection pooling
Hi Phillip,
On Thu, 7 Oct 2004 09:29:09 -0400, you wrote:
Detail, detail, detail.
1. your context.xml
2. your web.xml
3. how do you obtain connection from pool, java code pls.
4. can you connect using pool
No, you don't need that many params. I think your problem might be the
driver. Where did you drop off your informix jdbc jar?
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 5:56 PM
To: Tomcat Users List
Subject: Re: connection pooling
Yes, I have
);
...
-Original Message-
From: Eric Wulff [mailto:[EMAIL PROTECTED]
Sent: October 7, 2004 4:34 PM
To: Tomcat Users List
Subject: Re: connection pooling
Hi Phillip,
On Thu, 7 Oct 2004 09:29:09 -0400, you wrote:
Detail, detail, detail.
1. your context.xml
java code:
Context ctx = (Context) init.lookup(xx);
server.xml:
ResourceParams name=xx
web.xml:
resource-ref
res-ref-namexx/res-ref-name
res-typejavax.sql.DataSource/res-type
res-authContainer/res-auth
/resource-ref
The entries I've labelled 'xx' should all be the same.
Please ignore my last post - it's wrong.
(Answered before verifying).
John Thompson
|-+
| | Eric Wulff |
| | [EMAIL PROTECTED]|
| | |
| ||
|
parameter
nameurl/name
valuejdbc:informix-sqli://url:port/dbName:INFORMIXSERVER=serverName/value
/parameter
Is that litterally what you have in your server.xml?
-
To unsubscribe, e-mail: [EMAIL
No, literally I have the actual values. The same connection string I
use to successfully
connect via JDBC using DriverMangager.getConnection() minus the user
and passoword.
Eric
On Thu, 7 Oct 2004 11:04:22 +1300, [EMAIL PROTECTED]
[EMAIL PROTECTED] wrote:
parameter
nameurl/name
Is there a x.xml file in (TOMCAT_HOME)/conf/Catalina/localhost, where
xx is the context name? (this is an independent context configuration
that may have been created independently when you first deployed your
application on Tomcat).
If so, either delete it, or move your data source
Context name? I assume your referring to the ResourceParams name
attribute, jdbc/test_connect in this case, from the Context
declaration in my server.xml. So, I'd be looking for a
test_connect.xml. There are NO .xml files in the
TOMCAT_HOME/conf/Catalina/localhost with this name or any name
I am using these parameters : for Connection pooling... in Tomcat 4.1
maxActive :20
maxIdle :10
mxWait :1
removeAbandoned :true
My application makes 5 queries to the database at one time, so it calls
datasource.getConnection 5 times and closes connection 5 times..
When i run this application
Hi,
One pool = one database. It's not a Tomcat limitation per se, it's a
limitation of the connection pool implementation (I'm guessing you use
DBCP), which in turn comes from the way javax.sql is designed.
However, you can define as many pools as you want in Tomcat, so just
define one for each
Frans
I use dbcp to pool two different databases on different servers. A mysql
on localhost and an Oracle on a remote host. I have never had a
problem.
I define my pools in my webapp.xml so they are specifically restricted
to the app that uses them. I would examine your dataSourceName and
Hello Doug
1- My ROOt.xml doesn't have any error.That problem caused by wrong copy and paste.
2- I changed the order of Parameters in Resource tag but wasn't useful.
3- Look, I don't see any error message.When I check the number of connection in
Mysqladmin, in 4.1.18 the number of
Is this a direct cut and paste? If yes you are missing a at the end of the
Logger. Otherwise watch the order of the elements in the Resource. It can
make a difference in some cases.
What are the errors?
What does the web.xml look like?
Doug
www.parsonstechnical.com
- Original Message
I can't remember the specifics off hand, but...
There is a mechanism in DBCP that allows you to check a connection with
a validationQuery (use this term when googling for it!) that can be run
a) every now and then on an idle connection (very useful if a firewall
sits in the middle)
b) before
Hi,
Why auth=SERVLET and not CONTAINER if you're supplying the
username/password in server.xml?
Did you search the list archives about this topic before posting?
Yoav Shapira
Millennium Research Informatics
-Original Message-
From: prasad chaturvedula [mailto:[EMAIL PROTECTED]
Sent:
-
From: James Neville [mailto:[EMAIL PROTECTED]
Sent: Wednesday, January 07, 2004 11:51 AM
To: Tomcat Users List
Subject: Re: Connection Pooling
Justin,
That would all depend on the pooling implementation you're using.
Commonly, its pool.free(conn) or pool.freeConnection(conn).
Remember *not* to close
I believe when you close the connection, which should be added in a
finally block eg.
} finally {
try {
oConn.close();
} catch (Exception ex) {
// Can't recovery gracefully,
Justin,
That would all depend on the pooling implementation you're using.
Commonly, its pool.free(conn) or pool.freeConnection(conn).
Remember *not* to close the connection if you're using connection
pooling, as this should be handled by the pool itself.
That said one of my colleagues
Usually every databse has its own ConnectionPool implementation.
--
De: James Neville[SMTP:[EMAIL PROTECTED]
Responder:Tomcat Users List
Enviada: quarta-feira, 7 de janeiro de 2004 13:50
Para: Tomcat Users List
Assunto: Re: Connection Pooling
I have tried this and ended up using the DBCP package that comes with Tomcat
4.1. It is not part of Tomcat 4.1 thought so you can download it separately
and use it with Tomcat 4.0.4 or later (I hope you have these). Tyrex is not
the most useful of things and is major hassle to get working.
You
: Andoni [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 5:27 PM
To: Tomcat Users List
Subject: Re: Connection Pooling in Tomcat 4.0
I have tried this and ended up using the DBCP package that comes with Tomcat
4.1. It is not part of Tomcat 4.1 thought so you can download it separately
other suggestion regarding using CONNECTION POOLING WITH TOMCAT 4.0 is highly
welcome
-Santosh
-Original Message-
From: Andoni [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 5:27 PM
To: Tomcat Users List
Subject: Re: Connection Pooling in Tomcat 4.0
I have tried
pooling.
Best regards Thomas
[EMAIL PROTECTED]
16-09-03 14:13
Besvar venligst til Tomcat Users List
Til:[EMAIL PROTECTED]
cc: [EMAIL PROTECTED]
Vedr.: RE: Connection Pooling in Tomcat 4.0
Hi andoni,
First of all thanks for reply.
Because you have already done
for a willing heart.
-Original Message-
From: Thomas Nybro Bolding [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 5:47 PM
To: Tomcat Users List
Subject: Vedr.: RE: Connection Pooling in Tomcat 4.0
Hi santosh.
I have been using DBConnectionBroker from http
second answer is YES - it is written and distributed under Open
Source License.
/Thomas
[EMAIL PROTECTED]
16-09-03 14:42
Til:[EMAIL PROTECTED]
cc: Thomas Nybro Bolding/THBO/Intranet/[EMAIL PROTECTED]
Vedr.: RE: Vedr.: RE: Connection Pooling in Tomcat 4.0
.
-Original Message-
From: Thomas Nybro Bolding [mailto:[EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 6:33 PM
To: Santosh Bhushan-OP
Cc: [EMAIL PROTECTED]
Subject: Vedr.: RE: Vedr.: RE: Connection Pooling in Tomcat 4.0
The way I have done it (though this might not be the best
look at the docs
- Original Message -
From: [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Sent: Tuesday, September 16, 2003 9:06 PM
Subject: Connection Pooling
Hi All,
Can anybody send me the configuration for DBCP Connection pooling with
TOmcat 4.0
Regards,
Santosh Bhushan
i-flex solutions
Gregg Bolinger wrote:
I am trying to get connection pooling working with Tomcat 4.1.24-LE.
Below is some relevant code. Tomcat starts up just fine. I have all my
JAR files I need in the right place. If I create my own connection
using JDBC it all works just fine. But using a connection
: Monday, August 04, 2003 12:40 PM
To: Tomcat Users List
Subject: Re: Connection Pooling HELP
Gregg Bolinger wrote:
I am trying to get connection pooling working with Tomcat 4.1.24-LE.
Below is some relevant code. Tomcat starts up just fine. I have all
my
JAR files I need in the right place
Tomcats docs don't mention the fact that you need
to download them. G!
Gregg
-Original Message-
From: Gregg Bolinger [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 12:45 PM
To: 'Tomcat Users List'; 'Tomcat Users List'
Subject: RE: Connection Pooling HELP
You might be right. I
Simple solution, don't use the LE version. Use the full version. Your
problems will disappear.
-Original Message-
From: Gregg Bolinger [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 2:07 PM
To: 'Tomcat Users List'
Subject: RE: Connection Pooling HELP
I found out you
should get.
But thanks for the heads-up. ;)
Gregg
-Original Message-
From: Angus Mezick [mailto:[EMAIL PROTECTED]
Sent: Monday, August 04, 2003 1:18 PM
To: Tomcat Users List
Subject: RE: Connection Pooling HELP
Simple solution, don't use the LE version. Use the full version. Your
problems
Ok, got that resolved. I just had the element order in my web.xml file
wrong. Of course now I am getting this error:
cannot create resource instance
So I am off to research that.
Gregg
-Original Message-
From: Gregg Bolinger [mailto:[EMAIL PROTECTED]
Sent: Saturday, August 02, 2003
Bill2 wrote:
I am using Tomcat 4.0.4, MySQL Max 3.23.51 on Linux 7.2 and
mysql-connector-java-3.0.8-stable-bin.jar. I got it to work in my
development environment NetBeans 3.5, but when I put it on the
production server by changing the server.xml file as instructed at:
I had a problem like this. I had an application that didn't use connection
pooling and i was converting it over.
In Windows is used the netstat command with the auto repeat option. It
shows all of the active network connections
and i watched the list et shorter as components where switched
Are you trying to see the (total connections available -- total connections
used) info?
-Original Message-
From: Christopher Prince [mailto:[EMAIL PROTECTED]
Sent: Wednesday, July 02, 2003 10:54 AM
To: Tomcat Users List
Subject: Re: connection pooling - how to verify it's in use
I had
Gregory, Carlton wrote:
Are you trying to see the (total connections available -- total connections
used) info?
No. All I want to do is be able to show someone that connection pooling
is indeed being used, rather than what we've been using to connect to a
database. I can have a message
Nope :( (It's on my wish list too)
But DBCP is used as the connection pooling machanism. So when you get your
datasource - just cast it the the appropriate DBCP class and get your stats.
http://jakarta.apache.org/commons/dbcp/
-Tim
Geralyn M Hollerman wrote:
I have a question about
PM
To: Tomcat Users List
Subject: RE: connection pooling
Howdy,
Thanks, but do you know what is abandoned connection? As I understand
it,
abandoned connection is the one that has not been used in some time but
it
still could be a live connection. I need to go through all the
connections
Howdy,
Tomcat uses DBCP by default for connection pooling, although you can use
other packages as well. DBCP supports evicting idle connections with a
configurable timeout on how long the connection must be idle before
eviction. DBCP also supports configurable validation queries (checking
for
Subject: RE: connection pooling
Howdy,
Tomcat uses DBCP by default for connection pooling, although you can use
other packages as well. DBCP supports evicting idle connections with a
configurable timeout on how long the connection must be idle before
eviction. DBCP also supports configurable
Howdy,
Thanks, but do you know what is abandoned connection? As I understand
it,
abandoned connection is the one that has not been used in some time but
it
still could be a live connection. I need to go through all the
connections
in the pool and check if every connection is a valid, live
who needs foreign keys, they only slow your DB down anyway :)
DBCP can support any DB, you will need an ODBC bridge for Access, then you
just give DBCP the odbc bridge driver info, and it should work
Filip
-Original Message-
From: JS [mailto:[EMAIL PROTECTED]
Sent: Monday, March 31,
Uh, you don't want to use the Access with Java, at least not unless you
mind rebooting your server on a regular basis. The JDBC-ODBC bridge has
a memory leak.
And besides I've been hearing that even Microsoft isn't doing anything
with Access (using SQL Server run-time instead). Also that it
5:43 PM
To: Tomcat Users List; [EMAIL PROTECTED]
Subject: RE: connection pooling saga
who needs foreign keys, they only slow your DB down anyway :)
DBCP can support any DB, you will need an ODBC bridge for Access, then you
just give DBCP the odbc bridge driver info, and it should work
Filip
Cheers Filip,
I didnt realise that DBCP would suppport Access.
(1) Doesnt the driver need to be a jar file though??
(2) I thought I needed an actual JDBC driver for MS Access.
(3) Does the DBCP support for MS Access Connection Pooling mean that I no
longer need my ConnectionPoolServlets to
Take a look under JNDI DataSource and JNDI Resources links on the left hand
side of this page:
http://jakarta.apache.org/tomcat/tomcat-4.1-doc/index.html
Chris Yocum
From: Lars Nielsen Lind [EMAIL PROTECTED]
Reply-To: Tomcat Users List [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL
I have DBCP connection pooling working as follows using Tomcat 4.1.12:
Under the Context element for your application (this can either be in the
server.xml file or a separate xml file in the webapps dir) I have the
following config:
Resource name=jdbc/ scope=Shareable
Thinks He Knows What He Is Doing
-Original Message-
From: Malcolm Green [mailto:[EMAIL PROTECTED]
Sent: February 25, 2003 5:36 AM
To: 'Tomcat Users List'
Subject: RE: Connection Pooling
I have DBCP connection pooling working as follows using Tomcat 4.1.12:
Under the Context element for your
1 - 100 of 201 matches
Mail list logo