2 Replies Latest reply on Mar 2, 2011 3:43 PM by Arbi Sookazian

    Got minus one from a read call: why?

    Arbi Sookazian Master

      Unable to understand/identify root cause of this stack.  Running Oracle 10g with JBoss 4.2.2.GA.  Please advise.  thx.

       

      2011-02-22 15:01:39,817 ERROR[org.hibernate.util.JDBCExceptionReporter] Could not create connection; -nested throwable: (java.sql.SQLException: Io exception: Got minus on

      e from a read call); - nestedthrowable: (org.jboss.resource.JBossResourceException: Could not createconnection; - nested throwable: (java.sql.SQLException: Io exception:

      Got minus one from a read call))

      2011-02-22 15:01:39,819 ERROR[com.echo.cis.logtran.cfg.ExportHandshakeBean] Exception occurred duringprocessing of exportMerchants

      javax.ejb.EJBException:javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException: Cannot open connection

             at org.jboss.ejb3.tx.Ejb3TxPolicy.handleExceptionInOurTx(Ejb3TxPolicy.java:63)

             at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:83)

             at org.jboss.aspects.tx.TxInterceptor$Required.invoke(TxInterceptor.java:191)

             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

             atorg.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:240)

             at org.jboss.ejb3.stateless.StatelessContainer.localInvoke(StatelessContainer.java:210)

             atorg.jboss.ejb3.stateless.StatelessLocalProxy.invoke(StatelessLocalProxy.java:84)

             at $Proxy235.findMerchantsCount(Unknown Source)

             at com.echo.cis.logtran.cfg.ExportHandshakeBean.generateCsvFile(ExportHandshakeBean.java:146)

             atcom.echo.cis.logtran.cfg.ExportHandshakeBean.doExport(ExportHandshakeBean.java:98)

             atcom.echo.cis.logtran.cfg.ExportHandshakeBean.runOnce(ExportHandshakeBean.java:90)

             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

             atsun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

             atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

             at java.lang.reflect.Method.invoke(Method.java:585)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

             atorg.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

             at org.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.aspects.tx.TxPolicy.invokeInNoTx(TxPolicy.java:66)

             atorg.jboss.aspects.tx.TxInterceptor$NotSupported.invoke(TxInterceptor.java:112)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.aspects.tx.TxPropagationInterceptor.invoke(TxPropagationInterceptor.java:95)

             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.stateless.StatelessInstanceInterceptor.invoke(StatelessInstanceInterceptor.java:62)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.aspects.security.AuthenticationInterceptor.invoke(AuthenticationInterceptor.java:77)

             atorg.jboss.ejb3.security.Ejb3AuthenticationInterceptor.invoke(Ejb3AuthenticationInterceptor.java:110)

             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.ENCPropagationInterceptor.invoke(ENCPropagationInterceptor.java:46)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.ejb3.asynchronous.AsynchronousInterceptor.invoke(AsynchronousInterceptor.java:106)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.stateless.StatelessContainer.dynamicInvoke(StatelessContainer.java:304)

             at org.jboss.aop.Dispatcher.invoke(Dispatcher.java:106)

             atorg.jboss.aspects.remoting.AOPRemotingInvocationHandler.invoke(AOPRemotingInvocationHandler.java:82)

             at org.jboss.remoting.ServerInvoker.invoke(ServerInvoker.java:769)

             at org.jboss.remoting.transport.socket.ServerThread.processInvocation(ServerThread.java:573)

             atorg.jboss.remoting.transport.socket.ServerThread.dorun(ServerThread.java:373)

             at org.jboss.remoting.transport.socket.ServerThread.run(ServerThread.java:166)

      Caused by:javax.persistence.PersistenceException:org.hibernate.exception.GenericJDBCException: Cannot open connection

             atorg.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)

             at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:99)

             atcom.echo.cis.ejb.dao.MerchantHibernateDAO.findMerchantsCount(MerchantHibernateDAO.java:143)

             at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)

             at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)

             atsun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)

             at java.lang.reflect.Method.invoke(Method.java:585)

             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:112)

             atorg.jboss.ejb3.interceptor.InvocationContextImpl.proceed(InvocationContextImpl.java:166)

             atorg.jboss.ejb3.interceptor.EJB3InterceptorsInterceptor.invoke(EJB3InterceptorsInterceptor.java:63)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.entity.TransactionScopedEntityManagerInterceptor.invoke(TransactionScopedEntityManagerInterceptor.java:54)

             at org.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             atorg.jboss.ejb3.AllowedOperationsInterceptor.invoke(AllowedOperationsInterceptor.java:47)

             atorg.jboss.aop.joinpoint.MethodInvocation.invokeNext(MethodInvocation.java:101)

             at org.jboss.aspects.tx.TxPolicy.invokeInOurTx(TxPolicy.java:79)

             ... 53 more

      Caused by:org.hibernate.exception.GenericJDBCException: Cannot open connection

             at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)

             at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)

             atorg.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)

             at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)

             atorg.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)

             atorg.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)

             at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)

             at org.hibernate.loader.Loader.prepareQueryStatement(Loader.java:1547)

             at org.hibernate.loader.Loader.doQuery(Loader.java:673)

             atorg.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)

             at org.hibernate.loader.Loader.doList(Loader.java:2220)

             at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)

             at org.hibernate.loader.Loader.list(Loader.java:2099)

             at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)

             atorg.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)

             at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)

             at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)

             at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)

             at org.hibernate.ejb.QueryImpl.getSingleResult(QueryImpl.java:80)

             ... 67 more

      Caused by:org.jboss.util.NestedSQLException: Could not create connection; - nestedthrowable: (java.sql.SQLException: Io exception: Got minus one from a readcall); - nest

      ed throwable:(org.jboss.resource.JBossResourceException: Could not create connection; -nested throwable: (java.sql.SQLException: Io exception: Got minus one from aread c

      all))

             atorg.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)

             at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)

             atorg.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)

             ... 81 more

      Caused by:org.jboss.resource.JBossResourceException: Could not create connection; -nested throwable: (java.sql.SQLException: Io exception: Got minus one from aread call)

             atorg.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:179)

             atorg.jboss.resource.connectionmanager.InternalManagedConnectionPool.createConnectionEventListener(InternalManagedConnectionPool.java:577)

             atorg.jboss.resource.connectionmanager.InternalManagedConnectionPool.getConnection(InternalManagedConnectionPool.java:262)

             atorg.jboss.resource.connectionmanager.JBossManagedConnectionPool$BasePool.getConnection(JBossManagedConnectionPool.java:538)

             atorg.jboss.resource.connectionmanager.BaseConnectionManager2.getManagedConnection(BaseConnectionManager2.java:341)

             atorg.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:315)

             atorg.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)

             atorg.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)

             atorg.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)

             ... 83 more

      Caused by:java.sql.SQLException: Io exception: Got minus one from a read call

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:111)

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:145)

             at oracle.jdbc.driver.DatabaseError.throwSqlException(DatabaseError.java:254)

             at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:386)

             at oracle.jdbc.driver.PhysicalConnection.<init>(PhysicalConnection.java:419)

             at oracle.jdbc.driver.T4CConnection.<init>(T4CConnection.java:164)

             atoracle.jdbc.driver.T4CDriverExtension.getConnection(T4CDriverExtension.java:34)

             at oracle.jdbc.driver.OracleDriver.connect(OracleDriver.java:752)

             at org.jboss.resource.adapter.jdbc.local.LocalManagedConnectionFactory.createManagedConnection(LocalManagedConnectionFactory.java:171)

             ... 91 more