>From time to time, I seem to get an error down at the JDBC level within
JBoss, where it seems Oracle has dropped JBoss's socket connection. However,
I believe this problem is probably on the JBoss side, because I've run other
JDBC code using our own proprietary pooling mechanism for over a year now,
without ever getting that error.
I've searched the mailing list back as far as June of last year (when I first
started receiving the mailing list), to no avail. It seems nobody else has
run into this problem. So, I'm wondering if it's something in my jboss.jcml
configuration for the database.
The following are the relevant sections from my jboss.jcml file:
<mbean code="org.jboss.jdbc.JdbcProvider"
name="DefaultDomain:service=JdbcProvider">
<attribute name="Drivers">oracle.jdbc.driver.OracleDriver</attribute>
</mbean>
<mbean code="org.jboss.jdbc.XADataSourceLoader"
name="DefaultDomain:service=XADataSource,name=DefaultDS">
<attribute name="PoolName">DefaultDS</attribute>
<attribute
name="DataSourceClass">org.jboss.pool.jdbc.xa.wrapper.XADataSourceImpl</attribute>
<attribute name="Properties"></attribute>
<attribute name="URL">jdbc:oracle:thin:@oracle:1521:ora</attribute>
<attribute name="GCMinIdleTime">1200000</attribute>
<attribute name="JDBCUser">mailuser</attribute>
<attribute name="MaxSize">10</attribute>
<attribute name="Password">mailuser</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">false</attribute>
<attribute name="LoggingEnabled">false</attribute>
<attribute name="MaxIdleTimeoutPercent">1.0</attribute>
<attribute name="MinSize">0</attribute>
</mbean>
Thanks in advance for any light you might be able to shed on this problem.
_______________________________________________
JBoss-user mailing list
[EMAIL PROTECTED]
https://lists.sourceforge.net/lists/listinfo/jboss-user
