3 Replies Latest reply on May 14, 2009 12:59 PM by viral desai

    Seam + MySQL + jBPM (integration problem)

    Jakub Naruszewicz Newbie

      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.Ab



      Lines

      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