Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Saurabh Saraswat
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.

Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Christopher Schultz
-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. Gl

Re: Connection Pooling in Tomcat 6 using Java

2014-03-31 Thread Daniel Mikusa
On Mar 31, 2014, at 7:05 AM, Saurabh Saraswat 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 correct if i am doing

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Leo Donahue
On Fri, Mar 28, 2014 at 12:31 PM, Propes, Barry L wrote: > > > -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 > > ===

RE: Connection pooling issue on Tomcat

2014-03-28 Thread 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 a

RE: Connection pooling issue on Tomcat

2014-03-28 Thread Propes, Barry L
-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

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Mark Shifman
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

Re: Connection pooling issue on Tomcat

2014-03-28 Thread Christopher Schultz
-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 de

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
ive 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 by: com.mysql.j

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 21:25, Martin O'Shea 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 to tell people to get

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 20:09, Martin O'Shea 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 > -

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
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 th

FW: Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
Are you able to provide any more information about what I am actually looking for in VisualVM?

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
Tomcat > maxActive 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 weba

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 16:11, "Terence M. Bandoian" 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 int

RE: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
. 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.MySQLNonTransientConnectionExce

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Terence M. Bandoian
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 ---

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Martin O'Shea
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

Re: Connection pooling issue with MySQLNonTransientConnectionException and Java webapp

2011-11-21 Thread Pid *
On 21 Nov 2011, at 09:28, "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 find is that f

Re: connection pooling configuration for DB2 in tomcat

2011-09-29 Thread Christopher Schultz
-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 -B

Re: connection Pooling in tomcat 6

2010-11-04 Thread Pid
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

Re: connection Pooling in tomcat 6

2010-11-03 Thread Bob Hall
--- On Wed, 11/3/10 at 10:30 PM, mike houston wrote: > Can you please explain to me in > detail. > > Thanks, > M http://lmgtfy.com/?q=tomcat+6+dbcp&l=1 - Bob - To unsubscribe, e-mail: users-unsubscr...@tomcat.apach

Re: connection Pooling in tomcat 6

2010-11-03 Thread mike houston
Can you please explain to me in detail. Thanks, M On Thu, Nov 4, 2010 at 10:43 AM, Will Sumekar wrote: > you can use commons dbcp or c3p0 that are available openly. > > > Will > > > On Thu, Nov 4, 2010 at 12:50 PM, mike houston >wrote: > > > Hi.. > > > > Is there a framework for implementing dat

Re: connection Pooling in tomcat 6

2010-11-03 Thread Will Sumekar
you can use commons dbcp or c3p0 that are available openly. Will On Thu, Nov 4, 2010 at 12:50 PM, 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

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> 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 ma

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> 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 beh

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-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 u

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-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 >>

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
- From: 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

Re: Connection Pooling questions

2009-04-01 Thread David Smith
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

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> 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 >

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
Connection 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 connect

RE: Connection Pooling questions

2009-04-01 Thread Caldarale, Charles R
> 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 w

RE: Connection Pooling questions

2009-04-01 Thread Propes, Barry L
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 Po

RE: Connection Pooling questions

2009-04-01 Thread Shaun Farrugia
. Thanks again! 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.

RE: Connection Pooling questions

