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

    Got minus one from a read call: why?

    asookazian

      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

        • 1. Got minus one from a read call: why?
          mp911de
          • 2. Re: Got minus one from a read call: why?
            asookazian

            In /opt/jboss-4.2.2.GA/server/all/lib, we have classes12-10.2.0.2.0.jar.  We are not using ojdbc14.jar driver as we are in prod/dev, etc.   So that is the old one and the current version of Oracle in QA is:

             

            select * from v$version;

             

            Oracle Database 10g Enterprise Edition Release 10.2.0.5.0 - 64bi

             

            Manifest-Version: 1.0

            Specification-Title:   Oracle JDBC driver classes for use with JDK12

            Sealed: true

            Created-By: 1.4.2_08 (SunMicrosystems Inc.)

            Implementation-Title:  classes12.jar

            Specification-Vendor:  Oracle Corporation

            Specification-Version:  Oracle JDBC Driver version -"10.2.0.2.0"

            Implementation-Version: OracleJDBC Driver version - "10.2.0.2.0"

            Implementation-Vendor: Oracle Corporation

            Implementation-Time:   Tue Jan 24 08:52:40 2006

             

            We need to try a newer JDBC driver JAR, and even the one we have in prod does not match what it will beafter upgrade (it’s currently 10.2.0.3.0).

             

            Not sure if this will make any difference, but perhaps we should try the correct driver for the version of DB we’re using.

             

            Could this intermittent problem be network related?