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
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 b
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 file
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:
removeAbandoned
true
removeAbandonedTimeout
60
To reclaim abandoned connections.
Doug
www.parsonstechnic
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
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 container-man
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" %>
<%
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 Pool
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: M
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,
Nan
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 nobod
[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
quot;Tomcat Users List" <[EMAIL PROTECTED]>
Sent: 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 f
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
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
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 po
The Code of DBQuery follows: Remember, in one webapp, it works fine, in
another, it gives a class cast exception at the ***'d line
/*
* DBQuery.java
*
* Created on November 5, 2002, 10:14 AM
*/
package DBCPTestClasses;
import java.sql.*;
import javax.naming.*;
import javax.sql.*;
/*
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
on" To: "Tomcat Users List"
<[EMAIL PROTECTED]>
<[EMAIL PROTECTED]cc:
u>
ng 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]>
> Se
ks 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 ea
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
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();
parms.setProperty(javax.nami
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: connectio
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 N
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 initializ
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 initi
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!
http://jakarta.apache.or
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.
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 results
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 Cross
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 th
That easy,
look at the DBCP Documentation
http://jakarta.apache.org/commons/dbcp/configuration.html
and used the following
type="javax.sql.DataSource" />
username
Blah
-->8
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
/
, 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.
> Here my setting..
: "'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 for a while... Le
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 wor
onnection
>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.
>
>
>
>
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 back to pool. ;-)
Gordon
Parsons Technical Services wrote:
Gord
mally. 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,
ave it in finally clauses as a last
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
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
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 connectio
Tony Smith wrote:
I am runing tomcat 5.0 + postgresql. I set my
connection pool in server.xml as:
For PostgreSQL (and MySQL, too), this is better done via "SELECT
version()", just an observation.
username=""
url="jdbc:postgresql://localhost:5432/mydb"
maxActive="1
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 shoul
lable). 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
Subje
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: R
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, e
Here is what i have in server.xml in the context of my app
factory
org.apache.commons.dbcp.BasicDataSourceFactory
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 config
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 C
age-
>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 w
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
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:
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
The below web descriptor does not actually use a Connection Pool since
you do not define the 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 4.1.10
f
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 defi
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
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 th
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
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 look
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
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 definit
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
[EMAI
65 matches
Mail list logo