Start a new discussion thread instead of hijacking this one.
And if you do that: give more information. What have you done so far?
have you read the documentation? What are the error messages, if you
already at that point? etc. etc.
Sridhar wrote:
Can anyone help how to create Connection
hi,
u have to close the connection, sothat container puts it back in the pool .
as u set maxActive=100 at max only 100 connections will be
maintained in pool and as u r not closing the connection, u would have
ran out of all the connections available in pool (ie 100)
closing the connection should
If you arent closing connections, then exhausting the connection pool
is the expected, eventual result.
Read the document at
http://jakarta.apache.org/tomcat/tomcat-5.0-doc/jndi-datasource-examples-howto.html,
paying special attention to the example of properly written code
[using] a db
Tony Smith wrote:
I am runing tomcat 5.0 + postgresql. I set my
connection pool in server.xml as:
Resource
name=jdbc/mysource
type=javax.sql.DataSource
password=
driverClassName=org.postgresql.Driver
maxIdle=100
maxWait=5000
validationQuery=select *
should this be: CONCUR_UPDATEABLE?
Sapales wrote:
Hi:
I´m working with Tomcat4 and a Connection Pool for accesing MySQL. But,
when I use the following code in a jsp:
%@ page import =java.sql.*, javax.sql.* %
%@ page import =javax.naming.InitialContext, javax.naming.Context %
htmlbody
%
I use the logAbandonded in our test server, and I find the log messages in
catalina.out. The log message includes (as part of a stack trace, so you
will have to inspect the output a bit) the JSP page or class (and line!) in
which the connection was opened.
Here's an example:
DBCP object created
Geachte relatie,
Het door u gebruikte e-mailadres is niet meer actief. U kunt uw e-mailbericht
sturen naar [EMAIL PROTECTED] of dit bericht beantwoorden.
Bedankt voor uw medewerking,
Met vriendelijke groet,
ATP Hypotheken
Het Spoor 40
3994 AK Houten
Tel. 030 750 25 33
Fax. 030 750 25 88
On Wed, Aug 25, 2004 at 03:40:58PM +0200, Philippe Mathieu wrote:
: For me a correct war is a war where you don't have to touch to any pages to
: deploy the application. I think everybody is according to this.
So far, so good.
: - the database/user/password must be defined in the context
Hi,
Note that Tomcat 5.0.27 already ships with DBCP 1.2.1. As for database
drivers, your advice is good in general (and has nothing specifically to
do with Tomcat or DBCP) and people should follow it.
Yoav Shapira
Millennium Research Informatics
-Original Message-
From: Steve Summit
try putting the jstl.jar and standard.jar into WEB-INF/lib
they're usually in jsp-examples/WEB-INF/lib
- Original Message -
From: Lee Chin Khiong [EMAIL PROTECTED]
To: Tomcat Users List (E-mail) [EMAIL PROTECTED]
Sent: Friday, July 30, 2004 1:31 AM
Subject: connection pool docu
Is
for more than just Oracle, try SELECT 1
-Original Message-
From: V D [mailto:[EMAIL PROTECTED]
Sent: Saturday, July 17, 2004 7:33 AM
To: Tomcat Users List
Subject: Re: Connection pool detecting bad connection
Thank you very much for the information. I wonder what
Thank you very much for the information. I wonder what is the
implication of this in term of performance. This effectively double the
number of query if my query is small and one for each request to have a
connection handle (but under very heavy load). Also, what's a generic
way for doing
Configure your connection pool to use the 'Test On Borrow' feature.
This will send a small query out to make user the connection is
available before it uses the connection for the larger query. Your
query could be like SELECT 'test' from dual if you are on Oracle.
Hope this helps
Michael
It looks like you are not returning the connection in a propper way.
I mean just to close the resultset is not enough.
I use another connection pool, but I also get this kind of exception.
You have to obtain the statement form the resultset.
The connection from the statement.
Then close the
Hello,
I'd like to know how to implement connection pooling in my
application.
This is what I had done so far. Pls let me know what I need to change
to use the pooling mechanism.
1. I created a singleton class: DatabaseOperations.
2. It has an Connection instance: conn.
3. During
Hi,
Hello,
I'd like to know how to implement connection pooling in my
application.
This is what I had done so far. Pls let me know what I need to change
to use the pooling mechanism.
1. I created a singleton class: DatabaseOperations.
2. It has an Connection instance: conn.
3. During
On Fri, 2004-04-02 at 13:47, Kal Govindu wrote:
I'd like to know how to implement connection pooling in my
application.
This is what I had done so far. Pls let me know what I need to change
you don't have to write any database pooling functions, it comes built
in!
Hi Kal,
Thank you... your getConnection() and releaseConnection() also very
helpful.
Will implement and test them...
--Kawthar
[EMAIL PROTECTED] 02/04/2004 08:47:43 PM
Hi,
Hello,
I'd like to know how to implement connection pooling in my
application.
This is what I had done so far. Pls
resort if it fails normally. There is something leaving the connection
hanging.
Doug
- Original Message - From: Gordon Luk
[EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 2:31 AM
Subject: Re: Connection Pool setup.
Hi Doug,
O, thanks, it's
- Original Message -
From: Gordon Luk [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 2:31 AM
Subject: Re: Connection Pool setup.
Hi Doug,
O, thanks, it's work... BTW, thanks for remind, and i am the good
citizen, allway return connection
Hi,
Yeah, call your DBA and ask him to allow more concurrent connections to
your DB.
Yoav Shapira
Millennium Research Informatics
-Original Message-
From: Salvatierra, Mauricio h (M.H.) [mailto:[EMAIL PROTECTED]
Sent: Friday, March 26, 2004 1:07 PM
To: 'Tomcat Users List'
Subject:
.
Doug
- Original Message -
From: Gordon Luk [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 11:18 PM
Subject: RE: Connection Pool setup.
Here my setting...
My problem is ... Connection pool look like don't open 10 connection
the connection
hanging.
Doug
- Original Message - From: Gordon Luk [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 2:31 AM
Subject: Re: Connection Pool setup.
Hi Doug,
O, thanks, it's work... BTW, thanks for remind, and i am the good
citizen
May help if you post your resource snipplet (replacing any host /user/passwd info)
-Original Message-
From: Gordon Luk [mailto:[EMAIL PROTECTED]
Sent: Thu Mar 25 05:30:56 2004
To: Tomcat Users List
Subject:Connection Pool setup.
Hi All,
May be I missing understand
That easy,
look at the DBCP Documentation
http://jakarta.apache.org/commons/dbcp/configuration.html
and used the following
Resource name=jdbc/EmployeeDatabase auth=Container
type=javax.sql.DataSource /
ResourceParams name=jdbc/EmployeeDatabase
Sounds like a leak in you program. Check to make sure the connection,
resultset and statement are being closed.
A work around is to add:
parameter
nameremoveAbandoned/name
valuetrue/value
/parameter
parameter
nameremoveAbandonedTimeout/name
Armalai,
This is some of the parameters I noted you didn't have, BUT,
they are from the Tomcat 5, so check the docs. Just by looking at the
verbiage of the tags, they look like they might be helpful.
Tom Kochanowicz
!-- Maximum number of idle dB connections to retain in pool.
Regards,
Gordon Luk
-Original Message-
From: D'Alessandro, Arthur [mailto:[EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 7:03 PM
To: Tomcat Users List; Tomcat Users List
Subject: RE: Connection Pool setup.
May help if you post your resource snipplet (replacing any host
/user/passwd info
to the min then you have a leak in you app.
Check that connections, resultsets and statements are all closed.
Doug
- Original Message -
From: Gordon Luk [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 11:18 PM
Subject: RE: Connection Pool setup
Message -
From: Gordon Luk [EMAIL PROTECTED]
To: 'Tomcat Users List' [EMAIL PROTECTED]
Sent: Thursday, March 25, 2004 11:18 PM
Subject: RE: Connection Pool setup.
Here my setting...
My problem is ... Connection pool look like don't open 10 connection at
start-up, and when my servlet run
the connection
hanging.
Doug
- Original Message -
From: Gordon Luk [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Friday, March 26, 2004 2:31 AM
Subject: Re: Connection Pool setup.
Hi Doug,
O, thanks, it's work... BTW, thanks for remind, and i am the good
citizen, allway
Did you check the logs for abandoned ones? I was able to successfully
trace unclosed Oracle connections with the help of db-commons auto
logging feature. But first you have to make sure all your API is using
jdbc/theDB resource to open connections.
-Original Message-
From: Allistair
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Rick Roberts [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:21 AM
To: Tomcat Users List
Subject: Re: Connection Pool / Connection Bean ?
Possibly. Can you point me to it, so I can read up on it?
I have some old
Howdy,
You mean a connection pool like DBCP?
Yoav Shapira
Millennium ChemInformatics
-Original Message-
From: Rick Roberts [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 10, 2003 3:52 PM
To: Tomcat Users List
Subject: Connection Pool / Connection Bean ?
Is there a good, free
-
From: Rick Roberts [mailto:[EMAIL PROTECTED]
Sent: Monday, August 11, 2003 9:21 AM
To: Tomcat Users List
Subject: Re: Connection Pool / Connection Bean ?
Possibly. Can you point me to it, so I can read up on it?
I have some old JDBC apps, originally written under Tomcat 3.1 or 3.2.
I'm
Possibly. Can you point me to it, so I can read up on it?
I have some old JDBC apps, originally written under Tomcat 3.1 or 3.2.
I'm looking for a relatively painless way to modernize my JDBC connection
techniques.
Thanks
--
***
* Rick Roberts
Didn't know you were going to start a new thread.. see my question under
the previous one. The DataSource in your code is NOT the pool.
-Original Message-
From: Hans Wichman [mailto:[EMAIL PROTECTED]
Sent: Monday, July 28, 2003 9:45 AM
To: [EMAIL PROTECTED]
Subject: connection pool
I am sorry, I thought I was out of luck on that one ;-(, let's kill this
thread, I have replied to your other post.
Thanks !
At 09:47 AM 7/28/2003 -0500, Mike Curwen wrote:
Didn't know you were going to start a new thread.. see my question under
the previous one. The DataSource in your code is
I've seen this same issue and I'm interested in a solution as well.
Thanks,
Matt
-Original Message-
From: Salina Cheung [mailto:[EMAIL PROTECTED]
Sent: Friday, March 28, 2003 9:00 AM
To: [EMAIL PROTECTED]
Subject: connection pool
Hi,
When tomcat reloads class files, it
Hi,
Try using the GlobalNamingResource element instead of the Context element, then put a
ResourceLink to that resource in each Host element.
If the resource is defined in either Context or GlobalNamingResource in server.xml ,
there is no need to include any reference to it in web.xml as a
what db are you using? I know in MySQL you can simple do a query such
as:
show processlist
in the mysql client. You can see all the connections that are currently
active. Of course this wont tell you which ones are in use, but you can
kinda figure that out by the amount of time that the thread as
Here is what i have in server.xml in the context of my app
Resource name=jdbc/postgresql auth=Container
type=javax.sql.DataSource/
ResourceParams name=jdbc/postgresql
parameter
namefactory/name
On Fri, 6 Dec 2002, Dionisio Ruiz de Zarate wrote:
Date: Fri, 6 Dec 2002 23:11:37 +0100
From: Dionisio Ruiz de Zarate [EMAIL PROTECTED]
Reply-To: Tomcat Users List [EMAIL PROTECTED]
To: [EMAIL PROTECTED]
Subject: connection pool to postgresql
Hello can anybody help me to configure one
Send us the code of the DBQuery.java. (The shorter the
better)
--- Michael Nicholson [EMAIL PROTECTED] wrote:
I'm building a webapp, and I want to use connection
pooling with it. In order to play around some, I
made a dummy webapp that does virtually nothing, but
uses the connection pool.
The Code of DBQuery follows: Remember, in one webapp, it works fine, in
another, it gives a class cast exception at the ***'d line
begin code snippet
/*
* DBQuery.java
*
* Created on November 5, 2002, 10:14 AM
*/
package DBCPTestClasses;
import java.sql.*;
import javax.naming.*;
I'm running it through Forte/SunOneStudio, which is built on netbeans (I
think). Does that make a difference?
- Original Message -
From: Kwok Peng Tuck [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 8:03 PM
Subject: Re: Connection pool
Users List
[EMAIL PROTECTED]
[EMAIL PROTECTED]cc:
u Subject: Re: Connection pool question
, which is
built on netbeans (I
think). Does that make a difference?
- Original Message -
From: Kwok Peng Tuck [EMAIL PROTECTED]
To: Tomcat Users List
[EMAIL PROTECTED]
Sent: Tuesday, November 05, 2002 8:03 PM
Subject: Re: Connection pool question:
Are you running
for the help.
Mike
- Original Message -
From: [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Wednesday, November 06, 2002 9:34 AM
Subject: Re: Connection pool question:
What are the differences between the jar files that you have in each
/WEB-INF/lib folder ?
Judging
Are you running the tomcat which is built into Netbeans ?
Michael Nicholson wrote:
I'm building a webapp, and I want to use connection pooling with it. In order to play around some, I made a dummy webapp that does virtually nothing, but uses the connection pool. So then I cut and pasted some
Please include your errors when you post a question like that. They are
several solutions, and without the exact exception, it's very hard to
help you.
-- Jeanfrancois
Sandeep Murphy wrote:
hi all,
I perused the procedure provided for creating and using connection pools (with mysql and other
I don't know about the particular connection pool you are using, but in
general I believe the mechanism would be similar to that implemented by
Sybase's Jaguar ejb/servlet engine. There a sanity check is run on each
connection after it has been returned to the pool and before it is re-used.
For
: Saturday, October 05, 2002 3:16 AM
Subject: Re: Connection pool DBCP
[EMAIL PROTECTED] wrote:
I have been seen that nobody is able to answer to this question, I
presume it's interesting for anybody, for a few days.
I wish I knew if DBCP is able to find when db is restarted and
reconnect
[EMAIL PROTECTED] wrote:
I have been seen that nobody is able to answer to this question, I
presume it's interesting for anybody, for a few days.
I wish I knew if DBCP is able to find when db is restarted and
reconnect.
I'd like to use the jakarta instrument DBCP because all the
If you need to be absolutely certain, you can configure DBCP to test every connection
before it is checked out.
-Original Message-
From: [EMAIL PROTECTED] [mailto:[EMAIL PROTECTED]]
Sent: October 4, 2002 11:38 AM
To: tomcat-user
Subject: Connection pool DBCP
I have been seen that
I upgraded to Tomcat 4.1.12 and added the factory parameter to the Context
in server.xml and I started to get Connections from the pool. Thanks Ej.
- Thadd
On Thu, 3 Oct 2002 [EMAIL PROTECTED] wrote:
The below web descriptor does not actually use a Connection Pool since
you do not define
The below web descriptor does not actually use a Connection Pool since
you do not define the factory tag to tell Tomcat that the JNDI is a
Connection pool.
As of now, it is just generating a new connection every time you request
one.
See below for example factory that will work with Tomcat
Search the archives..
I posted a guide/example regarding this not so long ago.
Try to search for keywords like, datasource, JNDI, Oracle, connection pool,
etc...
- Original Message -
From: Nancy Crisostomo Martinez [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday,
One more question about this:
Is it possible to implement a pool connection using Jakarta commons in Tomcat
3.3 or do I have to upgrade to 4.x?
This is because I found a couple of examples but they are implemented in Tomcat
4.x.
If I have to upgrade, which version do you recomend me?
Thanks,
Hi,
D Watson wrote:
BTW, which version of WS are you using?
WebSphere 4.0 on a Sun Enterprise, with Solaris 8.
Fabio.
--
Fabio Mengue - Centro de Computacao - Unicamp
[EMAIL PROTECTED] [EMAIL PROTECTED]
Quem se mata de trabalhar merece mesmo morrer. - Millor
--
To unsubscribe,
Hi,
I have the same problem. Want connection pool to work on Tomcat and Websphere
without to rewrite code. IBM send us instructions to set up the server and a
piece of code that looks like this:
...
java.util.Properties parms = new java.util.Properties();
the same as your
example). BTW, which version of WS are you using?
Thanks and sorry for being OT!!
D Watson
- Original Message -
From: Fabio Mengue [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Tuesday, May 21, 2002 8:23 AM
Subject: Re: Connection Pool Configuration
Hi
Look at poolman, there's really not a need to re-invent the wheel...
--mikej
-=-
mike jackson
[EMAIL PROTECTED]
-Original Message-
From: D Watson [mailto:[EMAIL PROTECTED]]
Sent: Saturday, May 18, 2002 8:58 AM
To: Tomcat Users List
Subject: Connection Pool Configuration
). In
doing this I also hope to keep any application server specific
coding/configuration to a minimum.
- Original Message -
From: Mike Jackson [EMAIL PROTECTED]
To: Tomcat Users List [EMAIL PROTECTED]
Sent: Monday, May 20, 2002 12:40 PM
Subject: RE: Connection Pool Configuration
Look
Landaluze Produktions IS - Carlos wrote:
in the tomcat conf file (server.xmlk) i have see that there is a conection
pool for oracle and mysql
This is not actually a connection pool. It is configuring which JDBC driver
will be used by the JDBCRealm module to look up users for
65 matches
Mail list logo
