1 Reply Latest reply on May 12, 2009 11:08 AM by Ramazan YILDIRIM

    hibernate.jdbc.wrap_result_sets causes failure

    Ramazan YILDIRIM Newbie

      We use Seam 2.1.0 GA with Oracle 10g on JBoss AS 4.2.3
      When we have added hibernate.jdbc.wrapresultsets=true property to persistence.xml for Oracle Database optimization we started to get the following exception.


      This might probably be related with JBoss AS or Hibernate. I have already come across a post that states that when enabled this hibernate property causes leaks.


      Any ideas?


      Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
              at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
              at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
              at com.pegas.morani.action.reservation.ReservationEngine.getHotelAdapterClasses(ReservationEngine.java:113)
              at com.pegas.morani.action.reservation.ReservationEngine.getHotelDescriptionURL(ReservationEngine.java:585)
              at com.pegas.morani.action.reservation.nh.ReservationNHPage.getHotelURL(ReservationNHPage.java:138)
              at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
              at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
              at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
              at java.lang.reflect.Method.invoke(Unknown Source)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
              at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:274)
              at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
              at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
              at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
              at com.sun.facelets.el.ELText$ELTextVariable.toString(ELText.java:174)
              at com.sun.facelets.el.ELText$ELTextComposite.toString(ELText.java:115)
              at com.sun.facelets.compiler.AttributeInstruction.write(AttributeInstruction.java:49)
              ... 78 more
      Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
              at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
              at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
              at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
              at org.hibernate.loader.Loader.doList(Loader.java:2223)
              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)
              at org.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.getResultList(QueryImpl.java:64)
              ... 93 more
      Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@9ee27a
              at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
              at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:237)
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
              at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
              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)
              at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
              at org.hibernate.loader.Loader.doList(Loader.java:2220)


        • 1. Re: hibernate.jdbc.wrap_result_sets causes failure
          Ramazan YILDIRIM Newbie

          We use Seam 2.1.0 GA with Oracle 10g on JBoss AS 4.2.3
          When we have added hibernate.jdbc.wrapresultsets=true property to persistence.xml for Oracle Database optimization we started to get the following exception.


          This might probably be related with JBoss AS or Hibernate. I have already come across a post that states that when enabled this hibernate property causes leaks.


          Any ideas?


          Caused by: javax.persistence.PersistenceException: org.hibernate.exception.GenericJDBCException: could not execute query
                  at org.hibernate.ejb.AbstractEntityManagerImpl.throwPersistenceException(AbstractEntityManagerImpl.java:629)
                  at org.hibernate.ejb.QueryImpl.getResultList(QueryImpl.java:73)
                  at com.pegas.morani.action.reservation.ReservationEngine.getHotelAdapterClasses(ReservationEngine.java:113)
                  at com.pegas.morani.action.reservation.ReservationEngine.getHotelDescriptionURL(ReservationEngine.java:585)
                  at com.pegas.morani.action.reservation.nh.ReservationNHPage.getHotelURL(ReservationNHPage.java:138)
                  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
                  at sun.reflect.NativeMethodAccessorImpl.invoke(Unknown Source)
                  at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
                  at java.lang.reflect.Method.invoke(Unknown Source)
                  at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:329)
                  at org.jboss.el.util.ReflectionUtil.invokeMethod(ReflectionUtil.java:274)
                  at org.jboss.el.parser.AstMethodSuffix.getValue(AstMethodSuffix.java:59)
                  at org.jboss.el.parser.AstValue.getValue(AstValue.java:67)
                  at org.jboss.el.ValueExpressionImpl.getValue(ValueExpressionImpl.java:186)
                  at com.sun.facelets.el.ELText$ELTextVariable.toString(ELText.java:174)
                  at com.sun.facelets.el.ELText$ELTextComposite.toString(ELText.java:115)
                  at com.sun.facelets.compiler.AttributeInstruction.write(AttributeInstruction.java:49)
                  ... 78 more


          Caused by: org.hibernate.exception.GenericJDBCException: could not execute query
                  at org.hibernate.exception.SQLStateConverter.handledNonSpecificException(SQLStateConverter.java:103)
                  at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:91)
                  at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
                  at org.hibernate.loader.Loader.doList(Loader.java:2223)
                  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)
                  at org.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.getResultList(QueryImpl.java:64)
                  ... 93 more


          Caused by: java.sql.SQLException: Connection is not associated with a managed connection.org.jboss.resource.adapter.jdbc.jdk6.WrappedConnectionJDK6@9ee27a
                  at org.jboss.resource.adapter.jdbc.WrappedConnection.lock(WrappedConnection.java:81)
                  at org.jboss.resource.adapter.jdbc.WrappedConnection.prepareStatement(WrappedConnection.java:237)
                  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:505)
                  at org.hibernate.jdbc.AbstractBatcher.getPreparedStatement(AbstractBatcher.java:423)
                  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)
                  at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
                  at org.hibernate.loader.Loader.doList(Loader.java:2220)





          Click HELP for text formatting instructions. Then edit this text and check the preview.