JBPM7.0.0 Final(with MYSQL database)

[anuj....@ilfstechnologies.com]

i am getting geiven below err.plz help

HH000204: Processing PersistenceUnitInfo [

name: org.jbpm.domain

...]

2017-07-28 17:34:48,209 INFO  [org.hibernate.Version] (ServerService Thread Pool -- 68) HHH000412: Hibernate Core {5.1.4.Final}

2017-07-28 17:34:48,212 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 68) HHH000206: hibernate.properties not found

2017-07-28 17:34:48,214 INFO  [org.hibernate.cfg.Environment] (ServerService Thread Pool -- 68) HHH000021: Bytecode provider name : javassist

2017-07-28 17:34:48,251 INFO  [org.hibernate.annotations.common.Version] (ServerService Thread Pool -- 68) HCANN000001: Hibernate Commons Annotations {5.0.1.Final}

2017-07-28 17:34:49,159 INFO  [org.hibernate.dialect.Dialect] (ServerService Thread Pool -- 68) HHH000400: Using dialect: org.hibernate.dialect.H2Dialect

2017-07-28 17:34:49,165 WARN  [org.hibernate.dialect.H2Dialect] (ServerService Thread Pool -- 68) HHH000431: Unable to determine H2 database version, certain features may not work

2017-07-28 17:34:50,610 INFO  [org.jboss.weld.deployer] (MSC service thread 1-6) WFLYWELD0003: Processing weld deployment jbpm-casemgmt.war

2017-07-28 17:34:50,702 INFO  [org.apache.deltaspike.core.util.ProjectStageProducer] (MSC service thread 1-6) Computed the following DeltaSpike ProjectStage: Production

2017-07-28 17:34:50,710 INFO  [org.jboss.errai.enterprise.rebind.NonGwtEventQualifierSerializerGenerator] (MSC service thread 1-6) Attempting to load org.jboss.errai.cdi.EventQualifierSerializerImpl

2017-07-28 17:34:50,714 INFO  [org.jboss.errai.codegen.util.ClassChangeUtil] (MSC service thread 1-6) Searching for class: org.jboss.errai.cdi.EventQualifierSerializerImpl

2017-07-28 17:34:50,725 INFO  [org.jboss.errai.codegen.util.ClassChangeUtil] (MSC service thread 1-6) Could not find URL for org.jboss.errai.cdi.EventQualifierSerializerImpl. Attempting to load with context class loader.

2017-07-28 17:34:50,729 INFO  [org.jboss.errai.codegen.util.ClassChangeUtil] (MSC service thread 1-6) Successfully loaded org.jboss.errai.cdi.EventQualifierSerializerImpl with context class loader.

2017-07-28 17:34:50,729 INFO  [org.jboss.errai.enterprise.rebind.NonGwtEventQualifierSerializerGenerator] (MSC service thread 1-6) Successfully loaded org.jboss.errai.cdi.EventQualifierSerializerImpl

2017-07-28 17:34:50,761 INFO  [org.jboss.as.ejb3.deployment] (MSC service thread 1-6) WFLYEJB0473: JNDI bindings for session bean named 'SimpleAsyncExecutorService' in deployment unit 'deployment "jbpm-casemgmt.war"' are as follows:

java:global/jbpm-casemgmt/SimpleAsyncExecutorService!org.uberfire.commons.async.DisposableExecutor

java:app/jbpm-casemgmt/SimpleAsyncExecutorService!org.uberfire.commons.async.DisposableExecutor

java:module/SimpleAsyncExecutorService!org.uberfire.commons.async.DisposableExecutor

java:global/jbpm-casemgmt/SimpleAsyncExecutorService

java:app/jbpm-casemgmt/SimpleAsyncExecutorService

java:module/SimpleAsyncExecutorService

