<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<html>
<body link="#355491" alink="#4262a1" vlink="#355491" style="background: #e2e2e2; margin: 0; padding: 20px;">
<div>
<table cellpadding="0" bgcolor="#FFFFFF" border="0" cellspacing="0" style="border: 1px solid #dadada; margin-bottom: 30px; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td>
<table border="0" cellpadding="0" cellspacing="0" bgcolor="#FFFFFF" style="border: solid 2px #ccc; background: #dadada; width: 100%; -moz-border-radius: 6px; -webkit-border-radius: 6px;">
<tbody>
<tr>
<td bgcolor="#000000" valign="middle" height="58px" style="border-bottom: 1px solid #ccc; padding: 20px; -moz-border-radius-topleft: 3px; -moz-border-radius-topright: 3px; -webkit-border-top-right-radius: 5px; -webkit-border-top-left-radius: 5px;">
<h1 style="color: #333333; font: bold 22px Arial, Helvetica, sans-serif; margin: 0; display: block !important;">
<!-- To have a header image/logo replace the name below with your img tag -->
<!-- Email clients will render the images when the message is read so any image -->
<!-- must be made available on a public server, so that all recipients can load the image. -->
<a href="http://community.jboss.org/index.jspa" style="text-decoration: none; color: #E1E1E1">JBoss Community</a></h1>
</td>
</tr>
<tr>
<td bgcolor="#FFFFFF" style="font: normal 12px Arial, Helvetica, sans-serif; color:#333333; padding: 20px; -moz-border-radius-bottomleft: 4px; -moz-border-radius-bottomright: 4px; -webkit-border-bottom-right-radius: 5px; -webkit-border-bottom-left-radius: 5px;"><h3 style="margin: 10px 0 5px; font-size: 17px; font-weight: normal;">
Re: Help!After replacing H2 to mysql,getting errors in the process tab!
</h3>
<span style="margin-bottom: 10px;">
created by <a href="http://community.jboss.org/people/jimmy.dongjia">Jimmy dong</a> in <i>jBPM</i> - <a href="http://community.jboss.org/message/641410#641410">View the full discussion</a>
</span>
<hr style="margin: 20px 0; border: none; background-color: #dadada; height: 1px;">
<div class="jive-rendered-content"><p>Yes,just now I found the datasource of jboss is wrong,I modified <span lang="EN-US" style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; color: red; font-size: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">testDS1-ds.xml and the datasource is ok,but it also has something wrong:</span></p><p><span lang="EN-US" style="font-family: &quot;Times New Roman&quot;,&quot;serif&quot;; color: red; font-size: 10.5pt; mso-bidi-font-size: 12.0pt; mso-fareast-font-family: 宋体; mso-font-kerning: 1.0pt; mso-ansi-language: EN-US; mso-fareast-language: ZH-CN; mso-bidi-language: AR-SA;">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<br/>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.<br/>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<br/>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<br/>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<br/>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<br/>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<br/>2011-12-14 10:09:02,534 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from Guvnor: com.opmex.test2<br/>2011-12-14 10:09:02,534 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from Guvnor: com.sample.bpmn.sampleHTformvariables<br/>2011-12-14 10:09:03,060 INFO  [STDOUT] (http-0.0.0.0-8080-4) Loading process from file system: Evaluation.bpmn<br/>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'.<br/>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'.<br/>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 '{"<a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL&quot;:flowElement">http://www.omg.org/spec/BPMN/20100524/MODEL":flowElement</a>, "<a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL&quot;:artifact">http://www.omg.org/spec/BPMN/20100524/MODEL":artifact</a>, "<a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL&quot;:resourceRole">http://www.omg.org/spec/BPMN/20100524/MODEL":resourceRole</a>, "<a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL&quot;:correlationSubscription">http://www.omg.org/spec/BPMN/20100524/MODEL":correlationSubscription</a>, "<a class="jive-link-external-small" href="http://www.omg.org/spec/BPMN/20100524/MODEL&quot;:supports}'">http://www.omg.org/spec/BPMN/20100524/MODEL":supports}'</a> is expected.<br/>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<br/>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)<br/>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<br/>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<br/>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<br/>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<br/>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<br/>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<br/>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.<br/>2011-12-14 10:09:05,102 INFO  [org.hibernate.util.NamingHelper] (http-0.0.0.0-8080-4) JNDI InitialContext properties:{}<br/>2011-12-14 10:09:05,103 INFO  [org.hibernate.connection.DatasourceConnectionProvider] (http-0.0.0.0-8080-4) Using datasource: java:jdbc/testDS1<br/>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<br/>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: <a class="jive-link-email-small" href="mailto:tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq">tonci.grgin@oracle.com-20110930151701-jfj14ddfq48ifkfq</a> )<br/>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<br/>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<br/>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)<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Automatic flush during beforeCompletion(): disabled<br/>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<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC batch size: 15<br/>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<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Scrollable result sets: enabled<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JDBC3 getGeneratedKeys(): enabled<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Connection release mode: auto<br/>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<br/>2011-12-14 10:09:05,111 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Default batch fetch size: 1<br/>2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Generate SQL with comments: disabled<br/>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<br/>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<br/>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<br/>2011-12-14 10:09:05,117 INFO  [org.hibernate.hql.ast.ASTQueryTranslatorFactory] (http-0.0.0.0-8080-4) Using ASTQueryTranslatorFactory<br/>2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Query language substitutions: {}<br/>2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) JPA-QL strict compliance: enabled<br/>2011-12-14 10:09:05,117 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Second-level cache: enabled<br/>2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Query cache: disabled<br/>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<br/>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<br/>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<br/>2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Statistics: disabled<br/>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<br/>2011-12-14 10:09:05,118 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Default entity-mode: pojo<br/>2011-12-14 10:09:05,119 INFO  [org.hibernate.cfg.SettingsFactory] (http-0.0.0.0-8080-4) Named query checking : enabled<br/>2011-12-14 10:09:05,132 INFO  [org.hibernate.impl.SessionFactoryImpl] (http-0.0.0.0-8080-4) building session factory<br/>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<br/>2011-12-14 10:09:05,163 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (http-0.0.0.0-8080-4) Running hbm2ddl schema export<br/>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<br/>2011-12-14 10:09:05,211 INFO  [org.hibernate.tool.hbm2ddl.SchemaExport] (http-0.0.0.0-8080-4) schema export complete<br/>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<br/>org.jboss.resteasy.spi.UnhandledException: java.lang.RuntimeException: Could not initialize stateful knowledge session: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory<br/> at org.jboss.resteasy.core.SynchronousDispatcher.handleApplicationException(SynchronousDispatcher.java:319)<br/> at org.jboss.resteasy.core.SynchronousDispatcher.handleException(SynchronousDispatcher.java:230)<br/> at org.jboss.resteasy.core.SynchronousDispatcher.handleInvokerException(SynchronousDispatcher.java:206)<br/> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:360)<br/> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:173)<br/> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:93)<br/> at org.jboss.resteasy.plugins.server.servlet.HttpServletDispatcher.service(HttpServletDispatcher.java:68)<br/> at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)<br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)<br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br/> at org.jboss.bpm.console.server.util.GWTJsonFilter.doFilter(GWTJsonFilter.java:59)<br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br/> at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFilter.java:96)<br/> at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:235)<br/> at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)<br/> at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:235)<br/> at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)<br/> at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(SecurityAssociationValve.java:190)<br/> at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:525)<br/> at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValve.java:92)<br/> at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.process(SecurityContextEstablishmentValve.java:126)<br/> at org.jboss.web.tomcat.security.SecurityContextEstablishmentValve.invoke(SecurityContextEstablishmentValve.java:70)<br/> at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)<br/> at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)<br/> at org.jboss.web.tomcat.service.jca.CachedConnectionValve.invoke(CachedConnectionValve.java:158)<br/> at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)<br/> at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:330)<br/> at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:829)<br/> at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:598)<br/> at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)<br/> at java.lang.Thread.run(Thread.java:662)<br/>Caused by: java.lang.RuntimeException: Could not initialize stateful knowledge session: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory<br/> at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:185)<br/> at org.jbpm.integration.console.CommandDelegate.getSession(CommandDelegate.java:193)<br/> at org.jbpm.integration.console.CommandDelegate.<init>(CommandDelegate.java:71)<br/> at org.jbpm.integration.console.ProcessManagement.<init>(ProcessManagement.java:35)<br/> at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:22)<br/> at org.jbpm.integration.console.ManagementFactory.createProcessManagement(ManagementFactory.java:19)<br/> at org.jboss.bpm.console.server.ProcessMgmtFacade.getProcessManagement(ProcessMgmtFacade.java:98)<br/> at org.jboss.bpm.console.server.ProcessMgmtFacade.getDefinitionsJSON(ProcessMgmtFacade.java:122)<br/> at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)<br/> at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)<br/> at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)<br/> at java.lang.reflect.Method.invoke(Method.java:597)<br/> at org.jboss.resteasy.core.MethodInjectorImpl.invoke(MethodInjectorImpl.java:117)<br/> at org.jboss.resteasy.core.ResourceMethod.invokeOnTarget(ResourceMethod.java:260)<br/> at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:232)<br/> at org.jboss.resteasy.core.ResourceMethod.invoke(ResourceMethod.java:166)<br/> at org.jboss.resteasy.core.DispatcherUtilities.getJaxrsResponse(DispatcherUtilities.java:142)<br/> at org.jboss.resteasy.core.SynchronousDispatcher.invoke(SynchronousDispatcher.java:356)<br/> ... 28 more<br/>Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.persistence.jpa] Unable to build EntityManagerFactory<br/> at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:677)<br/> at org.hibernate.ejb.HibernatePersistence.createEntityManagerFactory(HibernatePersistence.java:126)<br/> at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:52)<br/> at javax.persistence.Persistence.createEntityManagerFactory(Persistence.java:34)<br/> at org.jbpm.integration.console.CommandDelegate.newStatefulKnowledgeSession(CommandDelegate.java:131)<br/> ... 45 more<br/>Caused by: org.hibernate.HibernateException: The chosen transaction strategy requires access to the JTA TransactionManager<br/> at org.hibernate.impl.SessionFactoryImpl.<init>(SessionFactoryImpl.java:361)<br/> at org.hibernate.cfg.Configuration.buildSessionFactory(Configuration.java:1327)<br/> at org.hibernate.cfg.AnnotationConfiguration.buildSessionFactory(AnnotationConfiguration.java:867)<br/> at org.hibernate.ejb.Ejb3Configuration.buildEntityManagerFactory(Ejb3Configuration.java:669)<br/> ... 49 more</span></p><div class="mcePaste" id="_mcePaste" style="position: absolute; top: 0px; left: 0px;"></div></div>
<div style="background-color: #f4f4f4; padding: 10px; margin-top: 20px;">
<p style="margin: 0;">Reply to this message by <a href="http://community.jboss.org/message/641410#641410">going to Community</a></p>
<p style="margin: 0;">Start a new discussion in jBPM at <a href="http://community.jboss.org/choose-container!input.jspa?contentType=1&containerType=14&container=2034">Community</a></p>
</div></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>
</div>
</body>
</html>