Re: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Viorel Dragomir
Can you attach the exception thrown ? Viorel Dragomir . .. --- - Original Message - From: [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Monday, July 18, 2005 13:38 Subject: Tomcat 5.5.9 connection

Re: Tomcat 5.5.9 connection pooling

2005-07-18 Thread Yasir Khan
Can you please write what exception do you get when you try to close the database connection? - Original Message - From: [EMAIL PROTECTED] To: tomcat-user@jakarta.apache.org Sent: Monday, July 18, 2005 4:38 PM Subject: Tomcat 5.5.9 connection pooling Hi! I am using

RE: Tomcat 4.1 Connection Pooling...

2004-09-30 Thread Shilpa Nalgonda
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:37 PM To: Tomcat Users List Subject: Re: Tomcat 4.1 Connection Pooling... Just a thought (and I apologize if this was already mentioned.I missed the very beginning of the thread), but I would also make sure you have the latest

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 11:05 AM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Thanks. Maybe its the parameter configuration can you send me your configuration for connection pooling... I am using these parameters

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
Subject: RE: Tomcat 4.1 Connection Pooling... Is it necessary to add this in web.xml, i have configured datasource for connectonpool only in server.xml... web.xml --- resource-ref res-ref-namejdbc/myoracle/res-ref-name res-typejavax.sql.DataSource/res-type res-authContainer/res-auth /resource

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
) at com.mypublisher.oemapi.DAO.DBAccess.getConnection(DBAccess.java:43) -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 12:53 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi, Yes, it's needed if you're using server-provided connection pooling

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
PROTECTED] Sent: Tuesday, September 28, 2004 12:55 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... But my application runs fine even with out that entry in web.xml, i am using Tomcats ConnectionPooling to connect to database..I only have scalability issue, when i test my

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
[mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 12:55 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... But my application runs fine even with out that entry in web.xml, i am using Tomcats ConnectionPooling to connect to database..I only have scalability issue, when

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Phillip Qin
:55 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... But my application runs fine even with out that entry in web.xml, i am using Tomcats ConnectionPooling to connect to database..I only have scalability issue, when i test my application with multiple users i get the ORAcle

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
PROTECTED] Sent: Tuesday, September 28, 2004 1:06 PM To: 'Tomcat Users List' Subject: RE: Tomcat 4.1 Connection Pooling... This error happens when there are too many connections opened. There are too many connections opened because before you shut down your application, you don't explicitly close

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
. Yoav Shapira Millennium Research Informatics -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:01 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... O.k thanks i'll do that, but what exactly you mean by Tomcat tries

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Phillip Qin
your data source. -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: September 28, 2004 1:06 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... I was not aware that i should explicitly close the datasource, but i am making sure that i close all

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
, explicitly close your data source. -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: September 28, 2004 1:06 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... I was not aware that i should explicitly close the datasource, but i am making sure

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Peter Lin
of a server-provided JNDI resource, you'll be in a murky space at best. Yoav Shapira Millennium Research Informatics -Original Message- From: Phillip Qin [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 1:27 PM To: 'Tomcat Users List' Subject: RE: Tomcat 4.1 Connection

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
To: Tomcat Users List Subject: Re: Tomcat 4.1 Connection Pooling... I thought Oracle fixed that bug in their connectionPooling driver back in 2001. Am I missing something? Are you using some other driver to create a pool of jdbc connections to Oracle? sorry for the question if it's already been answered

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
28, 2004 2:09 PM To: Tomcat Users List; Peter Lin Subject: RE: Tomcat 4.1 Connection Pooling... I am using Oracle 8i, and Oracle drivers i use is Oracle111.jar, and use DBCp for connection Pooling with Tomcat4.1, i thought classes112 is for 9i...correct me if i am wrong... -Original Message

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
thanks.. -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 2:17 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi, You're wrong. You can and should use classes12.zip (renamed to classes12.jar) with Oracle 8i

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Peter Lin
-Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 2:09 PM To: Tomcat Users List; Peter Lin Subject: RE: Tomcat 4.1 Connection Pooling... I am using Oracle 8i, and Oracle drivers i use is Oracle111.jar, and use DBCp for connection

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
, September 28, 2004 2:23 PM To: Tomcat Users List Subject: Re: Tomcat 4.1 Connection Pooling... Yoav is correct, you should be using the newer driver and not the older one. good thing I asked which version the driver is. that's a really old bug in the old driver. I remember reporting the bug

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Dale, Matt
Perhaps your application is hanging on to the database connections and not returning them to the pool? -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 19:43 To: Tomcat Users List; Peter Lin Subject: RE: Tomcat 4.1 Connection Pooling... I have

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shilpa Nalgonda
how can i check that and how to resolve it... -Original Message- From: Dale, Matt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:06 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Perhaps your application is hanging on to the database connections

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
Research Informatics -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:04 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... how can i check that and how to resolve it... -Original Message- From: Dale, Matt

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Peter Lin
just in case, here's a link to Oracle's developer jdbc section http://www.oracle.com/technology/sample_code/tech/java/sqlj_jdbc/files/jdbc30/index.html just make sure the apps are calling java.sql.Connection.close() when they are done. the PooledConnection underneath will pass the connection

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Dale, Matt
in that section so the connection never got closed. Once I put a finally block in with a con.close() then it solved my problem. Ta Matt -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 20:04 To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Peter Lin
processes are coming from. Yoav Shapira Millennium Research Informatics -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:04 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... how can i check

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Phillip Qin
Even though this resource is not in Global scope? -Original Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: September 28, 2004 1:55 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi, Hmm ;) There's a good reason there's no close method

