Re: java.sql.SQLException: Io exception: Connection reset

It looks like you had a DB connection at one point, otherwise you would not have been able to create a PreparedStatement (unless there is a coding error).

My guess is that you have a networking issue... Another possibility is a coding issue, in which the connection is getting closed somewhere, while objects created against it are still in use.

--Peter

HARI OM wrote:
> 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 - 11:28:57 CDT