RE: [JBoss-user] DB connections limit

[Maraya M. <mar...@do...>]

	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=E3o[SMTP:cf...@cr...]
> Reply To: 	jbo...@li...
> Sent: 	Tuesday, July 24, 2001 1:13 PM
> To: 	jboss ml
> Subject: 	[JBoss-user] DB connections limit
>=20
>=20
> 	Hi all,
>=20
> 	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:
>=20
>        <attribute name=3D"PoolName">library</attribute>
>        <attribute
> name=3D"DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper......
>        <attribute name=3D"Properties"></attribute>
>        <attribute
> name=3D"URL">jdbc:postgresql://192.168.3.248:5432/library</attribute>
>        <attribute name=3D"GCMinIdleTime">10000</attribute>
>        <attribute name=3D"JDBCUser">postgres</attribute>
>        <attribute name=3D"MaxSize">0</attribute>
>        <attribute name=3D"Password">postgres</attribute>
>        <attribute name=3D"GCEnabled">true</attribute>
>        <attribute name=3D"InvalidateOnError">false</attribute>
>        <attribute name=3D"TimestampUsed">false</attribute>
>        <attribute name=3D"Blocking">true</attribute>
>        <attribute name=3D"GCInterval">10000</attribute>
>        <attribute name=3D"IdleTimeout">10000</attribute>
>        <attribute name=3D"IdleTimeoutEnabled">true</attribute>
>        <attribute name=3D"LoggingEnabled">false</attribute>
>        <attribute name=3D"MaxIdleTimeoutPercent">0.5</attribute>
>        <attribute name=3D"MinSize">0</attribute>
>=20
> I'm particularly concerned with activity spikes because a lot of
> connections
> are used in each functionality.
>=20
> 	Thanks in advance,
> 	Carlos Ferrao
>=20
>=20
> _______________________________________________
> JBoss-user mailing list
> JBo...@li...
> http://lists.sourceforge.net/lists/listinfo/jboss-user
>=20