RE: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Shapira, Yoav
, in the destroy method, explicitly close your data source. -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: September 28, 2004 1:06 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... I was not aware that i should explicitly close the datasource, but i am

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Carlos Bracho
PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi, Hmm ;) There's a good reason there's no close method on javax.sql.DataSource. There's also a good reason the J2EE spec calls for the container, not the user, to manage the lifecycle of JNDI resources

Re: Tomcat 4.1 Connection Pooling...

2004-09-28 Thread Michael J. Makunas
Nalgonda [mailto:[EMAIL PROTECTED] Sent: 28 September 2004 20:04 To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... how can i check that and how to resolve it... -Original Message- From: Dale, Matt [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 28, 2004 3:06 PM

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shilpa Nalgonda
Conover [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 21, 2004 10:09 PM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Shilpa, What OS are you running this configuration on? If it is AIX I would investigate to see how the system is configured for the number of processes

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shilpa Nalgonda
Can anyone give me advice on the set up of Tomcat4.1 connection pooling parameters... -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 9:31 AM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi Cary, I am running

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shilpa Nalgonda
Hi Yoav Shapira, Can you put some light on this pooling stuff... Thanks. Shilpa. -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 9:31 AM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi Cary, I am running my

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shapira, Yoav
the error you describe. Yoav Shapira Millennium Research Informatics -Original Message- From: Shilpa Nalgonda [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:44 AM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi Yoav Shapira, Can you put some light

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shilpa Nalgonda
Message- From: Shapira, Yoav [mailto:[EMAIL PROTECTED] Sent: Wednesday, September 22, 2004 10:55 AM To: Tomcat Users List Subject: RE: Tomcat 4.1 Connection Pooling... Hi, Nope, I can't help unfortunately. I used Tomcat 4.1 for years connecting to Oracle 8i and 9i, and I continue to do so now

RE: Tomcat 4.1 Connection Pooling...

2004-09-22 Thread Shapira, Yoav
Users List Subject: RE: Tomcat 4.1 Connection Pooling... Thanks. Maybe its the parameter configuration can you send me your configuration for connection pooling... I am using these parameters... maxActive :20 maxIdle :10 maxWait :1 removeAbandoned :true -- what exactly is MaxIdle parameter

RE: Tomcat 4.1 Connection Pooling...

2004-09-21 Thread Shilpa Nalgonda
Can someone please suggest how to achieve connection Pooling in tomcat 4.1. As per the docs i have 1) configured server.xml to include the resource parameters ( datasource, connection pool size etc) 2) In application code , retrieve connection using datasource 3) Every Method call to database

RE: Tomcat 4.1 Connection Pooling...

2004-09-21 Thread Cary Conover
Shilpa, What OS are you running this configuration on? If it is AIX I would investigate to see how the system is configured for the number of processes per user on the system. If it is configured as a Workstation it is defaulted to 128 processes / login. If it is configured as a server it

RE: Tomcat and connection pooling

2002-08-22 Thread Felipe Schnack
If you want to use dbcp send me a mail. I had bad days trying to configure it, but it's working, I can send you my configuration (using pgSQL) On Wed, 2002-08-21 at 19:24, Andrew Conrad wrote: You can use JNDI to allow for sharing of connections across servlets using either the built in pool

RE: Tomcat and connection pooling

2002-08-21 Thread Segree, Gareth
check www.servletguru.com for a chapter 9 from his book Java Servlets Developer's Guiden. (JDBC and connection pooling) -Original Message- From: Ashish Kulkarni [mailto:[EMAIL PROTECTED]] Sent: Wednesday, August 21, 2002 4:22 PM To: Tomcat Users List Subject: Tomcat and connection

RE: Tomcat and connection pooling

2002-08-21 Thread neal
I see you guys are talking about connection pooling in Tomcat. I presume you must be referring to HTTP connection pooling or something? Is there a dB connection pooling resource in Tomcat? Something like Poolman? I know this is somewhat off topic but your thread reminded me to ask. Thanks.

RE: Tomcat and connection pooling

2002-08-21 Thread Ashish Kulkarni
Hi Does that mean i can create an Instance of AS400JDBCConnectionPool class and keep it is servlet context and then all the servlets can have access to it?? Ashish --- neal [EMAIL PROTECTED] wrote: I see you guys are talking about connection pooling in Tomcat. I presume you must be referring

RE: Tomcat and connection pooling

2002-08-21 Thread Andrew Conrad
You can use JNDI to allow for sharing of connections across servlets using either the built in pool (dbcp) or your own pool. For Tomcat 4.0.x, you can look here (about half way down) http://jakarta.apache.org/tomcat/tomcat-4.0-doc/jndi-resources-howto.htm l - Andrew -Original

RE: Tomcat and connection pooling

2002-08-21 Thread Craig R. McClanahan
On Wed, 21 Aug 2002, neal wrote: Date: Wed, 21 Aug 2002 14:35:43 -0700 From: neal [EMAIL PROTECTED] Reply-To: Tomcat Users List [EMAIL PROTECTED] To: Tomcat Users List [EMAIL PROTECTED] Subject: RE: Tomcat and connection pooling I see you guys are talking about connection pooling