Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Error connecting to Oracle -- java.sql.SQLException: Io exception: Connection reset

Error connecting to Oracle -- java.sql.SQLException: Io exception: Connection reset

From: Ulrich <eulrich_at_jetmultimedia.fr>
Date: 12 Mar 2003 01:42:59 -0800
Message-ID: <a263cffe.0303120142.1468e6d@posting.google.com>


Hello everybody,

A cron restart each day a connxion to a database with the following values :

url=jdbc:oracle:thin:@192.168.16.45:1521:ORCL user=xxxxx
password=xxxxxx
initconns=5
maxfreeconns=4
maxconns=80
logintimeout=5000

Then i get the following :

Io exception: Connection reset

	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:114)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:156)
	at oracle.jdbc.dbaccess.DBError.throwSqlException(DBError.java:269)
	at oracle.jdbc.driver.OracleStatement.<init>(OracleStatement.java:292)
	at oracle.jdbc.driver.OracleConnection.createStatement(OracleConnection.java:311)
	at com.a2a.pool.PoolConnection.isConnectionOK(PoolConnection.java:439)
	at com.a2a.pool.PoolConnection.getConnection(PoolConnection.java:279)
	at com.a2a.util.Tbl.openConnection(Tbl.java:76)
	at com.a2a.election.TblOperation.getVecteurOperation(TblOperation.java:154)
	at com.a2a.election.servlet.VoteOuvert.service(VoteOuvert.java:48)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java)
	at org.apache.tomcat.facade.ServletHandler.doService(Unknown Source)
	at org.apache.tomcat.core.Handler.invoke(Unknown Source)
	at org.apache.tomcat.core.Handler.service(Unknown Source)
	at org.apache.tomcat.facade.ServletHandler.service(Unknown Source)
	at org.apache.tomcat.core.ContextManager.internalService(Unknown
Source)
	at org.apache.tomcat.core.ContextManager.service(Unknown Source)
	at org.apache.tomcat.modules.server.Ajp13Interceptor.processConnection(Unknown
Source)
	at org.apache.tomcat.util.net.TcpWorkerThread.runIt(Unknown Source)
	at org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(Unknown
Source)
	at java.lang.Thread.run(Thread.java:536)

[10:9:21 ] error: suppression de cette mauvaise connexion
[10:9:21 ] error: La connexion du pool n'est pas okay :
java.sql.SQLException: Io exception: Connection reset

can anyone point me in the direction where i can find info to troubleshoot this issue ?

Thanks for your time and help. Received on Wed Mar 12 2003 - 03:42:59 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US