Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-22 Thread Johnny Kewl
- Original Message - From: "Christopher Schultz" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Monday, September 22, 2008 3:14 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing -BEGIN PGP SIGNED MESSA

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-22 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Johnny, Johnny Kewl wrote: > If a datasource in DBCP represents the pool... you cant, you'd make a > million data pools... No, the DataSource object does not represent the pool per se. It's just a factory that produces Connection objects (which, in t

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-22 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinoea, sinoea kaabi wrote: > Christopher Schultz wrote: >> You aren't using any class-level members in your static methods so >> you should be fine. > > This means that I cannot declare a: > > public class Data { > > private static DataSource data

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-19 Thread Johnny Kewl
Heres the blurb on the stuff... http://java.sun.com/docs/books/tutorial/essential/concurrency/index.html/01/ Where I spoke about the "New Trick"... they blab on about immutable.. The stuff you prbably want to look at is Synchronized Statements In C they talk about semisphores and stuff... if yo

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-19 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Friday, September 19, 2008 9:18 AM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing You aren't using any class-level

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-19 Thread sinoea kaabi
ource; } } > Date: Thu, 18 Sep 2008 11:56:33 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > > sinoe

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sinoea, sinoea kaabi wrote: > Collection branches = new BranchData().loadBranches(Data.getDataSource(), 1); > > Can the getDataSource method be static? Not only can the getDataSource method be static, you could also call it directly from your loadBr

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-18 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 sinoea, sinoea kaabi wrote: > The static methods are not thread-safe you say! No, your static methods are perfectly threadsafe. Johnny is just getting itchy because it's not what he'd do. You aren't using any class-level members in your static method

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-18 Thread David Smith
bers appear to be coming from the DBCP BasicDataSource itself. --David Caldarale, Charles R wrote: >> From: Johnny Kewl [mailto:[EMAIL PROTECTED] >> Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active >> connections keep increasing >> >> sinoea, of course yo

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Caldarale, Charles R
> From: Johnny Kewl [mailto:[EMAIL PROTECTED] > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active > connections keep increasing > > sinoea, of course you can... that looks thread safe... but > what I'm trying to do, is just make it bullet proof... Your sug

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinoea, Oh, and I always always /always/ set my connection pool size to a fixed size of 1 (yes, a single connection) in development. This can help find places where you are requesting two connections from the pool by a single thread, which exposes yo

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Christopher Schultz
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 Sinoea, sinoea kaabi wrote: > } finally { > results.close(); > } > > } finally { > statement.close(); > } > > } finally {

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "André Warnier" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 10:18 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Caldarale, Charles R wrote: T

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 9:56 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Right, I have attached the source

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread André Warnier
Caldarale, Charles R wrote: That's completely erroneous. Shame, Johnny's story was so nice.. - To start a new topic, e-mail: users@tomcat.apache.org To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail:

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread André Warnier
Johnny Kewl wrote: >> So, what exactly does it mean when we say that Tomcat is thread safe >> for >> requests. >> Tomcat creates a new thread for each request, so somehow my static >> methods >> are then thread safe (incdirectly, since it is managed by Tomcat). I actually searched all over

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 4:48 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing This question about static variabl

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 4:48 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing This question about static variabl

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread David Smith
on); > > throw new RuntimeException(namingException); > > } catch (SQLException sqlException) { > > log.fatal(sqlException); > > throw new RuntimeException(sqlException); > > } > > } > > > > > > >> Date:

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread David Smith
still on topic. --David Johnny Kewl wrote: > > - Original Message - From: "David Smith" <[EMAIL PROTECTED]> > To: "Tomcat Users List" > Sent: Wednesday, September 17, 2008 3:40 PM > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread sinoea kaabi
Wed, 17 Sep 2008 09:40:16 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > > Comments inline ... > > Johnny Kewl wrote: > > > >> >> So, what exact

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "David Smith" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 3:40 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Comments inline ... Johnny Kewl wro

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Caldarale, Charles R
> From: Johnny Kewl [mailto:[EMAIL PROTECTED] > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active > connections keep increasing > > Sineoa, my feeling is dont use static, unless you really want > it in a multithreaded environment > It pumps all the threads thr

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread David Smith
Comments inline ... Johnny Kewl wrote: > >> >> So, what exactly does it mean when we say that Tomcat is thread >> safe >> for >> >> requests. >> >> Tomcat creates a new thread for each request, so somehow my static >> >> methods >> >> are then thread safe (incdirectly, since it is managed by Tomca

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
>> So, what exactly does it mean when we say that Tomcat is thread safe >> for >> requests. >> Tomcat creates a new thread for each request, so somehow my static >> methods >> are then thread safe (incdirectly, since it is managed by Tomcat). I actually searched all over to try find somethi

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread David Smith
ent: Wednesday, September 17, 2008 12:48 PM > Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections > keep increasing > > > > Just a question here, > I am using a Data class to retrieve the datasource > > public class Data { > > /** > * Gets a [EMAIL P

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread sinoea kaabi
Thanks! > Date: Wed, 17 Sep 2008 08:01:01 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > > A static method can't have access to class instance variables.

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 12:48 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Just a question here, I am usin

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread David Smith
; Collection branches = new BranchData().loadBranches(Data.getDataSource(), 1); > > > Can the getDataSource method be static? > > Thanks, > Sinoea > > >> From: [EMAIL PROTECTED] >> To: users@tomcat.apache.org >> Subject: Re: Tomcat 5.5, JNDI Connection Poo

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread sinoea kaabi
a > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > Date: Wed, 17 Sep 2008 12:25:17 +0200 > > > - Original Message - > From: "sinoea kaabi" > To: "Tomcat

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread sinoea kaabi
Sounds reasonable, I will give it a try with non-static methods instead, new Dao() basically. Thanks, Sinoea > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > Date: Wed, 17 Se

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Wednesday, September 17, 2008 11:31 AM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Thanks, First I will try to close

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-17 Thread sinoea kaabi
pache.org > Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > Date: Tue, 16 Sep 2008 18:58:25 +0200 > > > - Original Message - > From: "Johnny Kewl" <[EMAIL PROTECTED]> > To: "Tomcat Users List" &g

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Johnny Kewl
- Original Message - From: "Johnny Kewl" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Tuesday, September 16, 2008 5:41 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing - Original Message - From

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Propes, Barry L
8:37 AM To: Tomcat Users List Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing sinoea I dont use the JNDI pools, but I've marked a possible issue below... Dont think its getting to finally guess ;) On the dB pools I use... connections will not inc

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Johnny Kewl
- Original Message - From: "Johnny Kewl" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Tuesday, September 16, 2008 5:17 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing - Original Message - Fr

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Johnny Kewl
rwise it wont increase... ... why it resets at 37 I dont know, but I think you are leaking connections... - Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: Sent: Tuesday, September 16, 2008 11:23 AM Subject: Tomcat 5.5, JNDI Connection Pooling, Ac

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Johnny Kewl
- Original Message - From: "Brantley Hobbs" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Tuesday, September 16, 2008 5:27 PM Subject: Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing "return" statements d

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Propes, Barry L
kaabi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 10:10 AM To: Tomcat Users List Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Yes, as I said in the first post, that I have checked through all the code, and I am closing all the connections

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Brantley Hobbs
t" Sent: Tuesday, September 16, 2008 5:10 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Yes, as I said in the first post, that I have checked through all the code, and I am closing all the connections (in a finally block) after they have been u

Re: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Johnny Kewl
- Original Message - From: "sinoea kaabi" <[EMAIL PROTECTED]> To: "Tomcat Users List" Sent: Tuesday, September 16, 2008 5:10 PM Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing Yes, as I said in the first post, t

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread sinoea kaabi
ect: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > Date: Tue, 16 Sep 2008 11:02:46 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > > At the end of the servlet or JSP or whichever, you need to kill off > connections cr

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Propes, Barry L
, Active connections keep increasing How exaclt do you mean? Anywhere in my code where you have seen that? Thanks! > Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing > Date: Tue, 16 Sep 2008 10:26:03 -0400 > From: [EMAIL PROTECTED] &g

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread sinoea kaabi
How exaclt do you mean? Anywhere in my code where you have seen that? Thanks! > Subject: RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep > increasing > Date: Tue, 16 Sep 2008 10:26:03 -0400 > From: [EMAIL PROTECTED] > To: users@tomcat.apache.org > > S

RE: Tomcat 5.5, JNDI Connection Pooling, Active connections keep increasing....

2008-09-16 Thread Propes, Barry L
Sounds like you're not explicitly killing off the connections you set in the first place. -Original Message- From: sinoea kaabi [mailto:[EMAIL PROTECTED] Sent: Tuesday, September 16, 2008 4:24 AM To: users@tomcat.apache.org Subject: Tomcat 5.5, JNDI Connection Pooling, A