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

SEAM+JBPM+MySQL todo-list example

ryanez May 6, 2008 7:50 PM

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

diegocoronel May 26, 2008 3:49 PM (in response to ryanez)

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

ryanez May 26, 2008 4:31 PM (in response to ryanez)

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
Actions

3. Re: SEAM+JBPM+MySQL todo-list example

diegocoronel May 26, 2008 5:23 PM (in response to ryanez)

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 ?

Go to original post