"Keith L. Musser" wrote:
>
> Philippe,
>
> When I have N clients connected to Jonas simultaneously, it appears that
> N database connections are used. Is this a correct observation?
Yes because you have 1 connection for each transaction.
>
> (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?
No. If you limit the nb of connections, when you attempt to get one
more,
you will be waiting until a connection is available.
>
> - 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".
--
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".
