Philippe,
When I have N clients connected to Jonas simultaneously, it appears that
N database connections are used. Is this a correct observation?
(That is how I noticed the problem in the first place -- by having many
client threads. When a servlet engine is the only client, this does not
typically happen because the number of threads in the servlet engine
remains small most of the time. However, when clients are separate Java
applications, there can be many simultaneous client threads.)
If you limit the number of DB connections (as I agree you should), I
presume the connections will be shared among clients. I hope this does
not limit the number of client threads. Is this correct?
- Keith
-----Original Message-----
From: Philippe Durieux <[EMAIL PROTECTED]>
To: Keith L. Musser <[EMAIL PROTECTED]>
Cc: JONAS-USERS <[EMAIL PROTECTED]>
Date: Tuesday, November 07, 2000 8:45 AM
Subject: Re: Too many DB connections
>"Keith L. Musser" wrote:
>>
>> Hi,
>>
>> I'm running my application under heavy loads to test it. Jonas is
>> opening too many connections to the database - the database fails
with
>> an error message "too many connections". (PostgreSQL limits me to
about
>> 30 connections in the configuration I'm using.)
>>
>> Eventually my system locks up - it will not allow any more
interaction
>> with the database - but there are 30 idle PostgreSQL connections
being
>> held open by Jonas.
>>
>> I'm using the following settings in my PostgreSQL.properties file:
>>
>> jdbc.connchecklevel 1
>> jdbc.connmaxage 30
>> jdbc.connmaxthreads 4
>> jdbc.connexcltimeout 30
>> jdbc.connteststmt select 1
>>
>> Is there a way to put a limit on the number of connections that Jonas
>> will open simultaneously?
>>
>> Keith L. Musser
>> Integrated Dynamics, Inc.
>> 812-371-7777
>> email: [EMAIL PROTECTED]
>>
>> ----
>> To unsubscribe, send email to [EMAIL PROTECTED] and
>> include in the body of the message "unsubscribe jonas-users".
>> For general help, send email to [EMAIL PROTECTED] and
>> include in the body of the message "help".
>This feature will be added in the jdbc nouveau that will be released
>with JOnAS 2.2 in a few weeks.
>--
>Philippe Durieux ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~
>Bull - 1 rue de Provence - 38432 Echirolles Cedex France
>[EMAIL PROTECTED]
>-> Download our EJBServer at http://www.evidian.com/ejb <-
>
----
To unsubscribe, send email to [EMAIL PROTECTED] and
include in the body of the message "unsubscribe jonas-users".
For general help, send email to [EMAIL PROTECTED] and
include in the body of the message "help".
