Seam + MySQL + jBPM (integration problem)
Hi
I have got small aplication (jBPM, Seam, EJB, HypersonicDB, JBoss AS) - everything works, so I would like to switch database to MySQL. I have created new project (using seam-gen), in configuration set mySQL db, drivers... Then I have coppied all files from src, all from view folder, and all needed for jbpm resources. But when I try to deploy project I have got error:
10:00:36,327 INFO [HbmBinder] Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.swimlanes -> JBPM_SWIMLANE
10:00:36,327 INFO [HbmBinder] Mapping collection: org.jbpm.taskmgmt.def.TaskMgmtDefinition.tasks -> JBPM_TASK
10:00:36,327 INFO [HbmBinder] Mapping collection: org.jbpm.graph.action.Script.variableAccesses -> JBPM_VARIABLEACCESS
10:00:36,389 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
10:00:36,405 INFO [DatasourceConnectionProvider] Using datasource: java:/DefaultDS
10:00:36,405 INFO [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0
10:00:36,405 INFO [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0
10:00:36,420 INFO [Dialect] Using dialect: org.hibernate.dialect.HSQLDialect
10:00:36,420 INFO [TransactionFactoryFactory] Transaction strategy: org.hibernate.transaction.JTATransactionFactory
10:00:36,420 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
10:00:36,436 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
10:00:36,436 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
10:00:36,436 INFO [TransactionManagerLookupFactory] instantiating TransactionManagerLookup: org.hibernate.transaction.JBossTransactionManagerLookup
10:00:36,436 INFO [TransactionManagerLookupFactory] instantiated TransactionManagerLookup
10:00:36,436 INFO [SettingsFactory] Automatic flush during beforeCompletion(): disabled
10:00:36,436 INFO [SettingsFactory] Automatic session close at end of transaction: disabled
10:00:36,436 INFO [SettingsFactory] JDBC batch size: 15
10:00:36,436 INFO [SettingsFactory] JDBC batch updates for versioned data: disabled
10:00:36,436 INFO [SettingsFactory] Scrollable result sets: enabled
10:00:36,436 INFO [SettingsFactory] JDBC3 getGeneratedKeys(): disabled
10:00:36,436 INFO [SettingsFactory] Connection release mode: auto
10:00:36,436 INFO [SettingsFactory] Default batch fetch size: 1
10:00:36,436 INFO [SettingsFactory] Generate SQL with comments: disabled
10:00:36,436 INFO [SettingsFactory] Order SQL updates by primary key: disabled
10:00:36,436 INFO [SettingsFactory] Order SQL inserts for batching: disabled
10:00:36,436 INFO [SettingsFactory] Query translator: org.hibernate.hql.ast.ASTQueryTranslatorFactory
10:00:36,436 INFO [ASTQueryTranslatorFactory] Using ASTQueryTranslatorFactory
10:00:36,436 INFO [SettingsFactory] Query language substitutions: {}
10:00:36,436 INFO [SettingsFactory] JPA-QL strict compliance: disabled
10:00:36,436 INFO [SettingsFactory] Second-level cache: enabled
10:00:36,436 INFO [SettingsFactory] Query cache: disabled
10:00:36,436 INFO [SettingsFactory] Cache provider: org.hibernate.cache.HashtableCacheProvider
10:00:36,436 INFO [SettingsFactory] Optimize cache for minimal puts: disabled
10:00:36,436 INFO [SettingsFactory] Structured second-level cache entries: disabled
10:00:36,436 INFO [SettingsFactory] Echoing all SQL to stdout
10:00:36,436 INFO [SettingsFactory] Statistics: disabled
10:00:36,436 INFO [SettingsFactory] Deleted entity synthetic identifier rollback: disabled
10:00:36,436 INFO [SettingsFactory] Default entity-mode: pojo
10:00:36,436 INFO [SettingsFactory] Named query checking : enabled
10:00:36,436 INFO [SessionFactoryImpl] building session factory
10:00:39,592 INFO [SessionFactoryObjectFactory] Not binding factory to JNDI, no JNDI name configured
10:00:39,592 INFO [NamingHelper] JNDI InitialContext properties:{java.naming.factory.initial=org.jnp.interfaces.NamingContextFactory, java.naming.factory.url.pkgs=org.jboss.naming:org.jnp.interfaces}
10:00:40,842 INFO [STDOUT] Hibernate: select top ? processdef0_.ID_ as ID1_2_, processdef0_.NAME_ as NAME3_2_, processdef0_.DESCRIPTION_ as DESCRIPT4_2_, processdef0_.VERSION_ as VERSION5_2_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_2_, processdef0_.STARTSTATE_ as STARTSTATE7_2_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc
10:00:40,858 WARN [JDBCExceptionReporter] SQL Error: -22, SQLState: S0002
10:00:40,858 ERROR [JDBCExceptionReporter] Table not found in statement [select top ? processdef0_.ID_ as ID1_2_, processdef0_.NAME_ as NAME3_2_, processdef0_.DESCRIPTION_ as DESCRIPT4_2_, processdef0_.VERSION_ as VERSION5_2_, processdef0_.ISTERMINATIONIMPLICIT_ as ISTERMIN6_2_, processdef0_.STARTSTATE_ as STARTSTATE7_2_ from JBPM_PROCESSDEFINITION processdef0_ where processdef0_.NAME_=? order by processdef0_.VERSION_ desc]
10:00:41,061 ERROR [STDERR] org.hibernate.exception.SQLGrammarException: could not execute query
at org.hibernate.exception.SQLStateConverter.convert(SQLStateConverter.java:67)
at org.hibernate.exception.JDBCExceptionHelper.convert(JDBCExceptionHelper.java:43)
at org.hibernate.loader.Loader.doList(Loader.java:2223)
at org.hibernate.loader.Loader.listIgnoreQueryCache(Loader.java:2104)
at org.hibernate.loader.Loader.list(Loader.java:2099)
at org.hibernate.loader.hql.QueryLoader.list(QueryLoader.java:378)
at org.hibernate.hql.ast.QueryTranslatorImpl.list(QueryTranslatorImpl.java:338)
at org.hibernate.engine.query.HQLQueryPlan.performList(HQLQueryPlan.java:172)
at org.hibernate.impl.SessionImpl.list(SessionImpl.java:1121)
at org.hibernate.impl.QueryImpl.list(QueryImpl.java:79)
at org.hibernate.impl.AbstractQueryImpl.uniqueResult(AbstractQueryImpl.java:811)
at org.jbpm.db.GraphSession.findLatestProcessDefinition(GraphSession.java:153)
at org.jbpm.db.GraphSession.deployProcessDefinition(GraphSession.java:67)
at org.jbpm.JbpmContext.deployProcessDefinition(JbpmContext.java:173)
at org.jboss.seam.bpm.Jbpm.deployProcess(Jbpm.java:274)
at org.jboss.seam.bpm.Jbpm.installProcessDefinitions(Jbpm.java:252)
at org.jboss.seam.bpm.Jbpm.startup(Jbpm.java:72)
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.util.Reflections.invokeAndWrap(Reflections.java:125)
at org.jboss.seam.Component.callComponentMethod(Component.java:2092)
at org.jboss.seam.Component.callCreateMethod(Component.java:2015)
at org.jboss.seam.Component.newInstance(Component.java:1976)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:304)
at org.jboss.seam.contexts.Contexts.startup(Contexts.java:278)
at org.jboss.seam.contexts.ServletLifecycle.endInitialization(ServletLifecycle.java:95)
at org.jboss.seam.init.Initialization.init(Initialization.java:596)
at org.jboss.seam.servlet.SeamListener.contextInitialized(SeamListener.java:34)
at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:3856)
at org.apache.catalina.core.StandardContext.start(StandardContext.java:4361)
at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:790)
at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:770)
at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:553)
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.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.apache.catalina.core.StandardContext.init(StandardContext.java:5312)
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.apache.tomcat.util.modeler.BaseModelMBean.invoke(BaseModelMBean.java:296)
at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:164)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.web.tomcat.service.TomcatDeployer.performDeployInternal(TomcatDeployer.java:301)
at org.jboss.web.tomcat.service.TomcatDeployer.performDeploy(TomcatDeployer.java:104)
at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:375)
at org.jboss.web.WebModule.startModule(WebModule.java:83)
at org.jboss.web.WebModule.startService(WebModule.java:61)
at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:289)
at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:245)
at sun.reflect.GeneratedMethodAccessor3.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:978)
at $Proxy0.start(Unknown Source)
at org.jboss.system.ServiceController.start(ServiceController.java:417)
at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:86)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy44.start(Unknown Source)
at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:466)
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.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:97)
at org.jboss.system.InterceptorServiceMBeanSupport.invokeNext(InterceptorServiceMBeanSupport.java:238)
at org.jboss.wsf.container.jboss42.DeployerInterceptor.start(DeployerInterceptor.java:87)
at org.jboss.deployment.SubDeployerInterceptorSupport$XMBeanInterceptor.start(SubDeployerInterceptorSupport.java:188)
at org.jboss.deployment.SubDeployerInterceptor.invoke(SubDeployerInterceptor.java:95)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:264)
at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:659)
at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:210)
at $Proxy45.start(Unknown Source)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1025)
at org.jboss.deployment.MainDeployer.start(MainDeployer.java:1015)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:819)
at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:782)
at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
at sun.reflect.DelegatingMethodAccessorImpl.invoke(Unknown Source)
at java.lang.reflect.Method.invoke(Unknown Source)
at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:155)
at org.jboss.mx.server.Invocation.dispatch(Invocation.java:94)
at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:133)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:142)
at org.jboss.mx.server.Invocation.invoke(Invocation.java:88)
at org.jboss.mx.server.AbLines
10:00:36,405 INFO [DatasourceConnectionProvider] Using datasource: java:/DefaultDS 10:00:36,405 INFO [SettingsFactory] RDBMS: HSQL Database Engine, version: 1.8.0 10:00:36,405 INFO [SettingsFactory] JDBC driver: HSQL Database Engine Driver, version: 1.8.0
looks strangely
Could anyone help me?
Thanks and regards
Jakub Naruszewicz
