DO NOT REPLY [Bug 29240] New: - java.sql.SQLException: Io exception: Connection reset by peer: socket write error

[bugzilla]

DO NOT REPLY TO THIS EMAIL, BUT PLEASE POST YOUR BUG 
RELATED COMMENTS THROUGH THE WEB INTERFACE AVAILABLE AT
<http://issues.apache.org/bugzilla/show_bug.cgi?id=29240>.
ANY REPLY MADE TO THIS MESSAGE WILL NOT BE COLLECTED AND 
INSERTED IN THE BUG DATABASE.

http://issues.apache.org/bugzilla/show_bug.cgi?id=29240

java.sql.SQLException: Io exception: Connection reset by peer: socket write error

           Summary: java.sql.SQLException: Io exception: Connection reset by
                    peer: socket write error
           Product: Tomcat 4
           Version: 4.1.24
          Platform: Other
        OS/Version: Windows NT/2K
            Status: NEW
          Severity: Critical
          Priority: Other
         Component: Connector:Other
        AssignedTo: [EMAIL PROTECTED]
        ReportedBy: [EMAIL PROTECTED]


Hi,
 I have made the connection pooling as mentioned in the tomcat docs.
 when run my tomcat server in windows 2000 NT Professional and oracle 9i on 
Linux system
when the tomcat server is started, the connections are created and kept in pool

then the connection is idle for a long time may be for 1 or 3 days, then when i 
make a action, i get java.sql.SQLException: Io exception: Connection reset by 
peer: socket write error.

can any body help me regarding this.
my server.xml is as follows
<ResourceParams name="jdbc/bbksms">
   <parameter>
        <name>factory</name>
        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
  </parameter>
  <parameter>
     <name>driverClassName</name>
     <value>oracle.jdbc.driver.OracleDriver</value>
  </parameter>
  <parameter>
    <name>url</name>
    <value>jdbc:oracle:thin:@192.9.200.4:1521:orcl</value>
  </parameter>
  <parameter>
        <name>username</name>
        <value>notisappuser</value>
  </parameter>
  <parameter>
        <name>password</name>
        <value>nihmcbiegllgnafk</value>
  </parameter>
  <parameter>
        <name>maxActive</name>
        <value>30</value>
  </parameter>
  <parameter>
        <name>maxIdle</name>
        <value>3</value>
  </parameter>
  <parameter>
        <name>maxWait</name>
        <value>10000</value>
  </parameter>                                          
</ResourceParams>

thanx is advance

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]