RE: java.net.SocketException: Connection reset

You can make sure your datasources are configured with a validationQuery
turned on and filled in for your platform.

-----Original Message-----
From: Abid Hussain [mailto:[email protected]] 
Sent: Tuesday, May 08, 2007 11:52 AM
To: OJB Users List
Subject: java.net.SocketException: Connection reset

Hello everybody,

I'm using OJB in my web applicatin now for more than one year, and it 
did really fine.

But since some time an exception occurs which I can't figure out. 
Obviously the connection to the backend was reset.
May it be the case that the db connection timed out? Anybody got an idea

what I can do about this?

I found this issue in jira but I'm not sure if it's the same case as
mine:
http://issues.apache.org/jira/browse/OJB-70?page=com.atlassian.jira.plug
in.system.issuetabpanels:all-tabpanel

Best regards,

Abid

Here's the stack trace:
ERROR: [org.apache.ojb.broker.accesslayer.JdbcAccessImpl]
* SQLException during execution of sql-statement:
* sql statement was 'SELECT 
A0.Id,A0.modul_Name,A0.LP,A0.Zuordnung,A0.Ziele,A0.Inhalte,A0.Literatur,
A0.Voraussetzung,A0.Modulpruefung,A0.Selbststudium,A0.Form_Teilnahme,A0.
Sprache,A0.Aufwand_Gesamt,A0.Dauer,A0.Haeufigkeit,A0.Sonst_Verantwortlic
he 
FROM Modul_2 A0 WHERE A0.Id = ?'
* Exception message is [An I/O error occured while sending to the
backend.]
* Vendor error code [0]
* SQL state code [08006]
* Target class is 'modulverwaltung.beans.Module_2'
* PK of the target object is [id]
* The root stack trace is -->
* java.net.SocketException: Connection reset
	at
java.net.SocketOutputStream.socketWrite(SocketOutputStream.java:96)
	at
java.net.SocketOutputStream.write(SocketOutputStream.java:136)
	at
java.io.BufferedOutputStream.flushBuffer(BufferedOutputStream.java:65)
	at
java.io.BufferedOutputStream.flush(BufferedOutputStream.java:123)
	at org.postgresql.core.PGStream.flush(PGStream.java:494)
	at 
org.postgresql.core.v3.QueryExecutorImpl.sendSync(QueryExecutorImpl.java
:631)
	at 
org.postgresql.core.v3.QueryExecutorImpl.execute(QueryExecutorImpl.java:
174)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.execute(AbstractJdbc2Stateme
nt.java:389)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeWithFlags(AbstractJdb
c2Statement.java:330)
	at 
org.postgresql.jdbc2.AbstractJdbc2Statement.executeQuery(AbstractJdbc2St
atement.java:240)
	at 
com.p6spy.engine.logging.P6LogPreparedStatement.executeQuery(P6LogPrepar
edStatement.java:172)
	at 
org.apache.ojb.broker.accesslayer.JdbcAccessImpl.materializeObject(Unkno
wn 
Source)
	at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.getPlainDBObject(Unknow
n 
Source)
	at
org.apache.ojb.broker.core.PersistenceBrokerImpl.getDBObject(Unknown 
Source)
	at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.doGetObjectByIdentity(U
nknown 
Source)
	at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByIdentity(Unk
nown 
Source)
	at 
org.apache.ojb.broker.core.PersistenceBrokerImpl.getObjectByQuery(Unknow
n 
Source)
	at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(
Unknown 
Source)
	at 
org.apache.ojb.broker.core.DelegatingPersistenceBroker.getObjectByQuery(
Unknown 
Source)
	at 
modulverwaltung.persistence.Module_2DAO.findByPrimaryKey(Module_2DAO.jav
a:73)
	at
modulverwaltung.action.ShowModule.performAction(ShowModule.java:32)
	at
modulverwaltung.controller.Controller.doGet(Controller.java:70)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:689)
	at javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	at 
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Applica
tionFilterChain.java:252)
	at 
org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilt
erChain.java:173)
	at 
org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValv
e.java:213)
	at 
org.apache.catalina.core.StandardContextValve.invoke(StandardContextValv
e.java:178)
	at 
org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java
:126)
	at 
org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java
:105)
	at 
org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.
java:107)
	at 
org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:1
48)
	at 
org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:85
6)
	at 
org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.processC
onnection(Http11Protocol.java:744)
	at 
org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpoint
.java:527)
	at 
org.apache.tomcat.util.net.LeaderFollowerWorkerThread.runIt(LeaderFollow
erWorkerThread.java:80)
	at 
org.apache.tomcat.util.threads.ThreadPool$ControlRunnable.run(ThreadPool
.java:684)
	at java.lang.Thread.run(Thread.java:595)

-- 

Abid Hussain
Mail: [email protected]
Web: http://www.abid76.de

---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]