>>>>> "MTK" == Mark T Kaseman <Kaseman> writes:
MTK> I have seen this same problem with using DB2 in an MVS OS/390
MTK> system. When accessing DB2 via a distributed connection, DB2 is
MTK> set-up with an idle thread time-out limit. In our configuration,
MTK> this time-out limit is set to 5 minutes. When DB2 disconnects the
MTK> connection for lack of use, JBOSS does not automatically
MTK> reconnect the pooled connections. I have been testing a simple
MTK> BMP and discovered this issue. When I run the same code using
MTK> ORION, ORION does the reconnect for me. Under JBOSS, I have had
MTK> to restart the server or set the GCMinIdleTime / GCInterval
MTK> parameters to 5 minutes to match the DB2 idle thread time-out
MTK> limit. I also set MinSize to 1 in my JBOSS.jcml.
Hmmmm, doesn't sound good at all. Here is my entry in jboss.jcml (BTW
Emacs pSGML mode is very good for editing that file when you load the
dtd :)
<!-- MySQL -->
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=CAMS">
<attribute name="PoolName">CAMS</attribute>
<attribute
name="DataSourceClass">org.opentools.minerva.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute
name="URL">jdbc:mysql://machiavelli.frontwire.localdomain/cams</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">cams</attribute>
<attribute name="MaxSize">20</attribute>
<attribute name="Password">f00bar</attribute>
<attribute name="GCEnabled">false</attribute>
<attribute name="InvalidateOnError">false</attribute>
<attribute name="TimestampUsed">false</attribute>
<attribute name="Blocking">true</attribute>
<attribute name="GCInterval">120000</attribute>
<attribute name="IdleTimeout">1800000</attribute>
<attribute name="IdleTimeoutEnabled">True</attribute>
<attribute name="LoggingEnabled">True</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
This is very much in the test stage. I'm still evaluating JBoss for
commercial deployment.
Thanks for the tip. I had set the MinSize to 1 but it still
disconnected overnight. This might be a deal-breaker for us :(
BTW is it possible adding different connection pools dynamically, ie
without having to take the server down?
--
Nicolai P Guba http://www.gnu.org http://www.frontwire.com
mailgo:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED]
GSM: +44 (0)7909 960 751 DDI: +44 (0)20 7368 9708
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
http://lists.sourceforge.net/lists/listinfo/jboss-user