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
