JBoss Community

Re: Help!After replacing H2 to mysql,getting errors in the process tab!

created by Jimmy dong in jBPM - View the full discussion

Yes,just now I found the datasource of jboss is wrong,I modified testDS1-ds.xml and the datasource is ok,but it also has something wrong:

2011-12-14 10:08:53,640 INFO  [STDOUT] (http-0.0.0.0-8080-4) 10:08:53,639 INFO  [PluginMgr] Successfully loaded plugin 'org.jboss.bpm.console.server.plugin.FormDispatcherPlugin': class org.jbpm.integration.console.forms.FormDispatcherComposite
2011-12-14 10:09:02,231 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,230 (NilAuthenticator.java:authenticate:35)   All users are guests.
2011-12-14 10:09:02,233 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,233 (RepositoryServlet.java:allowUser:114)   admin authenticated for rest api
2011-12-14 10:09:02,234 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,234 (PackageDeploymentServlet.java:execute:141)   PackageName: defaultPackage
2011-12-14 10:09:02,234 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,234 (PackageDeploymentServlet.java:execute:142)   PackageVersion: LATEST
2011-12-14 10:09:02,235 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,235 (PackageDeploymentServlet.java:execute:143)   PackageIsLatest: true
2011-12-14 10:09:02,235 INFO  [STDOUT] (http-0.0.0.0-8080-5) INFO  14-12 10:09:02,235 (PackageDeploymentServlet.java:execute:144)   PackageIsSource: false
2011-12-14 10:09:02,534 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from Guvnor: com.opmex.test2
2011-12-14 10:09:02,534 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from Guvnor: com.sample.bpmn.sampleHTformvariables
2011-12-14 10:09:03,060 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from file system: Evaluation.bpmn
2011-12-14 10:09:04,430 INFO  [STDOUT] (http-0.0.0.0-8080-4) (null: 18, 63): cvc-id.2: There are multiple occurrences of ID value '_2_ContentInput'.
2011-12-14 10:09:04,430 INFO  [STDOUT] (http-0.0.0.0-8080-4) (null: 18, 63): cvc-attribute.3: The value '_2_ContentInput' of attribute 'id' on element 'bpmn2:dataInput' is not valid with respect to its type, 'ID'.
2011-12-14 10:09:04,448 INFO  [STDOUT] (http-0.0.0.0-8080-4) (null: 137, 67): cvc-complex-type.2.4.a: Invalid content was found starting with element 'bpmn2:property'. One of '{"http://www.omg.org/spec/BPMN/20100524/MODEL":flowElement, "http://www.omg.org/spec/BPMN/20100524/MODEL":artifact, "http://www.omg.org/spec/BPMN/20100524/MODEL":resourceRole, "http://www.omg.org/spec/BPMN/20100524/MODEL":correlationSubscription, "http://www.omg.org/spec/BPMN/20100524/MODEL":supports}' is expected.
2011-12-14 10:09:04,993 INFO  [org.hibernate.cfg.Configuration] (http-0.0.0.0-8080-4) Reading mappings from resource : META-INF/JBPMorm.xml
2011-12-14 10:09:05,042 INFO  [org.hibernate.cfg.annotations.QueryBinder] (http-0.0.0.0-8080-4) Binding Named query: ProcessInstancesWaitingForEvent => select processInstanceInfo.processInstanceId from ProcessInstanceInfo processInstanceInfo where :type in elements(processInstanceInfo.eventTypes)
2011-12-14 10:09:05,042 INFO  [org.hibernate.cfg.AnnotationBinder] (http-0.0.0.0-8080-4) Binding entity from annotated class: org.jbpm.persistence.processinstance.ProcessInstanceInfo
2011-12-14 10:09:05,042 INFO  [org.hibernate.cfg.annotations.EntityBinder] (http-0.0.0.0-8080-4) Bind entity org.jbpm.persistence.processinstance.ProcessInstanceInfo on table ProcessInstanceInfo
2011-12-14 10:09:05,051 INFO  [org.hibernate.cfg.AnnotationBinder] (http-0.0.0.0-8080-4) Binding entity from annotated class: org.drools.persistence.info.SessionInfo
2011-12-14 10:09:05,057 INFO  [org.hibernate.cfg.annotations.EntityBinder] (http-0.0.0.0-8080-4) Bind entity org.drools.persistence.info.SessionInfo on table SessionInfo
2011-12-14 10:09:05,058 INFO  [org.hibernate.cfg.AnnotationBinder] (http-0.0.0.0-8080-4) Binding entity from annotated class: org.drools.persistence.info.WorkItemInfo
2011-12-14 10:09:05,058 INFO  [org.hibernate.cfg.annotations.EntityBinder] (http-0.0.0.0-8080-4) Bind entity org.drools.persistence.info.WorkItemInfo on table WorkItemInfo
2011-12-14 10:09:05,089 INFO  [org.hibernate.cfg.search.HibernateSearchEventListenerRegister] (http-0.0.0.0-8080-4) Unable to find org.hibernate.search.event.FullTextIndexEventListener on the classpath. Hibernate Search is not enabled.
2011-12-14 10:09:05,102 INFO  [org.hibernate.util.NamingHelper] (http-0.0.0.0-8080-4) JNDI InitialContext properties:{}
2011-12-14 10:09:05,103 INFO  [org.hibernate.connection.DatasourceConnectionProvider] (http-0.0.0.0-8080-4) Using datasource: java:jdbc/testDS1
2011-12-14 10:09:05,110 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) RDBMS: MySQL, version: 5.1.52
2011-12-14 10:09:05,110 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC driver: MySQL-AB JDBC Driver, version: mysql-connector-java-5.1.18 ( Revision: tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq )
2011-12-14 10:09:05,110 INFO  [org.hibernate.dialect.Dialect] (http-0.0.0.0-8080-4) Using dialect: org.hibernate.dialect.MySQLDialect
2011-12-14 10:09:05,110 INFO  [org.hibernate.transaction.TransactionFactoryFactory] (http-0.0.0.0-8080-4) Transaction strategy: org.hibernate.ejb.transaction.JoinableCMTTransactionFactory
2011-12-14 10:09:05,111 INFO  [org.hibernate.transaction.TransactionManagerLookupFactory] (http-0.0.0.0-8080-4) No TransactionManagerLookup configured (in JTA environment, use of read-write or transactional second-level cache is not recommended)
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Automatic flush during beforeCompletion(): disabled
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Automatic session close at end of transaction: disabled
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC batch size: 15
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC batch updates for versioned data: disabled
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Scrollable result sets: enabled
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC3 getGeneratedKeys(): enabled
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Connection release mode: auto
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Maximum outer join fetch depth: 3
2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Default batch fetch size: 1
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Generate SQL with comments: disabled
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Order SQL updates by primary key: disabled
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Order SQL inserts for batching: disabled
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
2011-12-14 10:09:05,117 INFO  [org.hibernate.hql.ast.ASTQueryTranslatorFactory] (http-0.0.0.0-8080-4) Using ASTQueryTranslatorFactory
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Query language substitutions: {}
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JPA-QL strict compliance: enabled
2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Second-level cache: enabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Query cache: disabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Cache region factory : org.hibernate.cache.impl.NoCachingRegionFactory
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Optimize cache for minimal puts: disabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Structured second-level cache entries: disabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Statistics: disabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Deleted entity synthetic identifier rollback: disabled
2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Default entity-mode: pojo
2011-12-14 10:09:05,119 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Named query checking : enabled
2011-12-14 10:09:05,132 INFO  [org.hibernate.impl.SessionFactoryImpl] (http-0.0.0.0-8080-4) building session factory
2011-12-14 10:09:05,148 INFO  [org.hibernate.impl.SessionFactoryObjectFactory] (http-0.0.0.0-8080-4) Not binding factory to JNDI, no JNDI name configured
2011-12-14 10:09:05,163 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (http-0.0.0.0-8080-4) Running hbm2ddl schema export
2011-12-14 10:09:05,163 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (http-0.0.0.0-8080-4) exporting generated schema to database
2011-12-14 10:09:05,211 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (http-0.0.0.0-8080-4) schema export complete
2011-12-14 10:09:05,213 ERROR [org.apache.catalina.core.ContainerBase.[jboss.web].[localhost].[/gwt-console-server].[Resteasy]] (http-0.0.0.0-8080-4) Servlet.service() for servlet Resteasy threw exception
org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Could not initialize stateful knowledge session: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:319)
at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:230)
at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:206)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:360)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)
at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)
at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)
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:235)
at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)
at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)
at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)
at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)
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:158)
at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)
at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)
at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)
at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
at java.lang.Thread.run(Thread.java:662)
Caused by: java.lang.RuntimeException: Could not initialize stateful knowledge session: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:185)
at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:193)
at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:71)
at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)
at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)
at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)
at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)
at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)
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:597)
at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)
at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)
at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)
at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)
at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)
... 28 more
Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)
at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)
at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)
at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:131)
... 45 more
Caused by: org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager
at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:361)
at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)
at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)
at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)
... 49 more



Reply to this message by going to Community

Start a new discussion in jBPM at Community