java.sql.SQLException: Io exception: Connection reset

From: HARI OM <hari_om_at_hotmail.com>
Date: 29 Jul 2004 08:42:43 -0700
Message-ID: <d1d5ebe4.0407290742.5e20c5dc@posting.google.com>

I have a Java WEB APplication which connects to my Oracle DB Server 9.2.0.4 which is on IBM AIX 5.1L. My Application Server (Tomcat) is on HP DL580's

Sometimes when I access my Application via browser, it is not able to connect to my DB (becos my login screen says: Invalid Username/Password) When I check my TOMCAT LOG FILES it says following:

[Ajp13Processor[8009][6]][ERROR] (?:?) - SQLException during the execution of the query (for a com.phs3.data.ojb.security.UserImpl): Io exception: Connection reset
java.sql.SQLException: Io exception: Connection reset

        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:134)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:179)
        at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:333)
        at oracle.jdbc.driver.OracleStatement.doExecuteQuery(OracleStatement.java:2529)
        at oracle.jdbc.driver.OracleStatement.doExecuteWithTimeout(OracleStatement.java:2672)
        at oracle.jdbc.driver.OraclePreparedStatement.executeUpdate(OraclePreparedStatement.java:589)
        at oracle.jdbc.driver.OraclePreparedStatement.executeQuery(OraclePreparedStatement.java:527)
        at org.apache.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(Unknown
Source)
        at com.phx.db.ojb.broker.accesslayer.JdbcAccessImpl.executeQuery(JdbcAccessImpl.java:68)
        at org.apache.ojb.broker.accesslayer.RsQueryObject.performQuery(Unknown
Source)
        at org.apache.ojb.broker.accesslayer.RsIterator.<init>(Unknown
Source)
        at org.apache.ojb.broker.core.RsIteratorFactoryImpl.createRsIterator(Unknown
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.getRsIteratorFromQuery(Unknown
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.getIteratorFromQuery(Unknown
Source)
        at org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknown
Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
        at org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(Unknown
Source)
        at com.phx.db.ojb.Application.queryByCriteria(Application.java:467)
-------------------------------------------------------------------

I then check my Firewall and Network Logs and it seems that my App is able to send packets to my DB.

My Web Server is in DMZ and my APP & DB are behind the DMZ. App and DB are connnected directly (there is NO firewall between them)

Can anyone tell me what this ERROR is ABOUT? What is the solution? Any related information is appreciated.

THANKS! Received on Thu Jul 29 2004 - 10:42:43 CDT