2017-07-28 17:34:50,762 INFO  [org.jboss.as.ejb3.deployment] (MSC service thread 1-6) WFLYEJB0473: JNDI bindings for session bean named 'AlternativeStarterBean' in deployment unit 'deployment "jbpm-casemgmt.war"' are as follows:

java:global/jbpm-casemgmt/AlternativeStarterBean!org.uberfire.backend.server.cdi.AlternativeStarterBean

java:app/jbpm-casemgmt/AlternativeStarterBean!org.uberfire.backend.server.cdi.AlternativeStarterBean

java:module/AlternativeStarterBean!org.uberfire.backend.server.cdi.AlternativeStarterBean

java:global/jbpm-casemgmt/AlternativeStarterBean

java:app/jbpm-casemgmt/AlternativeStarterBean

java:module/AlternativeStarterBean

2017-07-28 17:34:50,762 INFO  [org.jboss.as.ejb3.deployment] (MSC service thread 1-6) WFLYEJB0473: JNDI bindings for session bean named 'IOWatchServiceExecutorImpl' in deployment unit 'deployment "jbpm-casemgmt.war"' are as follows:

java:global/jbpm-casemgmt/IOWatchServiceExecutorImpl!org.uberfire.backend.server.io.watch.IOWatchServiceExecutor

java:app/jbpm-casemgmt/IOWatchServiceExecutorImpl!org.uberfire.backend.server.io.watch.IOWatchServiceExecutor

java:module/IOWatchServiceExecutorImpl!org.uberfire.backend.server.io.watch.IOWatchServiceExecutor

java:global/jbpm-casemgmt/IOWatchServiceExecutorImpl

java:app/jbpm-casemgmt/IOWatchServiceExecutorImpl

java:module/IOWatchServiceExecutorImpl

2017-07-28 17:34:51,135 WARN  [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 68) SQL Error: 1109, SQLState: 42S02

2017-07-28 17:34:51,135 ERROR [org.hibernate.engine.jdbc.spi.SqlExceptionHelper] (ServerService Thread Pool -- 68) Unknown table 'sequences' in information_schema

2017-07-28 17:34:51,138 ERROR [org.kie.server.services.impl.KieServerImpl] (ServerService Thread Pool -- 68) Error when initializing server extension of type jBPM KIE Server extension: java.lang.RuntimeException: Unable to create EntityManagerFactory due to [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory

at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:701)

at org.kie.server.services.jbpm.JbpmKieServerExtension.init(JbpmKieServerExtension.java:186)

at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:120)

at org.kie.server.services.impl.KieServerImpl.<init>(KieServerImpl.java:97)

at org.kie.server.services.impl.KieServerLocator.<clinit>(KieServerLocator.java:20)

at org.kie.server.services.Bootstrap.contextInitialized(Bootstrap.java:49)

at io.undertow.servlet.core.ApplicationListeners.contextInitialized(ApplicationListeners.java:187)

at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:200)

at io.undertow.servlet.core.DeploymentManagerImpl$1.call(DeploymentManagerImpl.java:171)

at io.undertow.servlet.core.ServletRequestContextThreadSetupAction$1.call(ServletRequestContextThreadSetupAction.java:42)

at io.undertow.servlet.core.ContextClassLoaderSetupAction$1.call(ContextClassLoaderSetupAction.java:43)

at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)

at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)

at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)

at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)

at io.undertow.servlet.api.LegacyThreadSetupActionWrapper$1.call(LegacyThreadSetupActionWrapper.java:44)

at io.undertow.servlet.core.DeploymentManagerImpl.deploy(DeploymentManagerImpl.java:234)

at org.wildfly.extension.undertow.deployment.UndertowDeploymentService.startContext(UndertowDeploymentService.java:100)

at org.wildfly.extension.undertow.deployment.UndertowDeploymentService$1.run(UndertowDeploymentService.java:82)

at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:511)

at java.util.concurrent.FutureTask.run(FutureTask.java:266)

at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1142)

at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:617)

at java.lang.Thread.run(Thread.java:748)

