0 Replies Latest reply on Jan 11, 2002 1:22 AM by Aanchal

    Ms Sql Server 7 Connection Error

    Aanchal Newbie

      Hi,
      Each time i run my entity bean it reaches the particular method in the Enity bean and the minute it has to fire a query it gives the below Exception.I'm using Jboss2.2 Jdk1.3 and MsSql 7. I need to know urgently as to what can be a possible solution for it.Please Help as soon as possible!!!!!

      [Customer] java.sql.SQLException: Connection is
      broken: Connection aborted by peer: JVM_recv in socket input stream read
      [Customer] at org.hsql.Trace.getError(Trace.java:124)
      [Customer] at org.hsql.Trace.getError(Trace.java:115)
      [Customer] at org.hsql.Trace.error(Trace.java:130)
      [Customer] at org.hsql.jdbcConnection.executeHSQL(jdbcConnection.java:642)
      [Customer] at org.hsql.jdbcConnection.execute(jdbcConnection.java:540)
      [Customer] at org.hsql.jdbcStatement.fetchResult(jdbcStatement.java:499)
      [Customer] at org.hsql.jdbcStatement.executeQuery(jdbcStatement.java:37)
      [Customer] at org.opentools.minerva.jdbc.StatementInPool.executeQuery(StatementInPool.java:141)
      [Customer] at com.infocorpnow.a2g.dataobjects.ejb.CustomerBean.ejbFindByPrimaryKey(CustomerBean.java:1084)
      [Customer] at java.lang.reflect.Method.invoke(Native Method)
      [Customer] at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:458)
      [Customer] at org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:211)
      [Customer] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
      [Customer] at java.lang.reflect.Method.invoke(Native Method)
      [Customer] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:639)
      [Customer] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
      [Customer] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:87)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
      [Customer] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:164)
      [Customer] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
      [Customer] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
      [Customer] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:436)
      [Customer] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
      [Customer] at $Proxy95.findByPrimaryKey(Unknown Source)
      [Customer] at com.infocorpnow.a2g.dataobjects.ejb.CustomerHelper.findByXML(CustomerHelper.java:156)
      [Customer] at com.infocorpnow.a2g.businessobjects.ejb.customers.CustomersSBImpl.getCustomer(CustomersSBImpl.java:128)
      [Customer] at com.infocorpnow.a2g.businessobjects.ejb.customers.CustomersSB.readInput(CustomersSB.java:1108)
      [Customer] at java.lang.reflect.Method.invoke(Native Method)
      [Customer] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
      [Customer] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
      [Customer] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
      [Customer] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190)
      [Customer] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
      [Customer] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
      [Customer] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:482)
      [Customer] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
      [Customer] at $Proxy17.readInput(Unknown Source)
      [Customer] at java.lang.reflect.Method.invoke(Native Method)
      [Customer] at com.infocorpnow.a2g.util.beantest.GenericBOInvoker.invoke(Unknown Source)
      [Customer] at beantest._0002fbeantest_0002fResultBrowser_0002ejspResultBrowser_jsp_16._jspService(_0002fbeantest_0002fResultBrowser_0002ejspResultBrowser_jsp_16.java:118)
      [Customer] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
      [Customer] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [Customer] at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
      [Customer] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [Customer] at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
      [Customer] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
      [Customer] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
      [Customer] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [Customer] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
      [Customer] at org.apache.tomcat.core.Handler.service(Handler.java:287)
      [Customer] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
      [Customer] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
      [Customer] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
      [Customer] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
      [Customer] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
      [Customer] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
      [Customer] at java.lang.Thread.run(Unknown Source)
      [A2G_CustomersSB] FinderException occured
      [A2G_CustomersSB] javax.ejb.FinderException: CustomerBean: ejbFindByPrimaryKey(): SQLException [Connection is broken: Connection aborted by peer: JVM_recv in socket input stream read]
      [A2G_CustomersSB] at com.infocorpnow.a2g.dataobjects.ejb.CustomerBean.ejbFindByPrimaryKey(CustomerBean.java:1129)
      [A2G_CustomersSB] at java.lang.reflect.Method.invoke(Native Method)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.BMPPersistenceManager.callFinderMethod(BMPPersistenceManager.java:458)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.BMPPersistenceManager.findEntity(BMPPersistenceManager.java:211)
      [A2G_CustomersSB] at org.jboss.ejb.EntityContainer.find(EntityContainer.java:419)
      [A2G_CustomersSB] at java.lang.reflect.Method.invoke(Native Method)
      [A2G_CustomersSB] at org.jboss.ejb.EntityContainer$ContainerInterceptor.invokeHome(EntityContainer.java:639)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.EntitySynchronizationInterceptor.invokeHome(EntitySynchronizationInterceptor.java:160)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.EntityInstanceInterceptor.invokeHome(EntityInstanceInterceptor.java:87)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:135)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeHome(TxInterceptorCMT.java:86)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.SecurityInterceptor.invokeHome(SecurityInterceptor.java:164)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.LogInterceptor.invokeHome(LogInterceptor.java:106)
      [A2G_CustomersSB] at org.jboss.ejb.EntityContainer.invokeHome(EntityContainer.java:316)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invokeHome(JRMPContainerInvoker.java:436)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.jrmp.interfaces.HomeProxy.invoke(HomeProxy.java:212)
      [A2G_CustomersSB] at $Proxy95.findByPrimaryKey(Unknown Source)
      [A2G_CustomersSB] at com.infocorpnow.a2g.dataobjects.ejb.CustomerHelper.findByXML(CustomerHelper.java:156)
      [A2G_CustomersSB] at com.infocorpnow.a2g.businessobjects.ejb.customers.CustomersSBImpl.getCustomer(CustomersSBImpl.java:128)
      [A2G_CustomersSB] at com.infocorpnow.a2g.businessobjects.ejb.customers.CustomersSB.readInput(CustomersSB.java:1108)
      [A2G_CustomersSB] at java.lang.reflect.Method.invoke(Native Method)
      [A2G_CustomersSB] at org.jboss.ejb.StatelessSessionContainer$ContainerInterceptor.invoke(StatelessSessionContainer.java:472)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.StatelessSessionInstanceInterceptor.invoke(StatelessSessionInstanceInterceptor.java:87)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.invokeNext(TxInterceptorCMT.java:133)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.runWithTransactions(TxInterceptorCMT.java:263)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.TxInterceptorCMT.invoke(TxInterceptorCMT.java:99)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.SecurityInterceptor.invoke(SecurityInterceptor.java:190)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.LogInterceptor.invoke(LogInterceptor.java:195)
      [A2G_CustomersSB] at org.jboss.ejb.StatelessSessionContainer.invoke(StatelessSessionContainer.java:271)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.jrmp.server.JRMPContainerInvoker.invoke(JRMPContainerInvoker.java:482)
      [A2G_CustomersSB] at org.jboss.ejb.plugins.jrmp.interfaces.StatelessSessionProxy.invoke(StatelessSessionProxy.java:152)
      [A2G_CustomersSB] at $Proxy17.readInput(Unknown Source)
      [A2G_CustomersSB] at java.lang.reflect.Method.invoke(Native Method)
      [A2G_CustomersSB] at com.infocorpnow.a2g.util.beantest.GenericBOInvoker.invoke(Unknown Source)
      [A2G_CustomersSB] at beantest._0002fbeantest_0002fResultBrowser_0002ejspResultBrowser_jsp_16._jspService(_0002fbeantest_0002fResultBrowser_0002ejspResultBrowser_jsp_16.java:118)
      [A2G_CustomersSB] at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:119)
      [A2G_CustomersSB] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [A2G_CustomersSB] at org.apache.jasper.servlet.JspServlet$JspCountedServlet.service(JspServlet.java:130)
      [A2G_CustomersSB] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [A2G_CustomersSB] at org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(JspServlet.java:282)
      [A2G_CustomersSB] at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:429)
      [A2G_CustomersSB] at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:500)
      [A2G_CustomersSB] at javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
      [A2G_CustomersSB] at org.apache.tomcat.core.ServletWrapper.doService(ServletWrapper.java:405)
      [A2G_CustomersSB] at org.apache.tomcat.core.Handler.service(Handler.java:287)
      [A2G_CustomersSB] at org.apache.tomcat.core.ServletWrapper.service(ServletWrapper.java:372)
      [A2G_CustomersSB] at org.apache.tomcat.core.ContextManager.internalService(ContextManager.java:797)
      [A2G_CustomersSB] at org.apache.tomcat.core.ContextManager.service(ContextManager.java:743)
      [A2G_CustomersSB] at org.apache.tomcat.service.http.HttpConnectionHandler.processConnection(HttpConnectionHandler.java:213)
      [A2G_CustomersSB] at org.apache.tomcat.service.TcpWorkerThread.runIt(PoolTcpEndpoint.java:416)
      [A2G_CustomersSB] at org.apache.tomcat.util.ThreadPool$ControlRunnable.run(ThreadPool.java:501)
      [A2G_CustomersSB] at java.lang.Thread.run(Unknown Source)
      [