Enable timeout, and set it less than your Oracle connection timeout period. Your DBA can tell you what that is.
----- Original Message ----- From: "Daniel Bruce Lynes" <[EMAIL PROTECTED]> To: <[EMAIL PROTECTED]> Sent: Sunday, March 31, 2002 8:41 AM Subject: [JBoss-user] Oracle: connection reset by peer > 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</attr ibute> > <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 > _______________________________________________ JBoss-user mailing list [EMAIL PROTECTED] https://lists.sourceforge.net/lists/listinfo/jboss-user
