3 Replies Latest reply on May 26, 2008 5:23 PM by Diego Coronel

    SEAM+JBPM+MySQL todo-list example

    Ramon Yañez Newbie

      Hi, Im having trouble getting the todo-list jBPM sample to work with seam. jBPM is configured to use MySQL as data repository. When the app starts, it does create the db in MySQL, but when I try to list the activities, an exception is thrown.


      
      org.jbpm.JbpmException: couldn't get task instances list for actor 'xxx' 
      
      at org.jbpm.db.TaskMgmtSession.findTaskInstances(TaskMgmtSession.java:65) 
      
      at org.jbpm.JbpmContext.getTaskList(JbpmContext.java:189) 
      
      at org.jboss.seam.bpm.TaskInstanceList.getTaskInstanceList(TaskInstanceList.java:40) 
      
      at org.jboss.seam.bpm.TaskInstanceList.getTaskInstanceList(TaskInstanceList.java:33) 
      
      at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method) 
      
      at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39) 
      
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25) 
      
      at java.lang.reflect.Method.invoke(Method.java:585) 
      
      at org.jboss.seam.util.Reflections.invoke(Reflections.java:21) 
      
      at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31) 
      
      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56) 
      
      at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31) 
      
      at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
      
      ...
      
      12:54:47,296 ERROR [STDERR] ache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
      
          at java.lang.Thread.run(Thread.java:595)
      
      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)
      
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
      
          at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
      
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
      
          at org.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)
      
          at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
      
      ...
      
      Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
      
          at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
      
          at org.hibernate.connection.DatasourceConnectionProvider.getConnection(DatasourceConnectionProvider.java:69)
      
          at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
      
          ... 113 more
      
      Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >
      
          at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)
      
          at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
      
          at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
      
          at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
      
          ... 115 more
      
      12:54:47,312 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
      
      12:54:47,312 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
      
      12:54:47,312 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
      
      12:54:47,312 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
      
      12:54:47,312 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
      
      12:54:47,312 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
      
      12:54:47,328 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
      
      12:54:47,328 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: -3f57ff36:83a:481f35bb:70 status: ActionStatus.ABORT_ONLY >)
      
      12:54:47,328 ERROR [TaskMgmtSession] org.hibernate.exception.GenericJDBCException: Cannot open connection
      
      12:54:47,375 WARN  [JTATransaction] You should set hibernate.transaction.manager_lookup_class if cache is enabled
      
      



      ¿Any idea? Is there any config file not explicited in the docs I should be careful with ?


      Thanks in advance


        • 1. Re: SEAM+JBPM+MySQL todo-list example
          Diego Coronel Apprentice

          I got same problem, i dont know where is the problem anyone can help me ?




           INFO  [STDOUT] Hibernate: select exameresul0_.id_exame_resultado as id1_52_, exameresul0_.dt_liberacao as dt2_52_, exameresul0_.dt_realizacao as dt3_52_, exameresul0_.id_exame as id6_52_, exameresul0_.id_modelo_laudo_versao as id7_52_, exameresul0_.nb_versao as nb4_52_, exameresul0_.id_tipo_exame_layout as id8_52_, exameresul0_.id_tipo_exame_metodo as id9_52_, exameresul0_.tx_observacao as tx5_52_ from laboratorio.exame_resultado exameresul0_ where exameresul0_.id_exame=217 and exameresul0_.nb_versao=(select max(exameresul1_.nb_versao) from laboratorio.exame_resultado exameresul1_ where exameresul1_.id_exame=exameresul0_.id_exame)
          09:24:41,706 INFO  [LogInterceptor] Método:getExameResultado executado em 2.0 ms
          09:24:41,841 WARN  [JDBCExceptionReporter] SQL Error: 0, SQLState: null
          09:24:41,841 ERROR [JDBCExceptionReporter] Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >)
          09:24:41,867 ERROR [STDERR] 26/05/2008 09:24:41 com.sun.facelets.FaceletViewHandler handleRenderException
          SEVERE: Error Rendering View[/face/laboratorio/autorizacao_exame/protocolo.xhtml]
          javax.faces.FacesException: javax.el.ELException: /JDoctorComponents/laboratorio/reaproveitamento_amostra/reaproveitar.xhtml @30,60 value="#{reaproveitarAmostraController.getAmostrasPossiveis(item, item.tipoExame)}": org.hibernate.exception.GenericJDBCException: Cannot open connection
               at javax.faces.component.UISelectItems.getValue(UISelectItems.java:144)
               at org.jboss.seam.ui.component.UISelectItems.getValue(UISelectItems.java:156)
               at com.sun.faces.renderkit.RenderKitUtils.getSelectItems(RenderKitUtils.java:303)
               at com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:776)
               at com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:279)
               at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:850)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:286)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:284)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeCellChildren(AbstractRowsRenderer.java:285)
               at org.richfaces.renderkit.AbstractTableRenderer.encodeOneRow(AbstractTableRenderer.java:287)
               at org.richfaces.renderkit.AbstractRowsRenderer.process(AbstractRowsRenderer.java:86)
               at org.ajax4jsf.model.SequenceDataModel.walk(SequenceDataModel.java:101)
               at org.richfaces.model.ModifiableModel.walk(ModifiableModel.java:118)
               at org.ajax4jsf.component.UIDataAdaptor.walk(UIDataAdaptor.java:1112)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeRows(AbstractRowsRenderer.java:106)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeRows(AbstractRowsRenderer.java:91)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeChildren(AbstractRowsRenderer.java:138)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:125)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxContainerRenderer.encodeAjax(AjaxContainerRenderer.java:123)
               at org.ajax4jsf.component.AjaxViewRoot.encodeAjax(AjaxViewRoot.java:641)
               at org.ajax4jsf.component.AjaxViewRoot.encodeChildren(AjaxViewRoot.java:512)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:936)
               at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
               at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
               at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:189)
               at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
               at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
               at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
               at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
               at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
               at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:256)
               at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:362)
               at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:488)
               at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:68)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
               at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
               at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
               at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
               at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
               at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
               at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
               at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
               at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
               at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
               at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
               at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
               at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
               at java.lang.Thread.run(Unknown Source)
          Caused by: javax.el.ELException: /JDoctorComponents/laboratorio/reaproveitamento_amostra/reaproveitar.xhtml @30,60 value="#{reaproveitarAmostraController.getAmostrasPossiveis(item, item.tipoExame)}": org.hibernate.excepti
          09:24:41,868 ERROR [STDERR] on.GenericJDBCException: Cannot open connection
               at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
               at javax.faces.component.UISelectItems.getValue(UISelectItems.java:141)
               ... 88 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)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
               at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
               at org.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)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
               at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
               at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
               at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
               at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:63)
               at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
               at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
               at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
               at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:163)
               at br.fpf.jdoctor.jdoctorcomponents.web.reaproveitaramostra.ReaproveitarAmostraController.getAmostrasPossiveis(ReaproveitarAmostraController.java:58)
               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.seam.util.Reflections.invoke(Reflections.java:21)
               at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
               at org.jboss.seam.persistence.ManagedEntityIdentityInterceptor.aroundInvoke(ManagedEntityIdentityInterceptor.java:48)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
               at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
               at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
               at br.fpf.jdoctor.jdoctorcomponents.web.reaproveitaramostra.ReaproveitarAmostraController_$$_javassist_96.getAmostrasPossiveis(ReaproveitarAmostraController_$$_javassist_96.java)
               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.TagValueExpression.getValue(TagValueExpression.java:71)
               ... 89 more
          Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >)
               at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
               at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
               at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
               ... 130 more
          Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >
               at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)
               at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
               at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
               at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
               ... 132 more
          09:24:41,877 FATAL [lifecycle] JSF1054: (Phase ID: RENDER_RESPONSE 6, View ID: /face/laboratorio/autorizacao_exame/protocolo.xhtml) Exception thrown during phase execution: javax.faces.event.PhaseEvent[source=com.sun.faces.lifecycle.LifecycleImpl@1c19925]
          09:24:41,903 ERROR [ExceptionFilter] handling uncaught exception
          javax.servlet.ServletException: /JDoctorComponents/laboratorio/reaproveitamento_amostra/reaproveitar.xhtml @30,60 value="#{reaproveitarAmostraController.getAmostrasPossiveis(item, item.tipoExame)}": org.hibernate.exception.GenericJDBCException: Cannot open connection
               at javax.faces.webapp.FacesServlet.service(FacesServlet.java:277)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:83)
               at org.jboss.seam.web.MultipartFilter.doFilter(MultipartFilter.java:85)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.ExceptionFilter.doFilter(ExceptionFilter.java:64)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.RedirectFilter.doFilter(RedirectFilter.java:45)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.ajax4jsf.webapp.BaseXMLFilter.doXmlFilter(BaseXMLFilter.java:147)
               at org.ajax4jsf.webapp.BaseFilter.handleRequest(BaseFilter.java:256)
               at org.ajax4jsf.webapp.BaseFilter.processUploadsAndHandleRequest(BaseFilter.java:362)
               at org.ajax4jsf.webapp.BaseFilter.doFilter(BaseFilter.java:488)
               at org.jboss.seam.web.Ajax4jsfFilter.doFilter(Ajax4jsfFilter.java:60)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.web.LoggingFilter.doFilter(LoggingFilter.java:58)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.debug.hot.HotDeployFilter.doFilter(HotDeployFilter.java:68)
               at org.jboss.seam.servlet.SeamFilter$FilterChainImpl.doFilter(SeamFilter.java:69)
               at org.jboss.seam.servlet.SeamFilter.doFilter(SeamFilter.java:158)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)
               at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)
               at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
               at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:230)
               at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
               at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:179)
               at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:432)
               at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:84)
               at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
               at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
               at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:157)
               at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
               at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:262)
               at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
               at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
               at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:446)
               at java.lang.Thread.run(Unknown Source)
          Caused by: javax.el.ELException: /JDoctorComponents/laboratorio/reaproveitamento_amostra/reaproveitar.xhtml @30,60 value="#{reaproveitarAmostraController.getAmostrasPossiveis(item, item.tipoExame)}": org.hibernate.exception.GenericJDBCException: Cannot open connection
               at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
               at javax.faces.component.UISelectItems.getValue(UISelectItems.java:141)
               at org.jboss.seam.ui.component.UISelectItems.getValue(UISelectItems.java:156)
               at com.sun.faces.renderkit.RenderKitUtils.getSelectItems(RenderKitUtils.java:303)
               at com.sun.faces.renderkit.html_basic.MenuRenderer.renderSelect(MenuRenderer.java:776)
               at com.sun.faces.renderkit.html_basic.MenuRenderer.encodeEnd(MenuRenderer.java:279)
               at javax.faces.component.UIComponentBase.encodeEnd(UIComponentBase.java:850)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:286)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:284)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeCellChildren(AbstractRowsRenderer.java:285)
               at org.richfaces.renderkit.AbstractTableRenderer.encodeOneRow(AbstractTableRenderer.java:287)
               at org.richfaces.renderkit.AbstractRowsRenderer.process(AbstractRowsRenderer.java:86)
               at org.ajax4jsf.model.SequenceDataModel.walk(SequenceDataModel.java:101)
               at org.richfaces.model.ModifiableModel.walk(ModifiableModel.java:118)
               at org.ajax4jsf.component.UIDataAdaptor.walk(UIDataAdaptor.java:1112)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeRows(AbstractRowsRenderer.java:106)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeRows(AbstractRowsRenderer.java:91)
               at org.richfaces.renderkit.AbstractRowsRenderer.encodeChildren(AbstractRowsRenderer.java:138)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.RendererBase.renderChildren(RendererBase.java:262)
               at org.ajax4jsf.renderkit.html.AjaxOutputPanelRenderer.encodeChildren(AjaxOutputPanelRenderer.java:79)
               at javax.faces.component.UIComponentBase.encodeChildren(UIComponentBase.java:826)
               at org.ajax4jsf.renderkit.RendererBase.renderChild(RendererBase.java:282)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:125)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxChildren(AjaxChildrenRenderer.java:68)
               at org.ajax4jsf.renderkit.AjaxChildrenRenderer.encodeAjaxComponent(AjaxChildrenRenderer.java:116)
               at org.ajax4jsf.renderkit.AjaxContainerRenderer.encodeAjax(AjaxContainerRenderer.java:123)
               at org.ajax4jsf.component.AjaxViewRoot.encodeAjax(AjaxViewRoot.java:641)
               at org.ajax4jsf.component.AjaxViewRoot.encodeChildren(AjaxViewRoot.java:512)
               at javax.faces.component.UIComponent.encodeAll(UIComponent.java:936)
               at com.sun.facelets.FaceletViewHandler.renderView(FaceletViewHandler.java:592)
               at org.ajax4jsf.application.ViewHandlerWrapper.renderView(ViewHandlerWrapper.java:108)
               at org.ajax4jsf.application.AjaxViewHandler.renderView(AjaxViewHandler.java:189)
               at com.sun.faces.lifecycle.RenderResponsePhase.execute(RenderResponsePhase.java:110)
               at com.sun.faces.lifecycle.Phase.doPhase(Phase.java:100)
               at com.sun.faces.lifecycle.LifecycleImpl.render(LifecycleImpl.java:139)
               at javax.faces.webapp.FacesServlet.service(FacesServlet.java:266)
               ... 39 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)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
               at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:29)
               at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:426)
               at org.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)
               at org.hibernate.loader.Loader.doQueryAndInitializeNonLazyCollections(Loader.java:236)
               at org.hibernate.loader.Loader.loadCollection(Loader.java:1994)
               at org.hibernate.loader.collection.CollectionLoader.initialize(CollectionLoader.java:36)
               at org.hibernate.persister.collection.AbstractCollectionPersister.initialize(AbstractCollectionPersister.java:565)
               at org.hibernate.event.def.DefaultInitializeCollectionEventListener.onInitializeCollection(DefaultInitializeCollectionEventListener.java:63)
               at org.hibernate.impl.SessionImpl.initializeCollection(SessionImpl.java:1716)
               at org.hibernate.collection.AbstractPersistentCollection.initialize(AbstractPersistentCollection.java:344)
               at org.hibernate.collection.AbstractPersistentCollection.read(AbstractPersistentCollection.java:86)
               at org.hibernate.collection.PersistentSet.iterator(PersistentSet.java:163)
               at br.fpf.jdoctor.jdoctorcomponents.web.reaproveitaramostra.ReaproveitarAmostraController.getAmostrasPossiveis(ReaproveitarAmostraController.java:58)
               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.seam.util.Reflections.invoke(Reflections.java:21)
               at org.jboss.seam.intercept.RootInvocationContext.proceed(RootInvocationContext.java:31)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:56)
               at org.jboss.seam.persistence.ManagedEntityIdentityInterceptor.aroundInvoke(ManagedEntityIdentityInterceptor.java:48)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.transaction.RollbackInterceptor.aroundInvoke(RollbackInterceptor.java:31)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.core.MethodContextInterceptor.aroundInvoke(MethodContextInterceptor.java:42)
               at org.jboss.seam.intercept.SeamInvocationContext.proceed(SeamInvocationContext.java:68)
               at org.jboss.seam.intercept.RootInterceptor.invoke(RootInterceptor.java:107)
               at org.jboss.seam.intercept.JavaBeanInterceptor.interceptInvocation(JavaBeanInterceptor.java:166)
               at org.jboss.seam.intercept.JavaBeanInterceptor.invoke(JavaBeanInterceptor.java:102)
               at br.fpf.jdoctor.jdoctorcomponents.web.reaproveitaramostra.ReaproveitarAmostraController_$$_javassist_96.getAmostrasPossiveis(ReaproveitarAmostraController_$$_javassist_96.java)
               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.TagValueExpression.getValue(TagValueExpression.java:71)
               ... 89 more
          Caused by: org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >)
               at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
               at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
               at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
               ... 130 more
          Caused by: javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:f123:483ab956:bd status: ActionStatus.ABORT_ONLY >
               at org.jboss.resource.connectionmanager.TxConnectionManager.getManagedConnection(TxConnectionManager.java:304)
               at org.jboss.resource.connectionmanager.BaseConnectionManager2.allocateConnection(BaseConnectionManager2.java:396)
               at org.jboss.resource.connectionmanager.BaseConnectionManager2$ConnectionManagerProxy.allocateConnection(BaseConnectionManager2.java:842)
               at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:88)
               ... 132 more
          09:24:41,908 ERROR [ExceptionFilter] exception root cause
          javax.el.ELException: /JDoctorComponents/laboratorio/reaproveitamento_amostra/reaproveitar.xhtml @30,60 value="#{reaproveitarAmostraController.getAmostrasPossiveis(item, item.tipoExame)}": org.hibernate.exception.GenericJDBCException: Cannot open connection
               at com.sun.facelets.el.TagValueExpression.getValue(TagValueExpression.java:76)
               at javax.faces.component.UISelectItems.getValue(UISelectItems.java:141)



          • 2. Re: SEAM+JBPM+MySQL todo-list example
            Ramon Yañez Newbie

            Hi.
            After many weeks solved the problem by myself.
            The problem is in the hibernate.cfg.xml location.
            Bored to prove with this project, I created a new one.
            I take de seam-dvd example to see where the file was located.


            I hope that this will help

            • 3. Re: SEAM+JBPM+MySQL todo-list example
              Diego Coronel Apprentice

              Ty for reply, but i dont know if it resolvs my problem, im using jar module (EJB) and my persistence.xml is there, i dont have any hibernate.cfg.xml, here is more info:



              2008-05-26 11:01:10,897 DEBUG [org.jboss.seam.contexts.Contexts] found in conversation context: org.jboss.seam.persistence.persistenceContexts
              2008-05-26 11:01:10,897 TRACE [org.hibernate.event.def.DefaultInitializeCollectionEventListener] initializing collection [br.fpf.laboratorio.entitybean.TipoExame.tipoExameAmostras#5]
              2008-05-26 11:01:10,897 TRACE [org.hibernate.event.def.DefaultInitializeCollectionEventListener] checking second-level cache
              2008-05-26 11:01:10,897 TRACE [org.hibernate.event.def.DefaultInitializeCollectionEventListener] collection not cached
              2008-05-26 11:01:10,897 DEBUG [org.hibernate.loader.Loader] loading collection: [br.fpf.laboratorio.entitybean.TipoExame.tipoExameAmostras#5]
              2008-05-26 11:01:10,897 DEBUG [org.hibernate.jdbc.AbstractBatcher] about to open PreparedStatement (open PreparedStatements: 0, globally: 0)
              2008-05-26 11:01:10,897 DEBUG [org.hibernate.jdbc.ConnectionManager] opening JDBC connection
              2008-05-26 11:01:10,897 TRACE [org.jboss.resource.connectionmanager.TxConnectionManager] subject: null
              2008-05-26 11:01:10,899 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.parentTraceEnabled=true
              2008-05-26 11:01:10,899 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.nestedTraceEnabled=false
              2008-05-26 11:01:10,899 DEBUG [org.jboss.util.NestedThrowable] org.jboss.util.NestedThrowable.detectDuplicateNesting=true
              2008-05-26 11:01:10,899 TRACE [org.jboss.mx.loading.RepositoryClassLoader] loadClass org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2} name=org.hibernate.exception.JDBCExceptionHelper, loadClassDepth=0
              2008-05-26 11:01:10,899 TRACE [org.jboss.mx.loading.RepositoryClassLoader] loadClassImpl, name=org.hibernate.exception.JDBCExceptionHelper, resolve=false
              2008-05-26 11:01:10,899 TRACE [org.jboss.mx.loading.RepositoryClassLoader] attempt(1) was: true for :org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}
              2008-05-26 11:01:10,899 TRACE [org.jboss.mx.loading.LoadMgr3] registerLoaderThread, ucl=org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, t=Thread[http-0.0.0.0-8080-4,5,jboss], prevT=null
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Begin beginLoadTask, task=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: nullnull, loadOrder: 2147483647, loadException: null, threadTaskCount: 0, state: 0, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.RepositoryClassLoader] getResourceLocally(org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}), name=org/hibernate/exception/JDBCExceptionHelper.class, resURL:jar:file:/C:/jboss-4.2.2.GA/server/default/lib/hibernate3.jar!/org/hibernate/exception/JDBCExceptionHelper.class
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] scheduleTask(1), created subtask: {t=Thread[http-0.0.0.0-8080-4,5,jboss], ucl=org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, name=org.hibernate.exception.JDBCExceptionHelper, requestingThread=Thread[http-0.0.0.0-8080-4,5,jboss], order=2, releaseInNextTask=false}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] End beginLoadTask, task=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: nullnull, loadOrder: 2147483647, loadException: null, threadTaskCount: 1, state: 1, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Continue nextTask(1), task=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: nullnull, loadOrder: 2147483647, loadException: null, threadTaskCount: 1, state: 1, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Begin nextTask(0), loadTask=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: nullnull, loadOrder: 2147483647, loadException: null, threadTaskCount: 1, state: 1, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Running threadTask={t=Thread[http-0.0.0.0-8080-4,5,jboss], ucl=org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, name=org.hibernate.exception.JDBCExceptionHelper, requestingThread=Thread[http-0.0.0.0-8080-4,5,jboss], order=2, releaseInNextTask=false}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.RepositoryClassLoader] loadClassLocally, org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2} name=org.hibernate.exception.JDBCExceptionHelper
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.RepositoryClassLoader] findClass, name=org.hibernate.exception.JDBCExceptionHelper
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.RepositoryClassLoader] loadClassLocally, org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2} name=org.hibernate.exception.JDBCExceptionHelper class=class org.hibernate.exception.JDBCExceptionHelper cl=org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.ClassLoadingTask] setLoadedClass, theClass=class org.hibernate.exception.JDBCExceptionHelper, order=2
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.UnifiedLoaderRepository3] cacheLoadedClass, classname: org.hibernate.exception.JDBCExceptionHelper, class: class org.hibernate.exception.JDBCExceptionHelper, ucl: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, prevClass: null
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Notifying task of thread completion, loadTask:org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: class org.hibernate.exception.JDBCExceptionHelperorg.hibernate.exception.JDBCExceptionHelper@355060<CodeSource: (file:/C:/jboss-4.2.2.GA/server/default/lib/hibernate3.jar <no signer certificates>)>, loadOrder: 2, loadException: null, threadTaskCount: 0, state: 1, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] End nextTask(0), loadTask=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: class org.hibernate.exception.JDBCExceptionHelperorg.hibernate.exception.JDBCExceptionHelper@355060<CodeSource: (file:/C:/jboss-4.2.2.GA/server/default/lib/hibernate3.jar <no signer certificates>)>, loadOrder: 2, loadException: null, threadTaskCount: 0, state: 4, #CCE: 0}
              2008-05-26 11:01:10,900 TRACE [org.jboss.mx.loading.LoadMgr3] Begin endLoadTask, task=org.jboss.mx.loading.ClassLoadingTask@750372{classname: org.hibernate.exception.JDBCExceptionHelper, requestingThread: Thread[http-0.0.0.0-8080-4,5,jboss], requestingClassLoader: org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}, loadedClass: class org.hibernate.exception.JDBCExceptionHelperorg.hibernate.exception.JDBCExceptionHelper@355060<CodeSource: (file:/C:/jboss-4.2.2.GA/server/default/lib/hibernate3.jar <no signer certificates>)>, loadOrder: 2, loadException: null, threadTaskCount: 0, state: 4, #CCE: 0}
              2008-05-26 11:01:10,901 TRACE [org.jboss.mx.loading.RepositoryClassLoader] release(1) for :org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}
              2008-05-26 11:01:10,901 TRACE [org.jboss.mx.loading.RepositoryClassLoader] released, holds: 0
              2008-05-26 11:01:10,901 TRACE [org.jboss.mx.loading.RepositoryClassLoader] loadClass org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2} name=org.hibernate.exception.JDBCExceptionHelper class=class org.hibernate.exception.JDBCExceptionHelper cl=org.jboss.mx.loading.UnifiedClassLoader3@1198ff2{ url=null ,addedOrder=2}
              2008-05-26 11:01:10,901 DEBUG [org.hibernate.util.JDBCExceptionReporter] Cannot open connection [???]
              org.jboss.util.NestedSQLException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:fc4b:483ad03c:91 status: ActionStatus.ABORT_ONLY >; - nested throwable: (javax.resource.ResourceException: Transaction is not active: tx=TransactionImple < ac, BasicAction: a000117:fc4b:483ad03c:91 status: ActionStatus.ABORT_ONLY >)
                   at org.jboss.resource.adapter.jdbc.WrapperDataSource.getConnection(WrapperDataSource.java:94)
                   at org.hibernate.ejb.connection.InjectedDataSourceConnectionProvider.getConnection(InjectedDataSourceConnectionProvider.java:47)
                   at org.hibernate.jdbc.ConnectionManager.openConnection(ConnectionManager.java:423)
                   at org.hibernate.jdbc.ConnectionManager.getConnection(ConnectionManager.java:144)
                   at org.hibernate.jdbc.AbstractBatcher.prepareQueryStatement(AbstractBatcher.java:139)



              and my persistence.xml:



                 <persistence-unit name="idoctor_PU" >
                    <provider>org.hibernate.ejb.HibernatePersistence</provider>
                    <jta-data-source>java:/jdoctorDatasource</jta-data-source>
                    <properties>
                       <property name="hibernate.dialect" value="org.hibernate.dialect.PostgreSQLDialect"/>
                       <!-- property name="hibernate.hbm2ddl.auto" value="validate"/ --> 
                       <property name="hibernate.cache.use_query_cache" value="true"/>
                       <property name="hibernate.show_sql" value="true"/>
                       <!--  property name="hibernate.generate_statistics" value="true"/-->
                       <property name="hibernate.bytecode.use_reflection_optimizer" value="true"/>
              
                       <property name="jboss.entity.manager.factory.jndi.name" value="java:/jdoctor_IDoctorEntityManagerFactory"/>
              
                        <property name="c3p0.acquire_increment" value="5" /> 
                        <property name="c3p0.idle_test_period" value="100" /> <!-- seconds --> 
                        <property name="c3p0.max_size" value="100" /> 
                        <property name="c3p0.max_statements" value="0" /> 
                        <property name="c3p0.min_size" value="10" /> 
                        <property name="c3p0.timeout" value="100" />
                    </properties>
                 </persistence-unit>



                  Any help about it ?