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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
