0 Replies Latest reply on Dec 8, 2003 8:16 PM by sys user

    Connection reset by peer.

    sys user Master

      Hi,

      I am having this problem that for some reason while communicating with the database I am getting this exception Connection reset by peer.

      (See attached for complete exception log)
      -----------------------------------------------------
      2003-12-09 09:29:36,411 ERROR [STDERR] com.jnetdirect.jsql.u: DBComms::transmit exception:java.net.SocketException: Connection reset by peer: socket write error
      2003-12-09 09:29:36,431 ERROR [STDERR] at com.jnetdirect.jsql.h.a(Unknown Source)
      2003-12-09 09:29:36,431 ERROR [STDERR] at com.jnetdirect.jsql.aq.a(Unknown Source)
      2003-12-09 09:29:36,441 ERROR [STDERR] at com.jnetdirect.jsql.ae.int(Unknown Source)
      2003-12-09 09:29:36,452 ERROR [STDERR] at com.jnetdirect.jsql.ae.do(Unknown Source)
      2003-12-09 09:29:36,452 ERROR [STDERR] at com.jnetdirect.jsql.ak.executeQuery(Unknown Source)
      2003-12-09 09:29:36,472 ERROR [STDERR] at org.jboss.resource.adapter.jdbc.local.LocalPreparedStatement.executeQuery(LocalPreparedStatement.java:289)
      2003-12-09 09:29:36,492 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCAbstractQueryCommand.execute(JDBCAbstractQueryCommand.java:112)
      2003-12-09 09:29:36,512 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCFindEntityCommand.execute(JDBCFindEntityCommand.java:44)
      2003-12-09 09:29:36,522 ERROR [STDERR] at org.jboss.ejb.plugins.cmp.jdbc.JDBCStoreManager.findEntity(JDBCStoreManager.java:541)
      2003-12-09 09:29:36,542 ERROR [STDERR] at org.jboss.ejb.plugins.CMPPersistenceManager.findEntity(CMPPersistenceManager.java:336)
      2003-12-09 09:29:36,552 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.findEntity(CachedConnectionInterceptor.java:301)
      2003-12-09 09:29:36,572 ERROR [STDERR] at org.jboss.ejb.EntityContainer.findLocal(EntityContainer.java:636)
      2003-12-09 09:29:36,582 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor25.invoke(Unknown Source)
      2003-12-09 09:29:36,602 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2003-12-09 09:29:36,612 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      2003-12-09 09:29:36,632 ERROR [STDERR] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:1119)
      2003-12-09 09:29:36,642 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
      2003-12-09 09:29:36,662 ERROR [STDERR] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:206)
      2003-12-09 09:29:36,672 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invokeHome(CachedConnectionInterceptor.java:215)
      2003-12-09 09:29:36,693 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractInterceptor.invokeHome(AbstractInterceptor.java:73)
      2003-12-09 09:29:36,703 ERROR [STDERR] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:90)
      2003-12-09 09:29:36,713 ERROR [STDERR] at org.jboss.ejb.plugins.EntityLockInterceptor.invokeHome(EntityLockInterceptor.java:79)
      2003-12-09 09:29:36,733 ERROR [STDERR] at org.jboss.ejb.plugins.EntityCreationInterceptor.invokeHome(EntityCreationInterceptor.java:44)
      2003-12-09 09:29:36,743 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:111)
      2003-12-09 09:29:36,763 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      2003-12-09 09:29:36,773 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:52)
      2003-12-09 09:29:36,793 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:105)
      2003-12-09 09:29:36,803 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:129)
      2003-12-09 09:29:36,823 ERROR [STDERR] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:487)
      2003-12-09 09:29:36,833 ERROR [STDERR] at org.jboss.ejb.plugins.local.BaseLocalContainerInvoker.invokeHome(BaseLocalContainerInvoker.java:230)
      2003-12-09 09:29:36,853 ERROR [STDERR] at org.jboss.ejb.plugins.local.LocalHomeProxy.invoke(LocalHomeProxy.java:110)
      2003-12-09 09:29:36,863 ERROR [STDERR] at $Proxy42.findByPrimaryKey(Unknown Source)
      2003-12-09 09:29:36,873 ERROR [STDERR] at com.edocket.home.customer.CustomerMgrBean.findByCustomerId(CustomerMgrBean.java:319)
      2003-12-09 09:29:36,893 ERROR [STDERR] at sun.reflect.GeneratedMethodAccessor91.invoke(Unknown Source)
      2003-12-09 09:29:36,903 ERROR [STDERR] at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      2003-12-09 09:29:36,913 ERROR [STDERR] at java.lang.reflect.Method.invoke(Method.java:324)
      2003-12-09 09:29:36,934 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:660)
      2003-12-09 09:29:36,944 ERROR [STDERR] at org.jboss.resource.connectionmanager.CachedConnectionInterceptor.invoke(CachedConnectionInterceptor.java:186)
      2003-12-09 09:29:36,964 ERROR [STDERR] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:77)
      2003-12-09 09:29:36,974 ERROR [STDERR] at org.jboss.ejb.plugins.AbstractTxInterceptor.invokeNext(AbstractTxInterceptor.java:107)
      2003-12-09 09:29:36,984 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:178)
      2003-12-09 09:29:37,004 ERROR [STDERR] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:60)
      2003-12-09 09:29:37,014 ERROR [STDERR] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:130)
      2003-12-09 09:29:37,034 ERROR [STDERR] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:204)
      2003-12-09 09:29:37,054 ERROR [STDERR] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:313)
      2003-12-09 09:29:37,064 ERROR [STDERR] at org.jboss.ejb.Container.invoke(Container.java:712)
      2003-12-09 09:29:37,084 ERROR [STDERR] at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:517)
      2003-12-09 09:29:37,094 ERROR [STDERR] at org.jboss.invocation.local.LocalInvoker.invoke(LocalInvoker.java:98)
      2003-12-09 09:29:37,104 ERROR [STDERR] at org.jboss.invocation.InvokerInterceptor.invoke(InvokerInterceptor.java:102)
      2003-12-09 09:29:37,124 ERROR [STDERR] at org.jboss.proxy.TransactionInterceptor.invoke(TransactionInterceptor.java:77)
      2003-12-09 09:29:37,134 ERROR [STDERR] at org.jboss.proxy.SecurityInterceptor.invoke(SecurityInterceptor.java:80)
      2003-12-09 09:29:37,154 ERROR [STDERR] at org.jboss.proxy.ejb.StatelessSessionInterceptor.invoke(StatelessSessionInterceptor.java:111)
      2003-12-09 09:29:37,164 ERROR [STDERR] at org.jboss.proxy.ClientContainer.invoke(ClientContainer.java:76)
      2003-12-09 09:29:37,175 ERROR [STDERR] at $Proxy67.findByCustomerId(Unknown Source)
      2003-12-09 09:29:37,185 ERROR [STDERR] at com.edocket.cmd.cadmin.edocket.CustomerDocketFJB.(CustomerDocketFJB.java:69)
      2003-12-09 09:29:37,205 ERROR [STDERR] at com.edocket.cmd.cadmin.edocket.ListEdocNumberCmd.doIt(ListEdocNumberCmd.java:114)
      2003-12-09 09:29:37,215 ERROR [STDERR] at com.edocket.cmd.common.AbstractEDocketCmd.execute(AbstractEDocketCmd.java:247)
      2003-12-09 09:29:37,295 ERROR [STDERR] at com.Service.EventManager.executeCmd(EventManager.java:236)
      2003-12-09 09:29:37,325 ERROR [STDERR] at com.Service.EventManager.processEvent(EventManager.java:196)
      2003-12-09 09:29:37,345 ERROR [STDERR] at com.Service.EventExecutor.service(EventExecutor.java:261)
      2003-12-09 09:29:37,355 ERROR [STDERR] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      2003-12-09 09:29:37,365 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:247)
      2003-12-09 09:29:37,375 ERROR [STDERR] at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:193)
      2003-12-09 09:29:37,395 ERROR [STDERR] at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:260)
      2003-12-09 09:29:37,405 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      2003-12-09 09:29:37,426 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      2003-12-09 09:29:37,436 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      2003-12-09 09:29:37,456 ERROR [STDERR] at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
      2003-12-09 09:29:37,466 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      2003-12-09 09:29:37,486 ERROR [STDERR] at org.apache.catalina.valves.CertificatesValve.invoke(CertificatesValve.java:246)
      2003-12-09 09:29:37,496 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2003-12-09 09:29:37,516 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline.invoke(StandardPipeline.java:480)
      2003-12-09 09:29:37,526 ERROR [STDERR] at org.apache.catalina.core.ContainerBase.invoke(ContainerBase.java:995)
      2003-12-09 09:29:37,536 ERROR [STDERR] at org.apache.catalina.core.StandardContext.invoke(StandardContext.java:2396)
      2003-12-09 09:29:37,556 ERROR [STDERR] at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:180)
      2003-12-09 09:29:37,566 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:643)
      2003-12-09 09:29:37,586 ERROR [STDERR] at org.apache.catalina.valves.ErrorDispatcherValve.invoke(ErrorDispatcherValve.java:170)
      2003-12-09 09:29:37,596 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2003-12-09 09:29:37,606 ERROR [STDERR] at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:172)
      2003-12-09 09:29:37,626 ERROR [STDERR] at org.apache.catalina.core.StandardPipeline$StandardPipelineValveContext.invokeNext(StandardPipeline.java:641)
      2003-12-09 09:29:37,636 ERROR [STDERR] at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:469)
      :
      :
      --------------------------------------------------------------------

      Now, that's one but what happens is apparently for some reason whatsoever, subsequent queries to the db also fails.

      Can someone give me a hint as to what might be the cause... is it something to do with the db configuration parameters???

      BTW env as follows:
      Appl Server : Jboss-3.0.4 bundle with tomcat:
      DB : MS SQL Server 2000
      JDBC driver : JSQLConnect

      Or anyone with similar configuration facing similar problem???

      Any help very much appreciated ....Thanks