8:16 p.m.
Jimmy dong [http://community.jboss.org/people/jimmy.dongjia] created the discussion
"Re: Help!After replacing H2 to mysql,getting errors in the process tab!"
To view the discussion, visit: http://community.jboss.org/message/641410#641410
--------------------------------------------------------------
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":flowElement),
"http://www.omg.org/spec/BPMN/20100524/MODEL":artifact
(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":resourceRole),
"http://www.omg.org/spec/BPMN/20100524/MODEL":correlationSubscription
(http://www.omg.org/spec/BPMN/20100524/MODEL":correlationSubscrip...),
"http://www.omg.org/spec/BPMN/20100524/MODEL":supports}'
(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(a)oracle.com-20110930151701-jfj14ddfq48ifkfq
(mailto: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
[http://community.jboss.org/message/641410#641410]
Start a new discussion in jBPM at Community
[http://community.jboss.org/choose-container!input.jspa?contentType=1&...]