13 Replies Latest reply on Jan 26, 2007 6:16 AM by holly77

    jBPM with mysql errors

    maverick1611

      Hi I'm new to jbpm but have found it quite useful. i played around with it using the hypersonic database and got everything running in half a days time .. but now i want to run it with mysql and have got stuck .. I went through a few posts regarding jbpm on mysql but still get errors after following all instructions:
      http://www.jboss.org/?module=bb&op=viewtopic&t=71848
      http://www.jboss.com/index.html?module=bb&op=viewtopic&t=66899

      I'm using jbpm 3.0.2 (starter kit) and mysql 4.1.15 . I created the jbpm database in mysql using the mysql scripts... made changes to the jbpm.hibernate.properties and jbpm.hibernate.cfg.xml and jboss-service.xml in META-INF files in the jbpm.sar folder, created the mysql-ds.xml in the deploy folder, copied the mysql-connector-java-3.1.7.jar to the lib folder but i'm not able to get jbpm to use the mysql database instead of hypersonic ..

      Please let me know what i am missing here .. or is there another way of doing this ..

      here is the error that I get when i start my jboss server in the starter kit:
      ===============================================================================
      .
      JBoss Bootstrap Environment
      .
      JBOSS_HOME: D:\jbpm-starters-kit-3.0.2\jbpm-server\bin\\..
      .
      JAVA: D:\jdk1.5.0_05\bin\java
      .
      JAVA_OPTS: -Dprogram.name=run.bat -Xms128m -Xmx512m
      .
      CLASSPATH: D:\jdk1.5.0_05\lib\tools.jar;D:\jbpm-starters-kit-3.0.2\jbpm-server\bin\\run.jar
      .
      ===============================================================================
      .
      10:56:34,843 INFO [Server] Starting JBoss (MX MicroKernel)...
      10:56:34,843 INFO [Server] Release ID: JBoss [Zion] 4.0.3 (build: CVSTag=JBoss_4_0_3 date=200510042324)
      10:56:34,875 INFO [Server] Home Dir: D:\jbpm-starters-kit-3.0.2\jbpm-server
      10:56:34,875 INFO [Server] Home URL: file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/
      10:56:34,875 INFO [Server] Patch URL: null
      10:56:34,875 INFO [Server] Server Name: jbpm
      10:56:34,875 INFO [Server] Server Home Dir: D:\jbpm-starters-kit-3.0.2\jbpm-server\server\jbpm
      10:56:34,875 INFO [Server] Server Home URL: file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/
      10:56:34,875 INFO [Server] Server Temp Dir: D:\jbpm-starters-kit-3.0.2\jbpm-server\server\jbpm\tmp
      10:56:34,875 INFO [Server] Root Deployment Filename: jboss-service.xml
      10:56:35,687 INFO [ServerInfo] Java version: 1.5.0_05,Sun Microsystems Inc.
      10:56:35,687 INFO [ServerInfo] Java VM: Java HotSpot(TM) Client VM 1.5.0_05-b05,Sun Microsystems Inc.
      10:56:35,687 INFO [ServerInfo] OS-System: Windows 2000 5.0,x86
      10:56:36,656 INFO [Server] Core system initialized
      10:56:40,406 INFO [WebService] Using RMI server codebase: http://iqsrddemo2:8083/
      10:56:40,468 INFO [Log4jService$URLWatchTimerTask] Configuring from URL: resource:log4j.xml
      10:56:40,968 INFO [NamingService] Started jndi bootstrap jnpPort=1099, rmiPort=1098, backlog=50, bindAddress=/0.0.0.0, Client SocketFactory=null, Server SocketFactory=org.jboss.net.sockets.DefaultSocketFactory@ad093076
      10:56:45,812 INFO [Embedded] Catalina naming disabled
      10:56:46,703 INFO [Http11Protocol] Initializing Coyote HTTP/1.1 on http-0.0.0.0-8080
      10:56:46,718 INFO [Catalina] Initialization processed in 765 ms
      10:56:46,718 INFO [StandardService] Starting service jboss.web
      10:56:46,734 INFO [StandardEngine] Starting Servlet Engine: Apache Tomcat/5.5
      10:56:46,828 INFO [StandardHost] XML validation disabled
      10:56:46,890 INFO [Catalina] Server startup in 172 ms
      10:56:47,203 INFO [TomcatDeployer] deploy, ctxPath=/invoker, warUrl=.../deploy/http-invoker.sar/invoker.war/
      10:56:48,031 INFO [WebappLoader] Dual registration of jndi stream handler: factory already defined
      10:56:49,046 INFO [TomcatDeployer] deploy, ctxPath=/, warUrl=.../deploy/jbossweb-tomcat55.sar/ROOT.war/
      10:56:50,015 ERROR [MainDeployer] Could not create deployment: file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/deploy/jbpm.sar
      org.jboss.deployment.DeploymentException: Trying to install an already registered mbean: jboss.jbpm:name=DefaultJbpm,service=JbpmService
      at org.jboss.system.ServiceCreator.install(ServiceCreator.java:70)
      at org.jboss.system.ServiceConfigurator.internalInstall(ServiceConfigurator.java:431)
      at org.jboss.system.ServiceConfigurator.install(ServiceConfigurator.java:153)
      at org.jboss.system.ServiceController.install(ServiceController.java:215)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy4.install(Unknown Source)
      at org.jboss.deployment.SARDeployer.create(SARDeployer.java:232)
      at org.jboss.deployment.MainDeployer.create(MainDeployer.java:935)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:789)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy9.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:428)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
      at org.jboss.Main.boot(Main.java:187)
      at org.jboss.Main$1.run(Main.java:438)
      at java.lang.Thread.run(Thread.java:595)
      10:56:50,156 INFO [TomcatDeployer] deploy, ctxPath=/jbossmq-httpil, warUrl=.../deploy/jms/jbossmq-httpil.sar/jbossmq-httpil.war/
      10:56:54,046 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-local-jdbc.rar
      10:56:54,296 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jboss-xa-jdbc.rar
      10:56:54,578 INFO [RARDeployment] Required license terms exist, view META-INF/ra.xml in .../deploy/jms/jms-ra.rar
      10:56:56,984 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=DataSourceBinding,name=DefaultDS' to JNDI name 'java:DefaultDS'
      10:56:57,593 INFO [JbpmQueue] Bound to JNDI name: queue/JbpmQueue
      10:56:57,796 INFO [UILServerILService] JBossMQ UIL service available at : /0.0.0.0:8093
      10:56:57,890 INFO [DLQ] Bound to JNDI name: queue/DLQ
      10:56:58,265 INFO [ConnectionFactoryBindingService] Bound ConnectionManager 'jboss.jca:service=ConnectionFactoryBinding,name=JmsXA' to JNDI name 'java:JmsXA'
      10:56:58,453 ERROR [JBossErrorHandler] File .../deploy/mysql-ds.xml process fatal. Location: ; Line#: 427; Column#: 62. Error message: java.util.EmptyStackException
      10:56:59,515 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=.../tmp/deploy/tmp22344jbpm-exp.war/
      10:57:00,109 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
      10:57:00,218 INFO [FacesConfigurator] Reading config jar:file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/tmp/deploy/tmp22344jbpm-exp.war/WEB-INF/lib/tomahawk.jar!/META-INF/faces-config.xml
      10:57:00,296 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
      10:57:00,468 DEBUG [ApplicationFactory] New ApplicationFactory instance created
      10:57:00,484 ERROR [LocaleUtils] Locale name null or empty, ignoring
      10:57:01,453 INFO [StartupServletContextListener] ServletContext 'D:\jbpm-starters-kit-3.0.2\jbpm-server\server\jbpm\.\tmp\deploy\tmp22344jbpm-exp.war\' initialized.
      10:57:01,484 INFO [[/jbpm]] Marking servlet SchedulerServlet as unavailable
      10:57:01,484 ERROR [[/jbpm]] Error loading WebappClassLoader
      delegate: false
      repositories:
      ----------> Parent Classloader:
      java.net.FactoryURLClassLoader@12fcdf5
      org.jbpm.scheduler.impl.SchedulerServlet
      java.lang.ClassNotFoundException: org.jbpm.scheduler.impl.SchedulerServlet
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332)
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1027)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
      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:585)
      at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
      at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
      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:585)
      at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
      at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:280)
      at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:88)
      at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
      at org.jboss.web.WebModule.startModule(WebModule.java:68)
      at org.jboss.web.WebModule.startService(WebModule.java:46)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:428)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy25.start(Unknown Source)
      at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:400)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy26.start(Unknown Source)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy9.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:428)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
      at org.jboss.Main.boot(Main.java:187)
      at org.jboss.Main$1.run(Main.java:438)
      at java.lang.Thread.run(Thread.java:595)
      10:57:01,484 ERROR [[/jbpm]] Servlet /jbpm threw load() exception
      java.lang.ClassNotFoundException: org.jbpm.scheduler.impl.SchedulerServlet
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1332)
      at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1181)
      at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1027)
      at org.apache.catalina.core.StandardWrapper.load(StandardWrapper.java:925)
      at org.apache.catalina.core.StandardContext.loadOnStartup(StandardContext.java:3857)
      at org.apache.catalina.core.StandardContext.start(StandardContext.java:4118)
      at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:759)
      at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:739)
      at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:524)
      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:585)
      at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
      at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.apache.catalina.core.StandardContext.init(StandardContext.java:5005)
      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:585)
      at org.apache.commons.modeler.BaseModelMBean.invoke(BaseModelMBean.java:503)
      at org.jboss.mx.server.RawDynamicInvoker.invoke(RawDynamicInvoker.java:150)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeployInternal(TomcatDeployer.java:280)
      at org.jboss.web.tomcat.tc5.TomcatDeployer.performDeploy(TomcatDeployer.java:88)
      at org.jboss.web.AbstractWebDeployer.start(AbstractWebDeployer.java:357)
      at org.jboss.web.WebModule.startModule(WebModule.java:68)
      at org.jboss.web.WebModule.startService(WebModule.java:46)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:428)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy25.start(Unknown Source)
      at org.jboss.web.AbstractWebContainer.start(AbstractWebContainer.java:400)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.interceptor.DynamicInterceptor.invoke(DynamicInterceptor.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy26.start(Unknown Source)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      at sun.reflect.GeneratedMethodAccessor47.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy9.deploy(Unknown Source)
      at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
      at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
      at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
      at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
      at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
      at $Proxy0.start(Unknown Source)
      at org.jboss.system.ServiceController.start(ServiceController.java:428)
      at sun.reflect.GeneratedMethodAccessor9.invoke(Unknown Source)
      at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
      at java.lang.reflect.Method.invoke(Method.java:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy4.start(Unknown Source)
      at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
      at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
      at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
      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:585)
      at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
      at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
      at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
      at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
      at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
      at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
      at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
      at $Proxy5.deploy(Unknown Source)
      at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
      at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
      at org.jboss.Main.boot(Main.java:187)
      at org.jboss.Main$1.run(Main.java:438)
      at java.lang.Thread.run(Thread.java:595)
      10:57:01,609 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
      10:57:01,906 ERROR [URLDeploymentScanner] Incomplete Deployment listing:

      --- Incompletely deployed packages ---
      org.jboss.deployment.DeploymentInfo@5fafc824 { url=file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/deploy/jbpm.sar }
      deployer: org.jboss.deployment.SARDeployer@76ab2f
      status: Deployment FAILED reason: Trying to install an already registered mbean: jboss.jbpm:name=DefaultJbpm,service=JbpmService
      state: FAILED
      watch: file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/deploy/jbpm.sar
      altDD: null
      lastDeployed: 1132772209984
      lastModified: 1132772209390
      mbeans:

      --- MBeans waiting for other MBeans ---
      ObjectName: jboss.jbpm:name=DefaultJbpm,service=JbpmService
      State: CONFIGURED
      I Depend On:
      jboss.jca:service=DataSourceBinding,name=MySqlDS

      --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
      ObjectName: jboss.jca:service=DataSourceBinding,name=MySqlDS
      State: NOTYETINSTALLED
      Depends On Me:
      jboss.jbpm:name=DefaultJbpm,service=JbpmService


      10:57:02,281 INFO [Http11Protocol] Starting Coyote HTTP/1.1 on http-0.0.0.0-8080
      10:57:02,437 INFO [ChannelSocket] JK: ajp13 listening on /0.0.0.0:8009
      10:57:02,625 INFO [JkMain] Jk running ID=0 time=0/235 config=null
      10:57:02,640 INFO [Server] JBoss (MX MicroKernel) [4.0.3 (build: CVSTag=JBoss_4_0_3 date=200510042324)] Started in 27s:765ms

        • 1. Re: jBPM with mysql errors
          brianmb99

          Hi there,

          It looks like your jbpm is configured to use "MySqlDS" datasource. The example datasource at http://www.jboss.org/?module=bb&op=viewtopic&t=71848 uses "LocalMySqlDS" as the datasource binding name, so if you copied and pasted from there, that could be the problem. Jbpm needs to be configured to use the correct datasource name.

          -Brian

          • 2. Re: jBPM with mysql errors
            maverick1611

            no I tried it with both MySqlDS and LocalMySqlDS .. and got the same errors in both .. and i was consistent with using the same name throughout when i changed it to MySqlDS from LocalMySqlDS .. has anyone had sucess with chaing the datasource to MySql ..
            I have been able to create the jbpm tables using the MySQL scripts but thats about it .. how do i create the data for the websales example in the MySql database .. or rather who creates the data and how .. does deploying the webapp take care of creating the data for me ..
            Please help i'm stuck on this for quite some tiem now ..
            Thanks,
            mav

            • 3. Re: jBPM with mysql errors
              brianmb99

              Hi again Mav,

              1. I'm far from a JBoss expert, but this line in your server output looks suspicious to me:

              10:56:58,453 ERROR [JBossErrorHandler] File .../deploy/mysql-ds.xml process fatal. Location: ; Line#: 427; Column#: 62. Error message: java.util.EmptyStackException


              Are you sure that your mysql-ds file is cool?

              2. I am using jbpm 3.0.2 with MySQL 4.0.20nt and JBoss 4.0.2 successfully. I had it working fine with the starters-kit, too. So it's not a problem with the Jbpm code.

              3. Just deploying the web app to the deploy directory won't create the sample tables. There's an ant script you can run (I think it's in the jbpm-db download) that will create the demo tables in a database of your choosing. I just used the IDE and some code to deploy a custom process to MySQL for testing. The ant deploy script is easier than writing java code to deploy though, and it's more flexible (but if you're new to ant like me, it's perhaps not quite as straightforward for getting started).

              -Brian


              • 4. Re: jBPM with mysql errors
                maverick1611

                I finally managed to modify and run the ant scripts to create the jbpm table and populate them with the business process definition configuration. However there is one problem now .. I observed that there are no JMS_USERS and JMS_Roles tables in mySQL db .. these tables used to be created for hypersonic .. what files should i modify so that the JMS tables too get created in MySQL.

                • 5. Re: jBPM with mysql errors
                  maverick1611

                  finally got everything running on MySql .. now even though the websales example works without a problem i get the following errors when i start the jboss server.. any idea whats causing these errors ..

                  i'll make a list of steps i did to use MySQL instead of Hypersonic and post it in this thread shortly ..

                  13:56:39,671 WARN [ServiceController] Problem starting service jboss.mq:service=PersistenceManager
                  org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias)
                   at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:416)
                   at org.jboss.mq.pm.jdbc2.PersistenceManager.startService(PersistenceManager.java:1499)
                   at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
                   at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
                   at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                   at java.lang.reflect.Method.invoke(Method.java:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
                   at $Proxy0.start(Unknown Source)
                   at org.jboss.system.ServiceController.start(ServiceController.java:428)
                   at org.jboss.system.ServiceController.start(ServiceController.java:446)
                   at org.jboss.system.ServiceController.start(ServiceController.java:446)
                   at org.jboss.system.ServiceController.start(ServiceController.java:446)
                   at org.jboss.system.ServiceController.start(ServiceController.java:446)
                   at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
                   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                   at java.lang.reflect.Method.invoke(Method.java:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
                   at $Proxy4.start(Unknown Source)
                   at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
                   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:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.mx.util.JMXInvocationHandler.invoke(JMXInvocationHandler.java:273)
                   at $Proxy32.start(Unknown Source)
                   at org.jboss.deployment.XSLSubDeployer.start(XSLSubDeployer.java:185)
                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
                   at sun.reflect.GeneratedMethodAccessor46.invoke(Unknown Source)
                   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                   at java.lang.reflect.Method.invoke(Method.java:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
                   at $Proxy9.deploy(Unknown Source)
                   at org.jboss.deployment.scanner.URLDeploymentScanner.deploy(URLDeploymentScanner.java:319)
                   at org.jboss.deployment.scanner.URLDeploymentScanner.scan(URLDeploymentScanner.java:507)
                   at org.jboss.deployment.scanner.AbstractDeploymentScanner$ScannerThread.doScan(AbstractDeploymentScanner.java:192)
                   at org.jboss.deployment.scanner.AbstractDeploymentScanner.startService(AbstractDeploymentScanner.java:265)
                   at org.jboss.system.ServiceMBeanSupport.jbossInternalStart(ServiceMBeanSupport.java:274)
                   at org.jboss.system.ServiceMBeanSupport.jbossInternalLifecycle(ServiceMBeanSupport.java:230)
                   at sun.reflect.GeneratedMethodAccessor2.invoke(Unknown Source)
                   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                   at java.lang.reflect.Method.invoke(Method.java:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.system.ServiceController$ServiceProxy.invoke(ServiceController.java:943)
                   at $Proxy0.start(Unknown Source)
                   at org.jboss.system.ServiceController.start(ServiceController.java:428)
                   at sun.reflect.GeneratedMethodAccessor8.invoke(Unknown Source)
                   at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
                   at java.lang.reflect.Method.invoke(Method.java:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:72)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
                   at $Proxy4.start(Unknown Source)
                   at org.jboss.deployment.SARDeployer.start(SARDeployer.java:285)
                   at org.jboss.deployment.MainDeployer.start(MainDeployer.java:989)
                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:790)
                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:753)
                   at org.jboss.deployment.MainDeployer.deploy(MainDeployer.java:737)
                   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:585)
                   at org.jboss.mx.interceptor.ReflectedDispatcher.invoke(ReflectedDispatcher.java:141)
                   at org.jboss.mx.server.Invocation.dispatch(Invocation.java:80)
                   at org.jboss.mx.interceptor.AbstractInterceptor.invoke(AbstractInterceptor.java:118)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.interceptor.ModelMBeanOperationInterceptor.invoke(ModelMBeanOperationInterceptor.java:127)
                   at org.jboss.mx.server.Invocation.invoke(Invocation.java:74)
                   at org.jboss.mx.server.AbstractMBeanInvoker.invoke(AbstractMBeanInvoker.java:245)
                   at org.jboss.mx.server.MBeanServerImpl.invoke(MBeanServerImpl.java:644)
                   at org.jboss.mx.util.MBeanProxyExt.invoke(MBeanProxyExt.java:176)
                   at $Proxy5.deploy(Unknown Source)
                   at org.jboss.system.server.ServerImpl.doStart(ServerImpl.java:453)
                   at org.jboss.system.server.ServerImpl.start(ServerImpl.java:330)
                   at org.jboss.Main.boot(Main.java:187)
                   at org.jboss.Main$1.run(Main.java:438)
                   at java.lang.Thread.run(Thread.java:595)
                  Caused by: java.sql.SQLException: Every derived table must have its own alias
                   at com.mysql.jdbc.MysqlIO.checkErrorPacket(MysqlIO.java:2847)
                   at com.mysql.jdbc.MysqlIO.sendCommand(MysqlIO.java:1531)
                   at com.mysql.jdbc.MysqlIO.sqlQueryDirect(MysqlIO.java:1622)
                   at com.mysql.jdbc.Connection.execSQL(Connection.java:2376)
                   at com.mysql.jdbc.Connection.execSQL(Connection.java:2297)
                   at com.mysql.jdbc.PreparedStatement.executeInternal(PreparedStatement.java:1860)
                   at com.mysql.jdbc.PreparedStatement.executeQuery(PreparedStatement.java:1705)
                   at org.jboss.resource.adapter.jdbc.WrappedPreparedStatement.executeQuery(WrappedPreparedStatement.java:211)
                   at org.jboss.mq.pm.jdbc2.PersistenceManager.resolveAllUncommitedTXs(PersistenceManager.java:384)
                   ... 111 more
                  13:56:40,250 INFO [TomcatDeployer] deploy, ctxPath=/jbpm, warUrl=.../tmp/deploy/tmp17081jbpm-exp.war/
                  13:56:40,765 INFO [FacesConfigurator] Reading standard config org/apache/myfaces/resource/standard-faces-config.xml
                  13:56:40,843 INFO [FacesConfigurator] Reading config jar:file:/D:/jbpm-starters-kit-3.0.2/jbpm-server/server/jbpm/tmp/deploy/tmp17081jbpm-exp.war/WEB-INF/lib/tomahawk.jar!/META-INF/faces-config.xml
                  13:56:40,968 INFO [FacesConfigurator] Reading config /WEB-INF/faces-config.xml
                  13:56:41,125 DEBUG [ApplicationFactory] New ApplicationFactory instance created
                  13:56:41,140 ERROR [LocaleUtils] Locale name null or empty, ignoring
                  13:56:42,125 INFO [StartupServletContextListener] ServletContext 'D:\jbpm-starters-kit-3.0.2\jbpm-server\server\jbpm\.\tmp\deploy\tmp17081jbpm-exp.war\' initialized.
                  13:56:42,156 DEBUG [Scheduler] starting the scheduler
                  13:56:42,171 DEBUG [JbpmSessionFactory] fetching JbpmSessionFactory from 'java:/jbpm/JbpmSessionFactory'
                  13:56:42,296 INFO [TomcatDeployer] deploy, ctxPath=/jmx-console, warUrl=.../deploy/jmx-console.war/
                  13:56:42,500 DEBUG [SchedulerThread] checking for timers
                  13:56:44,406 ERROR [URLDeploymentScanner] Incomplete Deployment listing:
                  
                  --- MBeans waiting for other MBeans ---
                  ObjectName: jboss.mq:service=PersistenceManager
                   State: FAILED
                   Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias)
                   I Depend On:
                   jboss.jca:service=DataSourceBinding,name=MySqlDS
                   Depends On Me:
                   jboss.mq:service=DestinationManager
                  
                  --- MBEANS THAT ARE THE ROOT CAUSE OF THE PROBLEM ---
                  ObjectName: jboss.mq:service=PersistenceManager
                   State: FAILED
                   Reason: org.jboss.mq.SpyJMSException: Could not resolve uncommited transactions. Message recovery may not be accurate; - nested throwable: (java.sql.SQLException: Every derived table must have its own alias)
                   I Depend On:
                   jboss.jca:service=DataSourceBinding,name=MySqlDS
                   Depends On Me:
                   jboss.mq:service=DestinationManager
                  




                  • 6. Re: jBPM with mysql errors
                    maverick1611

                    Here are Steps To run jBPM 3.0.2 on MySql 4.1.15
                    Some of them might be unnecessary or redundant but if all of them are followed it surely gets jbpm running on MySql .. any additional comments are welcome .. thanks

                    1) Extract All files
                    2) Set up JAVA_HOME, PATH
                    3) Change TMP, TEMP directories to some folder like C:\TEMP

                    step1: under 'jbpm\lib', create 'mysql' directory

                    step2: copy mysql-connector-java-3.1.7-bin.jar from 'jbpm-db\mysql\lib'

                    to 'jbpm\lib\mysql' directory

                    step3: under 'jbpm\src\resources', create 'mysql' directory

                    step4: copy (create.db.hibernate.properties, identity.db.xml) from

                    'hsqldb' directory to 'mysql' directory

                    step5: Edit 'create.db.hibernate.properties' file with something like

                    this:

                    # innodb has acid compliance, might be best to use it?
                    hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

                    # could also be used maybe, see hibernate and mysql websites

                    for more info
                    # hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
                    # hibernate.dialect=org.hibernate.dialect.MySQLDialect

                    hibernate.connection.driver_class=com.mysql.jdbc.Driver
                    hibernate.connection.url=jdbc:mysql://localhost:3306/jbpm
                    hibernate.connection.username=root
                    hibernate.connection.password=

                    hibernate.show_sql=true
                    hibernate.query.substitutions=true 1, false 0
                    hibernate.c3p0.min_size=1
                    hibernate.c3p0.max_size=3

                    step6: under 'jbpm\src\resources\jbpm.sar' edit

                    jbpm.hibernate.properties with somehting like this

                    # innodb has acid compliance, might be best to use it?
                    hibernate.dialect=org.hibernate.dialect.MySQLInnoDBDialect

                    # could also be used maybe, see hibernate and mysql websites

                    for more info
                    # hibernate.dialect=org.hibernate.dialect.MySQLMyISAMDialect
                    # hibernate.dialect=org.hibernate.dialect.MySQLDialect

                    hibernate.connection.driver_class=com.mysql.jdbc.Driver
                    hibernate.connection.url=jdbc:mysql://localhost:3306/jbpm
                    hibernate.connection.username=root
                    hibernate.connection.password=

                    hibernate.show_sql=true
                    hibernate.query.substitutions=true 1, false 0
                    hibernate.c3p0.min_size=1
                    hibernate.c3p0.max_size=3


                    step7: under 'jbpm\src\resources\jbpm.sar\META-INF' edit

                    jboss-service.xml ..
                    replace 'DefaulsDS' with 'MySqlDS'

                    Step8: under 'jbpm\src\config.files' Edit hibernate.cfg.xml with

                    someething like this

                    <!-- jdbc connection properties -->
                    org.hibernate.dialect.MySQLInnoDBDialect
                    com.mysql.jdbc.Driver
                    jdbc:mysql://localhost:3306/jbpm
                    root


                    <!-- c3p0 connection pooling properties -->
                    1
                    3

                    step9: under 'jbpm' directory, edit the build.properties file with

                    something like this:

                    # jbpm.version only used for creating javadocs and the

                    distribution package
                    jbpm.version=3.0.2

                    # ant.home is only used in the ant.install.libs target for

                    copying the junit and clover libs
                    ant.home=D:\apache-ant-1.6.5

                    # jbpm.home is only to allow build scripts to open the browser

                    with the html test results
                    jbpm.home=D:\jbpm-starters-kit-3.0.2\jbpm

                    # jboss config proper only used for deployment
                    jboss.home=D:\jbpm-starters-kit-3.0.2\jbpm-server
                    jboss.version=4.0.2
                    jboss.source.configuration=jbpm

                    # for creating the distribution
                    jbpm.gpd.site.file=


                    step10: under 'jbpm' directory, edit ANT script

                    'build.deploy.xml' ,
                    find target name='create.db' and delete 'db.start' and delete

                    ''
                    in this block replace all 'hsqldb' with 'mysql' to modify the

                    paths of the xmls so it looks something like this:










                    step11: Delete or rename the 'jbpm\build' folder and run ANT

                    command 'ant -buildfile build.deploy.xml create.db'
                    when this task is success check to see that JBPM database has

                    33 tables. (mysql database should be started before running this

                    command)

                    step12: run ANT script command 'ant -buildfile build.deploy.xml

                    build.service.archive'
                    run ANT script command 'ant -buildfile build.deploy.xml

                    build.webapp'

                    step13: copy jbpm.war amd jbpm.sar.dir folder to

                    'jbpm-server\server\jbpm\deploy' and rename jbpm.sar.dir to jbpm.sar

                    step14: delete the hsqldb-ds.xml from 'jbpm-server\server\jbpm\deploy'

                    and copy mysql-ds.xml from 'jbpm-server\doc\examples\jca' to

                    'jbpm-server\server\jbpm\deploy' and modify it to somethign like this:

                    <?xml version="1.0" encoding="UTF-8"?>

                    <!-- $Id: mysql-ds.xml,v 1.3.2.1 2004/12/01 11:46:00 schrouf

                    Exp $ -->
                    <!-- Datasource config for MySQL using 3.0.9 available from:
                    http://www.mysql.com/downloads/api-jdbc-stable.html
                    -->


                    <local-tx-datasource>
                    <jndi-name>MySqlDS</jndi-name>


                    <connection-url>jdbc:mysql://localhost:3306/jbpm</connection-url>
                    <driver-class>com.mysql.jdbc.Driver</driver-class>
                    <user-name>root</user-name>



                    <exception-sorter-class-name>org.jboss.resource.adapter.jdbc.vendor.MyS

                    QLExceptionSorter</exception-sorter-class-name>
                    <!-- sql to call when connection is created
                    <new-connection-sql>some arbitrary sql</new-connection-sql>
                    -->
                    <!-- sql to call on an existing pooled connection when it

                    is obtained from pool
                    <check-valid-connection-sql>some arbitrary

                    sql</check-valid-connection-sql>
                    -->

                    <!-- corresponding type-mapping in the

                    standardjbosscmp-jdbc.xml (optional) -->

                    <type-mapping>mySQL</type-mapping>

                    </local-tx-datasource>


                    step15: copy mysql-connector-java-3.1.7-bin.jar from

                    'jbpm-db\mysql\lib' to 'jbpm-server\server\jbpm\lib' directory

                    step16: copy c3p0-0.8.5.2.jar from 'jbpm\lib\hibernate' to

                    'jbpm-server\server\jbpm\lib' directory

                    step17: under 'jbpm-server\server\jbpm\conf' edit

                    standardjbosscmp-jdbc.xml as follows:


                    java:/MySqlDS
                    <datasource-mapping>mySQL</datasource-mapping>

                    step18: under 'jbpm-server\server\jbpm\conf' edit standardjaws.xml as

                    follows:


                    java:/MySqlDS
                    <type-mapping>mySQL</type-mapping>
                    false

                    step19: under 'jbpm-server\server\jbpm\conf' edit login-config.xml as

                    follows:
                    replace DefaultDS with MySqlDS
                    replace HsqlDbRealm with MySqlRealm as follows

                    <!-- Security domains for testing new jca framework -->
                    <application-policy name = "MySqlRealm">

                    <login-module code =

                    "org.jboss.resource.security.ConfiguredIdentityLoginModule"
                    flag = "required">
                    <module-option name =

                    "principal">root</module-option>
                    <module-option name =

                    "userName">root</module-option>
                    <module-option name = "password"></module-option>
                    <module-option name =

                    "managedConnectionFactoryName">jboss.jca:service=LocalTxCM,name=MySqlDS

                    </module-option>
                    </login-module>

                    </application-policy>

                    step20: under 'jbpm-server\server\jbpm\deploy\jms' rename

                    hsqldb-jdbc-state-service.xml and replace DefaultDS with MySqlDS

                    step21: under 'jbpm-server\server\jbpm\deploy\jms' delete

                    'hsqldb-jdbc2-service.xml' and copy 'mysql-jdbc2-service.xml' from

                    'jbpm-server\doc\examples\jms' to 'jbpm-server\server\jbpm\deploy\jms'

                    step22: under 'jbpm-server\server\jbpm\deploy' edit 'ejb-deployer.xml'

                    and replace 'DefaultDS' with 'MySqlDS'

                    step23: from jbpm-server\server\bin execute 'run -c jbpm'

                    • 7. Re: jBPM with mysql errors
                      kukeltje

                      Great, thanks for the detailed steps. Can you create a wiki page for this? (i'd do it , but you forgot to use the code tags to display xml properly)

                      • 8. Re: jBPM with mysql errors
                        maverick1611

                        oops my bad about the tags .. i'll try to create a wiki page for it soon..

                        • 9. Re: jBPM with mysql errors

                          Hi Maverick1611,
                          Thanks for a detail list of steps to do. I did all the things you mentioned and when I hit the url http://localhost:8080/jbpm I am getting the following error.

                          14:55:37,890 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
                          java.lang.ExceptionInInitializerError
                          at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                          at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
                          orAccessorImpl.java:39)
                          at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
                          onstructorAccessorImpl.java:27)
                          at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
                          at java.lang.Class.newInstance0(Class.java:350)
                          at java.lang.Class.newInstance(Class.java:303)
                          at org.jbpm.webapp.context.Context.getContext(Context.java:23)
                          at org.jbpm.webapp.context.Context.getPersistenceContext(Context.java:33
                          )
                          at org.jbpm.webapp.filter.PersistenceFilter.doFilter(PersistenceFilter.j
                          ava:22)
                          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                          icationFilterChain.java:202)
                          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                          ilterChain.java:173)
                          at org.jbpm.webapp.filter.ContextFilter.doFilter(ContextFilter.java:19)
                          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                          icationFilterChain.java:202)
                          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                          ilterChain.java:173)
                          at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:38)
                          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                          icationFilterChain.java:202)
                          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                          ilterChain.java:173)
                          at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
                          lter.java:81)
                          at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                          icationFilterChain.java:202)
                          at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                          ilterChain.java:173)
                          at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
                          alve.java:213)
                          at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
                          alve.java:178)
                          at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc
                          ipalValve.java:39)
                          at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
                          yAssociationValve.java:153)
                          at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
                          e.java:59)
                          at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
                          ava:126)
                          at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
                          ava:105)
                          at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
                          ve.java:107)
                          at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
                          a:148)
                          at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
                          :856)
                          at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
                          ssConnection(Http11Protocol.java:744)
                          at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
                          int.java:527)
                          at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
                          kerThread.java:112)
                          at java.lang.Thread.run(Thread.java:595)
                          Caused by: java.lang.RuntimeException: couldn't fetch JbpmSessionFactory from jn
                          di 'java:/jbpm/JbpmSessionFactory'
                          at org.jbpm.db.JbpmSessionFactory.getInstance(JbpmSessionFactory.java:64
                          )
                          at org.jbpm.webapp.context.PersistenceContext.(PersistenceContex
                          t.java:11)
                          ... 34 more

                          Any idea why thats happening?

                          Thanks a lot,
                          Hemanth

                          • 10. Re: jBPM with mysql errors
                            danielywoo

                            Hi guys,

                            I put mysql JDBC driver into lib/mysql and run the create.db task but failed, I get a ClassNotFoundException for the JDBC driver. I am sure the variable 'classpath.ant' in my build.deploy.xml contains the JDBC driver, anybody met this problem before?

                            Daniel

                            • 11. Re: jBPM with mysql errors

                              If any of you run into this refer to: http://wiki.jboss.org/wiki/Wiki.jsp?page=JBossFaces

                              "sy62k" wrote:
                              Hi Maverick1611,
                              Thanks for a detail list of steps to do. I did all the things you mentioned and when I hit the url http://localhost:8080/jbpm I am getting the following error.

                              14:55:37,890 ERROR [[jsp]] Servlet.service() for servlet jsp threw exception
                              java.lang.ExceptionInInitializerError
                              at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)

                              at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstruct
                              orAccessorImpl.java:39)
                              at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingC
                              onstructorAccessorImpl.java:27)
                              at java.lang.reflect.Constructor.newInstance(Constructor.java:494)
                              at java.lang.Class.newInstance0(Class.java:350)
                              at java.lang.Class.newInstance(Class.java:303)
                              at org.jbpm.webapp.context.Context.getContext(Context.java:23)
                              at org.jbpm.webapp.context.Context.getPersistenceContext(Context.java:33
                              )
                              at org.jbpm.webapp.filter.PersistenceFilter.doFilter(PersistenceFilter.j
                              ava:22)
                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                              icationFilterChain.java:202)
                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                              ilterChain.java:173)
                              at org.jbpm.webapp.filter.ContextFilter.doFilter(ContextFilter.java:19)
                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                              icationFilterChain.java:202)
                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                              ilterChain.java:173)
                              at org.jbpm.webapp.filter.LogFilter.doFilter(LogFilter.java:38)
                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                              icationFilterChain.java:202)
                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                              ilterChain.java:173)
                              at org.jboss.web.tomcat.filters.ReplyHeaderFilter.doFilter(ReplyHeaderFi
                              lter.java:81)
                              at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Appl
                              icationFilterChain.java:202)
                              at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationF
                              ilterChain.java:173)
                              at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperV
                              alve.java:213)
                              at org.apache.catalina.core.StandardContextValve.invoke(StandardContextV
                              alve.java:178)
                              at org.jboss.web.tomcat.security.CustomPrincipalValve.invoke(CustomPrinc
                              ipalValve.java:39)
                              at org.jboss.web.tomcat.security.SecurityAssociationValve.invoke(Securit
                              yAssociationValve.java:153)
                              at org.jboss.web.tomcat.security.JaccContextValve.invoke(JaccContextValv
                              e.java:59)
                              at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.j
                              ava:126)
                              at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.j
                              ava:105)
                              at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineVal
                              ve.java:107)
                              at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.jav
                              a:148)
                              at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java
                              :856)
                              at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.proce
                              ssConnection(Http11Protocol.java:744)
                              at org.apache.tomcat.util.net.PoolTcpEndpoint.processSocket(PoolTcpEndpo
                              int.java:527)
                              at org.apache.tomcat.util.net.MasterSlaveWorkerThread.run(MasterSlaveWor
                              kerThread.java:112)
                              at java.lang.Thread.run(Thread.java:595)
                              Caused by: java.lang.RuntimeException: couldn't fetch JbpmSessionFactory from jn
                              di 'java:/jbpm/JbpmSessionFactory'
                              at org.jbpm.db.JbpmSessionFactory.getInstance(JbpmSessionFactory.java:64
                              )
                              at org.jbpm.webapp.context.PersistenceContext.<clinit>(PersistenceContex
                              t.java:11)
                              ... 34 more

                              Any idea why thats happening?

                              Thanks a lot,
                              Hemanth


                              • 12. Re: jBPM with mysql errors
                                maverick1611

                                make sure you have the database already created with the name jbpm in mysql before running create.db.
                                make sure its up and running and make sure that the version of jdbc driver is what is mentioned in the steps ..
                                hopefully it should work

                                • 13. Re: jBPM with mysql errors
                                  holly77

                                  I had a similar problem with JBPM and MySQL.
                                  For me the solution was, to set another cache provider in
                                  the hibernate.cfg.xml of the jbpm.sar:

                                  org.hibernate.cache.HashtableCacheProvider