2009-04-01 Thread Propes, Barry L
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 [mailto:allen.ir

Re: Connection Pooling questions

2009-04-01 Thread Christopher Schultz
-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

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
ssage: - 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 Pooling questions

2009-03-31 Thread Caldarale, Charles R
> From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject: RE: Connection Pooling questions > >type="javax.sql.DataSource" > driverClassName="com.attunity.jdbc.NvDriver" > url=&

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
ssage: - From: Caldarale, Charles R chuck.caldar...@unisys.com Date: Tue, 31 Mar 2009 21:57:01 -0500 To: users@tomcat.apache.org Subject: RE: Connection Pooling questions > From: allen.ir...@smartintegration.com.au > [mailto:allen.ir...@smartintegration.com.au] > Subject: Conne

RE: Connection Pooling questions

2009-03-31 Thread allen.ir...@smartintegration.com.au
: - 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

RE: Connection Pooling questions

2009-03-31 Thread Caldarale, Charles R
> 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 element.

RE: Connection Pooling questions

2009-03-31 Thread Martin Gainty
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 stat

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
, jfk -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 corr

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-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 (http://tomcat.apache.org/tomcat-5.

RE: Connection Pooling and Teradata

2008-06-18 Thread Caldarale, Charles R
> 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 classloade

Re: Connection Pooling and Teradata

2008-06-18 Thread David Smith
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 diffe

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, 1st I tried adding log4j.properies [...] I use log4j, and have it correctly configured to use log4j in my application, so I added: log4j.category.org.apache.tomcat.dbcp=ALL to my log4j.properties file, and that

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 John, Katilie, John wrote: | Chris, 1st I tried adding log4j.properies [...] Take a look at all the messages running around the list this week about logging. Apparently, it's rocket science. - -chris -BEGIN PGP SIGNATURE- Version: GnuPG v1.

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
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

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-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 opt

RE: Connection Pooling and Teradata

2008-06-18 Thread Katilie, John
er Schultz [mailto:[EMAIL PROTECTED] Sent: Wednesday, June 18, 2008 9:46 AM To: Tomcat Users List Subject: Re: Connection Pooling and Teradata -BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Katilie, Katilie, John wrote: | Basically, I have a web application that communicates with Teradata | un

Re: Connection Pooling and Teradata

2008-06-18 Thread Christopher Schultz
-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

Re: Connection pooling again

2008-04-10 Thread Alan Chaney
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 a

Re: Connection pooling again

2008-04-10 Thread [EMAIL PROTECTED]
> -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

Re: Connection pooling again

2008-04-10 Thread [EMAIL PROTECTED]
> 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 (de

Re: Connection pooling again

2008-04-09 Thread Christopher Schultz
-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...

Re: Connection pooling again

2008-04-09 Thread David Smith
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 (default=

Re: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
> -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 s

Re: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
> -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 ob

RE: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
> > 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 T

RE: Connection pooling again

2008-04-09 Thread Caldarale, Charles R
> 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)? > Ho

RE: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
> 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 so

RE: Connection pooling again

2008-04-09 Thread Caldarale, Charles R
> 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

Re: Connection pooling again

2008-04-09 Thread Christopher Schultz
-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? D

Re: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
want 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 agai

Re: Connection pooling again

2008-04-09 Thread Mikolaj Rydzewski
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 ava

Re: Connection pooling again

2008-04-09 Thread Christopher Schultz
-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

Re: Connection pooling again

2008-04-09 Thread Mikolaj Rydzewski
[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 the

Re: Connection pooling again

2008-04-09 Thread Christopher Schultz
-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

RE: Connection pooling again

2008-04-09 Thread [EMAIL PROTECTED]
because i do from same ip (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

RE: Connection pooling again

2008-04-09 Thread Caldarale, Charles R
> 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

Re: Connection pooling

2008-03-13 Thread Christopher Schultz
-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 | http

RE: Connection Pooling

2008-02-27 Thread Propes, Barry L
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

Re: Connection Pooling

2008-02-27 Thread Dirk Weigenand
abhishek reddy" <[EMAIL PROTECTED]> > An: "Tomcat Users List" > 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

Re: Connection Pooling

2008-02-26 Thread abhishek reddy
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 it? On Wed, Feb 27, 2008 at 4:18 AM, Adam Gordon <[EMAIL PROTECTED]> wrote: > Hi, I think you may

Re: Connection Pooling

2008-02-26 Thread abhishek reddy
dle > 15 > > > maxWait > 7000 > > > removeAbandoned > true > > > removeAbandonedTimeout > 60 > > > logAbandoned > true > > > > minEvictableIdleTimeMillis > 5000 >

RE: Connection Pooling

2008-02-26 Thread Propes, Barry L
leIdleTimeMillis 5000 timeBetweenEvictionRunsMillis 1 testWhileIdle true -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 t

Re: Connection Pooling

2008-02-26 Thread Adam Gordon
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 n

RE: Connection pooling

2008-01-11 Thread Propes, Barry L
MAIL 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 With Resoruce name = "ehr" works fine bu

RE: Connection pooling

2008-01-11 Thread Caldarale, Charles R
> 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 > name to "jdbc/ehr" then the name on the con

Re: Connection pooling

2008-01-11 Thread Andrew Hole
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] >

RE: Connection pooling

2008-01-11 Thread Caldarale, Charles R
> 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 ini

Re: Connection pooling

2008-01-11 Thread Andrew Hole
Hi! Thanks... With the following configuration i get the error:DatasourceConnectionProvider - Could not find datasource: java:/comp/env/ehr With Resoruce name = "ehr" works fine but pooling is disable. I don't know if paramenters initalLimit, minLimit are defined correctly. Could you help me t

Re: Connection pooling

2008-01-11 Thread Martin Gainty
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 Mess

RE: Connection pooling, is it the right way to do it?

2007-09-13 Thread Caldarale, Charles R
> 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/tom

RE: Connection pooling, is it the right way to do it?

2007-09-13 Thread Caldarale, Charles R
> 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

Re: Connection pooling, is it the right way to do it?

2007-09-13 Thread [EMAIL PROTECTED]
> 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 appBase directory, the deployment is likely to become > > corrupted or occur twice. > > I have updated the doc

Re: Connection pooling, is it the right way to do it?

2007-09-13 Thread Mark Thomas
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 appBase directory, the deployment is likely to become > corrupted or occur twice. I have updated the docs. Mark ---

Re: Connection pooling, is it the right way to do it?

2007-09-11 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 To whom it may concern, [EMAIL PROTECTED] wrote: > And there is the ?autoReconnect=true option to url parameters too.. > just to show that i got the code from an official jakarta tomcat page > :) Unfortunately, that page could use some re-writing. Fo

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread [EMAIL PROTECTED]
> > 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

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread [EMAIL PROTECTED]
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

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread Caldarale, Charles R
> 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

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread [EMAIL PROTECTED]
> > 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 par

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread Caldarale, Charles R
> 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 > supp

Re: Connection pooling, is it the right way to do it?

2007-09-10 Thread David Smith
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.

RE: Connection pooling, is it the right way to do it?

2007-09-10 Thread [EMAIL PROTECTED]
> > 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 encounter

RE: Connection pooling, is it the right way to do it?

2007-09-09 Thread Caldarale, Charles R
> 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

RE: Connection pooling, is it the right way to do it?

2007-09-09 Thread [EMAIL PROTECTED]
> > 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 n

RE: Connection pooling, is it the right way to do it?

2007-09-09 Thread Caldarale, Charles R
> 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

  1   2   >