at org.jboss.threads.JBossThread.run(JBossThread.java:320)

Caused by: javax.persistence.PersistenceException: [PersistenceUnit: org.jbpm.domain] Unable to build Hibernate SessionFactory

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.persistenceException(EntityManagerFactoryBuilderImpl.java:953)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:883)

at org.hibernate.jpa.HibernatePersistenceProvider.createContainerEntityManagerFactory(HibernatePersistenceProvider.java:135)

at org.kie.server.services.jbpm.JbpmKieServerExtension.build(JbpmKieServerExtension.java:699)

... 24 more

Caused by: org.hibernate.exception.SQLGrammarException: Unable to build DatabaseInformation

at org.hibernate.exception.internal.SQLExceptionTypeDelegate.convert(SQLExceptionTypeDelegate.java:63)

at org.hibernate.exception.internal.StandardSQLExceptionConverter.convert(StandardSQLExceptionConverter.java:42)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:111)

at org.hibernate.engine.jdbc.spi.SqlExceptionHelper.convert(SqlExceptionHelper.java:97)

at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:138)

at org.hibernate.tool.schema.internal.AbstractSchemaMigrator.doMigration(AbstractSchemaMigrator.java:92)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.performDatabaseAction(SchemaManagementToolCoordinator.java:176)

at org.hibernate.tool.schema.spi.SchemaManagementToolCoordinator.process(SchemaManagementToolCoordinator.java:65)

at org.hibernate.internal.SessionFactoryImpl.<init>(SessionFactoryImpl.java:459)

at org.hibernate.boot.internal.SessionFactoryBuilderImpl.build(SessionFactoryBuilderImpl.java:465)

at org.hibernate.jpa.boot.internal.EntityManagerFactoryBuilderImpl.build(EntityManagerFactoryBuilderImpl.java:880)

... 26 more

Caused by: com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: Unknown table 'sequences' in information_schema

at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)

at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)

at java.lang.reflect.Constructor.newInstance(Constructor.java:423)

at com.mysql.jdbc.Util.handleNewInstance(Util.java:411)

at com.mysql.jdbc.Util.getInstance(Util.java:386)

at com.mysql.jdbc.SQLError.createSQLException(SQLError.java:1052)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3609)

at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:3541)

at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:2002)

at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:2163)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2618)

at com.mysql.jdbc.ConnectionImpl.execSQL(ConnectionImpl.java:2568)

at com.mysql.jdbc.StatementImpl.executeQuery(StatementImpl.java:1557)

at org.jboss.jca.adapters.jdbc.WrappedStatement.executeQuery(WrappedStatement.java:397)

at org.hibernate.tool.schema.extract.internal.SequenceInformationExtractorH2DatabaseImpl.extractMetadata(SequenceInformationExtractorH2DatabaseImpl.java:37)

at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.initializeSequences(DatabaseInformationImpl.java:65)

at org.hibernate.tool.schema.extract.internal.DatabaseInformationImpl.<init>(DatabaseInformationImpl.java:59)

at org.hibernate.tool.schema.internal.Helper.buildDatabaseInformation(Helper.java:130)

[Maciej Swiderski]

problem is with you configuration - it still uses H2 as hibernate dialect. You need to properly configure it via system properties:

-Dorg.kie.server.persistence.dialect=org.hibernate.dialect.MySQL5InnoDBDialect

See docs for kie server bootstrap switches.

Maciej

--
You received this message because you are subscribed to the Google Groups "jBPM Development" group.
To unsubscribe from this group and stop receiving emails from it, send an email to jbpm-developme...@googlegroups.com.
To post to this group, send email to jbpm-dev...@googlegroups.com.
To view this discussion on the web visit https://groups.google.com/d/msgid/jbpm-development/70615d21-e51f-40fa-bf37-0d1fb5cdf79d%40googlegroups.com.
For more options, visit https://groups.google.com/d/optout.