Assuming I understand your question properly, you can do the
following to avoid having your Session Beans timeout:
1) set the maximum db pool size to the maximum allowed by Postgres
2) decrease IdleTimeout
Hope this helps.
---
Michael R. Maraya
> ----------
> From: Carlos Ferrão[SMTP:[EMAIL PROTECTED]]
> Reply To: [EMAIL PROTECTED]
> Sent: Tuesday, July 24, 2001 1:13 PM
> To: jboss ml
> Subject: [JBoss-user] DB connections limit
>
>
> Hi all,
>
> It appears that the connections made to my postgres db are kept in
> idle
> state for too much time. I have no limitation on the pool size. What
> happens
> is that there are connections to the db which are't in use (I'm using
> stateless SBs) and the users keep creating more until the server gets real
> slow or the limit of connections that postgres accepts is reached. After
> that any attempt to use my beans (which access my db) times out. I've
> changed my jdbc.xml to:
>
> <attribute name="PoolName">library</attribute>
> <attribute
> name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper......
> <attribute name="Properties"></attribute>
> <attribute
> name="URL">jdbc:postgresql://192.168.3.248:5432/library</attribute>
> <attribute name="GCMinIdleTime">10000</attribute>
> <attribute name="JDBCUser">postgres</attribute>
> <attribute name="MaxSize">0</attribute>
> <attribute name="Password">postgres</attribute>
> <attribute name="GCEnabled">true</attribute>
> <attribute name="InvalidateOnError">false</attribute>
> <attribute name="TimestampUsed">false</attribute>
> <attribute name="Blocking">true</attribute>
> <attribute name="GCInterval">10000</attribute>
> <attribute name="IdleTimeout">10000</attribute>
> <attribute name="IdleTimeoutEnabled">true</attribute>
> <attribute name="LoggingEnabled">false</attribute>
> <attribute name="MaxIdleTimeoutPercent">0.5</attribute>
> <attribute name="MinSize">0</attribute>
>
> I'm particularly concerned with activity spikes because a lot of
> connections
> are used in each functionality.
>
> Thanks in advance,
> Carlos Ferrao
>
>
> _______________________________________________
> JBoss-user mailing list
> [EMAIL PROTECTED]
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user
