I encountered the exact same problem using Stateful session beans. My problem
was that I was following the Sun's Java Enterprise Edition Developer's Guide,
that stated I needed to open up my database connection in the ejbCreate &
ejbActivate and disconnect it in the ejbRemove & ejbPassivate methods. Once I
changed it to only open the database when I needed it and closed it right away,
the problems went away.
Mike
> 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".
----
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".
