The connections should close after the default period of 5 minutes of
inactivity (according to JRun docs) and they are not shutting down even
overnight. This is the part I am concerned about. I came in this morning and
found 14 connections that remained open since I left work last night. I am
also confused about why so many seperate connections are being made, I
thought connection pooling would thread individual client db requests
through a few open connections for efficiency. I think having more than 20
connections open for extended periods of time, especially when I am the only
one testing this web application, is not normal. Any info?
Vic
----- Original Message -----
From: "Jay Walters" <[EMAIL PROTECTED]>
To: "JRun-Talk" <[EMAIL PROTECTED]>
Sent: Thursday, May 03, 2001 9:09 PM
Subject: RE: database connections are not closing
> The connections are supposed to stay open, that is the purpose of
connection
> pooling. To open the connections once and keep them open. When you close
> the connections within your application they are just put back in the
pool.
>
> Cheers
> Jay
>
> -----Original Message-----
> From: Victor Marinelli
> To: JRun-Talk
> Sent: 5/3/01 2:43 PM
> Subject: database connections are not closing
>
> Hello,
>
>
> I am using JRun 3.0 and Apache 1.3.14 on Solaris. I am using Informix
> IDS
> 2000 as the database. I noticed that everytime I access my web
> application
> and do a query, database connections remain open! They don't seem to
> ever
> close. I had a total of 49 connections open. I enabled connection
> pooling
> through JMC and I checked my code to make sure I was closing the
> dbConnection. I don't know what to try at this point and this is a
> serious
> problem. Can someone please help!!
>
>
> Thanks,
> Vic
>
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
Structure your ColdFusion code with Fusebox. Get the official book at
http://www.fusionauthority.com/bkinfo.cfm
Archives: http://www.mail-archive.com/[email protected]/
Unsubscribe: http://www.houseoffusion.com/index.cfm?sidebar=lists
