cancel
Showing results for 
Search instead for 
Did you mean: 

configure mysql for activiti 5-10

nommyravian
Champ in-the-making
Champ in-the-making
Hi, I'm posting this just to help new users of Activiti like me;

I faced non-persistent (h2 db is dropped and re created every time when I started demo) in activiti 5-10 (and this issue is not present in activiti 5-9) which I solved after wasting my full day. Solution is here http://forums.activiti.org/en/viewtopic.php?f=6&t=4688.

I also couldn't find a proper step by step guidance to change the default h2 to mysql except this link http://forums.activiti.org/en/viewtopic.php?f=6&t=3496&p=14118&hilit=mysql#p14118 but I still faced problems so I want to add a couple of more steps in the solution for the new users.

  • step 00: install mysql and create a database named activiti using the following command;
  • create database activiti;
  • step 01: make sure the file: {activiti-home}/setup/build.db.properties has the contents like below
  • db=mysql
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/activiti
    jdbc.username={mysql username, mine is "root"}
    jdbc.password={mysql password, mine is "root"}
  • step 02: create sql file
  • just need to duplicate the file h2.data.sql in directory:
    {activiti-home}/setup/files/demo
    and change file name to mysql.data.sql

  • step 03(optional: I didn't try it): if you want to use the custom tomcat instead of the default tomcat
  • open the file {activiti-home}/setup/build.properties
    look for download.dir entry and change the value to the directory which contains file apache-tomcat-{your-version}.zip

  • step 04: copy mysql-connector-java-5.1.22-bin.jar (latest for me) to the listed directory below:
  • {activiti-home}/setup/files/dependencies/libs
  • step 05: add the following line to the path {activiti-home}/workspace/activiti-engine-examples/.classpath
  • <classpathentry kind="lib" path="libs-runtime/mysql-connector-java-5.1.22-bin.jar"/>
  • step 06: modify the listed text files below to add "mysql-connector-java-5.1.22-bin.jar":
  • - {activiti-home}/setup/files/dependencie/libs.engine.test.txt
    - {activiti-home}/setup/files/dependencie/libs.webapp.explorer.txt
    - {activiti-home}/setup/files/dependencie/libs.webapp.rest.txt
  • step 07: modify the following file
    {activiti-home}/setup/build.xml
  • + looking for the target demo.start and delete(delete or disable are also suitable) the depends: h2.start
    + looking for the target demo.install and comment out the following tags:
    <antcall target="h2.install" />
    <antcall target="h2.start" />
    <antcall target="h2.stop" />

  • step 08: To change the database that Explorer uses in the demo setup, change the properties file
    {activiti-home}apps/apache-timcat-6.x/webapps/activiti-explorer/WEB-INF/classes/db.properties
    new contents should be
  • db=mysql
    jdbc.driver=com.mysql.jdbc.Driver
    jdbc.url=jdbc:mysql://localhost:3306/activiti
    jdbc.username={mysql username, mine is "root"}
    jdbc.password={mysql password, mine is "root"}
    Also, place "mysql-connector-java-5.1.22-bin.jar" in the path,
     {activiti-home}apps\apache-tomcat-6.0.32\lib/ 
  • step 09: run ant demo.install and then ant demo.start
  • All tables should have been created in mysql along with the demo data. Check activiti database in mysql to confirm.

    I hope that you don't waste your full day to fix these things. Enjoy!

    Salman
    12 REPLIES 12

    jbarrez
    Star Contributor
    Star Contributor
    Thanks for posting this!

    bobking256
    Champ in-the-making
    Champ in-the-making
    Thanks for this post.  I followed the instructions exactly on Mac 0SX.  I did alter slightly to reference the correct mysql jar file (version 5.1.22 and not the 5.1.6 shown above).  The tables get installed correctly; however, when I attempt to start demo, browser shows up as 404.  Any idea why that might happen?

    nommyravian
    Champ in-the-making
    Champ in-the-making
    Hi,
    Did your browser show the Activiti Explorer before configuring for mysql? Are you getting any exceptions on server console; if yes then share it. I might not be helpful a lot but some other guy can help you if you share your detailed configurations.

    Thank you,
    Salman

    bobking256
    Champ in-the-making
    Champ in-the-making
    It was working fine with h2.  I've deleted everything and now trying to get it running again from scratch and now getting 404 error all the time 😞

    Here is my build (ant demo.start) output:

    Bob-King-MacBook-Pro:setup bobking$ ant demo.start
    Buildfile: /Users/bobking/activiti/setup/build.xml

    demo.install:
         [echo] installing demo…

    internal.define.jdbc.driver.libs:

    internal.build.webapps:
        [mkdir] Created dir: /Users/bobking/activiti/setup/build/webapps
         [copy] Copying 576 files to /Users/bobking/activiti/setup/build/webapps
         [copy] Copied 75 empty directories to 2 empty directories under /Users/bobking/activiti/setup/build/webapps
         [copy] Copying 35 files to /Users/bobking/activiti/setup/build/webapps/activiti-explorer.war/WEB-INF/lib
    [propertyfile] Updating property file: /Users/bobking/activiti/setup/build/webapps/activiti-explorer.war/WEB-INF/classes/db.properties
         [copy] Copying 76 files to /Users/bobking/activiti/setup/build/webapps/activiti-rest.war/WEB-INF/lib
    [propertyfile] Updating property file: /Users/bobking/activiti/setup/build/webapps/activiti-rest.war/WEB-INF/classes/db.properties

    internal.db.install.h2:
         [echo] Installing H2 database in ../apps/h2
        [mkdir] Created dir: /Users/bobking/activiti/apps/h2
         [copy] Copying 7 files to /Users/bobking/activiti/apps/h2

    internal.db.install.h2.unnecessary:

    internal.db.install.unsupported:

    h2.install:

    internal.cfg.create:
        [mkdir] Created dir: /Users/bobking/activiti/setup/build/activiti-cfg
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/activiti-cfg
          [zip] Building zip: /Users/bobking/activiti/setup/build/activiti-cfg.jar
         [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
        [unzip] Expanding: /Users/bobking/activiti/setup/build/activiti-cfg.jar into /Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config

    internal.classpath.libs:

    internal.taskdef.launch:

    h2.start:
         [echo] starting H2 database…
       [launch] launching cmd '/Users/bobking/activiti/apps/h2/h2.start.sh ' in dir '/Users/bobking/activiti/apps/h2'
       [launch] waiting for launch completion msg 'TCP server running'…
       [launch]   TCP server running at tcp://192.168.1.3:9092 (others can connect)
         [echo] H2 database started

    internal.cfg.create:
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/activiti-cfg
         [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
        [unzip] Expanding: /Users/bobking/activiti/setup/build/activiti-cfg.jar into /Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config

    internal.classpath.libs:

    internal.db.create:
         [echo] creating db
         [java] Oct 30, 2012 6:47:38 PM org.activiti.engine.ProcessEngines initProcessEnginFromResource
         [java] INFO: initializing process engine for resource jar:file:/Users/bobking/activiti/setup/build/activiti-cfg.jar!/activiti.cfg.xml
         [java] log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
         [java] log4j:WARN Please initialize the log4j system properly.
         [java] ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider com.sun.script.javascript.RhinoScriptEngineFactory not found
         [java] ScriptEngineManager providers.next(): javax.script.ScriptEngineFactory: Provider apple.applescript.AppleScriptEngineFactory not found
         [java] SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
         [java] SLF4J: Defaulting to no-operation (NOP) logger implementation
         [java] SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
         [java] INFO: performing create on engine with resource org/activiti/db/create/activiti.h2.create.engine.sql
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
         [java] INFO: performing create on history with resource org/activiti/db/create/activiti.h2.create.history.sql
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.db.DbSqlSession executeSchemaResource
         [java] INFO: performing create on identity with resource org/activiti/db/create/activiti.h2.create.identity.sql
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.ProcessEngineImpl <init>
         [java] INFO: ProcessEngine default created
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.jobexecutor.JobExecutor start
         [java] INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.ProcessEngines initProcessEnginFromResource
         [java] INFO: initialised process engine default
         [java] Oct 30, 2012 6:47:41 PM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run
         [java] INFO: JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs

    internal.cfg.create:
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/activiti-cfg
          [zip] Building zip: /Users/bobking/activiti/setup/build/activiti-cfg.jar
         [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
        [unzip] Expanding: /Users/bobking/activiti/setup/build/activiti-cfg.jar into /Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config

    internal.classpath.libs:

    internal.db.demo.data:
         [echo] populating demo data
        [mkdir] Created dir: /Users/bobking/activiti/setup/build/demo
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/demo
          [sql] Executing resource: /Users/bobking/activiti/setup/build/demo/h2.data.sql
          [sql] 23 of 23 SQL statements executed successfully

    bar:

    inflate.libs.and.deploy.cfg:

    compile.classpath:

    compile:
        [javac] /Users/bobking/activiti/workspace/activiti-engine-examples/build.xml:27: warning: 'includeantruntime' was not set, defaulting to build.sysclasspath=last; set to false for repeatable builds

    jar:

    deploy:
         [copy] Copying 1 file to /Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-rest/WEB-INF/lib
    [deploy-bar] Initializing process engine default
    [deploy-bar] Oct 30, 2012 6:47:41 PM org.activiti.engine.ProcessEngines initProcessEnginFromResource
    [deploy-bar] INFO: initializing process engine for resource file:/Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config/activiti.cfg.xml
    [deploy-bar] log4j:WARN No appenders could be found for logger (org.springframework.core.env.StandardEnvironment).
    [deploy-bar] log4j:WARN Please initialize the log4j system properly.
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.ProcessEngineImpl <init>
    [deploy-bar] INFO: ProcessEngine default created
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.jobexecutor.JobExecutor start
    [deploy-bar] INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.ProcessEngines initProcessEnginFromResource
    [deploy-bar] INFO: initialised process engine default
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run
    [deploy-bar] INFO: JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs
    [deploy-bar] Starting to deploy 1 files
    [deploy-bar] Handling file /Users/bobking/activiti/workspace/activiti-engine-examples/target/activiti-engine-examples.bar
    [deploy-bar] deploying bar /Users/bobking/activiti/workspace/activiti-engine-examples/target/activiti-engine-examples.bar
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/taskforms/VacationRequest.bpmn20.xml
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XMLSchema currently not supported as typeLanguage
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XPath currently not supported as expressionLanguage
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
    [deploy-bar] INFO: Process with id='vacationRequest' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/bpmn/event/timer/BoundaryTimerEventTest.testInterruptingTimerDuration.png
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/bpmn/event/timer/BoundaryTimerEventTest.testInterruptingTimerDuration.bpmn20.xml
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XMLSchema currently not supported as typeLanguage
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XPath currently not supported as expressionLanguage
    [deploy-bar] Oct 30, 2012 6:47:43 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
    [deploy-bar] INFO: Process with id='escalationExample' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/bpmn/subprocess/SubProcessTest.fixSystemFailureProcess.png
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/taskforms/VacationRequest.png
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/bpmn/event/error/reviewSalesLead.bpmn20.xml
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XMLSchema currently not supported as typeLanguage
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XPath currently not supported as expressionLanguage
    [deploy-bar] Oct 30, 2012 6:47:44 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
    [deploy-bar] INFO: Process with id='reviewSaledLead' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/bpmn/subprocess/SubProcessTest.fixSystemFailureProcess.bpmn20.xml
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XMLSchema currently not supported as typeLanguage
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XPath currently not supported as expressionLanguage
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
    [deploy-bar] INFO: Process with id='fixSystemFailure' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.deployer.BpmnDeployer deploy
    [deploy-bar] INFO: Processing resource org/activiti/examples/adhoc/Expense_process.bpmn20.xml
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XMLSchema currently not supported as typeLanguage
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseDefinitionsAttributes
    [deploy-bar] INFO: XPath currently not supported as expressionLanguage
    [deploy-bar] Oct 30, 2012 6:47:45 PM org.activiti.engine.impl.bpmn.parser.BpmnParse parseProcessDefinitions
    [deploy-bar] INFO: Process with id='adhoc_Expense_process' hasn't the attribute isExecutable set. Please maintain it, so you are compatible to future activiti versions.

    internal.cfg.create:
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/activiti-cfg
          [zip] Building zip: /Users/bobking/activiti/setup/build/activiti-cfg.jar
         [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
        [unzip] Expanding: /Users/bobking/activiti/setup/build/activiti-cfg.jar into /Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config

    internal.classpath.libs:

    internal.taskdef.launch:

    h2.stop:
       [launch] launching cmd '/Users/bobking/activiti/apps/h2/h2.stop.sh ' in dir '/Users/bobking/activiti/apps/h2'
       [launch] not waiting for a launch completion msg.
       [launch]   Shutting down TCP Server at tcp://localhost:9092
       [launch] launched process completed

    tomcat.install:

    internal.tomcat.download:

    internal.tomcat.unzip:
        [unzip] Expanding: /Users/bobking/downloads/apache-tomcat-6.0.32.zip into /Users/bobking/activiti/apps
        [unzip] Oct 30, 2012 6:47:46 PM org.activiti.engine.impl.interceptor.CommandContext close
        [unzip] SEVERE: Error while closing command context
        [unzip] org.apache.ibatis.exceptions.PersistenceException:
        [unzip] ### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
        [unzip] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
        [unzip] ### The error occurred while executing a query
        [unzip] ### SQL: select       JOB.*           from ACT_RU_JOB JOB          LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = JOB.PROCESS_INSTANCE_ID_      LEFT OUTER JOIN ACT_RE_PROCDEF PD ON PD.ID_ = PI.PROC_DEF_ID_         where (JOB.RETRIES_ > 0)       and (JOB.DUEDATE_ is null or JOB.DUEDATE_ < ?)       and (JOB.LOCK_OWNER_ is null or JOB.LOCK_EXP_TIME_ < ?)    and (         (JOB.EXECUTION_ID_ is null)      or ((PI.SUSPENSION_STATE_ = 1)               and (PD.SUSPENSION_STATE_ = 1))       )       LIMIT ? OFFSET ?
        [unzip] ### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:187)
        [unzip]  at org.activiti.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:105)
        [unzip]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:51)
        [unzip]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33)
        [unzip]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
        [unzip]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
        [unzip]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
        [unzip]  at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)
        [unzip]  at java.lang.Thread.run(Thread.java:680)
        [unzip] Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip]  at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        [unzip]  at org.h2.message.DbException.get(DbException.java:169)
        [unzip]  at org.h2.message.DbException.get(DbException.java:146)
        [unzip]  at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:502)
        [unzip]  at org.h2.engine.SessionRemote.removeServer(SessionRemote.java:433)
        [unzip]  at org.h2.command.CommandRemote.prepare(CommandRemote.java:80)
        [unzip]  at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
        [unzip]  at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:439)
        [unzip]  at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
        [unzip]  at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
        [unzip]  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
        [unzip]  at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        [unzip]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        [unzip]  at java.lang.reflect.Method.invoke(Method.java:597)
        [unzip]  at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:246)
        [unzip]  at $Proxy0.prepareStatement(Unknown Source)
        [unzip]  at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)
        [unzip]  at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)
        [unzip]  at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)
        [unzip]  at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)
        [unzip]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
        [unzip]  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
        [unzip]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
        [unzip]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
        [unzip]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
        [unzip]  … 12 more
        [unzip] Oct 30, 2012 6:47:46 PM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run
        [unzip] SEVERE: exception during job acquisition:
        [unzip] ### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
        [unzip] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
        [unzip] ### The error occurred while executing a query
        [unzip] ### SQL: select       JOB.*           from ACT_RU_JOB JOB          LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = JOB.PROCESS_INSTANCE_ID_      LEFT OUTER JOIN ACT_RE_PROCDEF PD ON PD.ID_ = PI.PROC_DEF_ID_         where (JOB.RETRIES_ > 0)       and (JOB.DUEDATE_ is null or JOB.DUEDATE_ < ?)       and (JOB.LOCK_OWNER_ is null or JOB.LOCK_EXP_TIME_ < ?)    and (         (JOB.EXECUTION_ID_ is null)      or ((PI.SUSPENSION_STATE_ = 1)               and (PD.SUSPENSION_STATE_ = 1))       )       LIMIT ? OFFSET ?
        [unzip] ### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip] org.apache.ibatis.exceptions.PersistenceException:
        [unzip] ### Error querying database.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
        [unzip] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
        [unzip] ### The error occurred while executing a query
        [unzip] ### SQL: select       JOB.*           from ACT_RU_JOB JOB          LEFT OUTER JOIN ACT_RU_EXECUTION PI ON PI.ID_ = JOB.PROCESS_INSTANCE_ID_      LEFT OUTER JOIN ACT_RE_PROCDEF PD ON PD.ID_ = PI.PROC_DEF_ID_         where (JOB.RETRIES_ > 0)       and (JOB.DUEDATE_ is null or JOB.DUEDATE_ < ?)       and (JOB.LOCK_OWNER_ is null or JOB.LOCK_EXP_TIME_ < ?)    and (         (JOB.EXECUTION_ID_ is null)      or ((PI.SUSPENSION_STATE_ = 1)               and (PD.SUSPENSION_STATE_ = 1))       )       LIMIT ? OFFSET ?
        [unzip] ### Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)
        [unzip]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:187)
        [unzip]  at org.activiti.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:105)
        [unzip]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:51)
        [unzip]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33)
        [unzip]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
        [unzip]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
        [unzip]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
        [unzip]  at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)
        [unzip]  at java.lang.Thread.run(Thread.java:680)
        [unzip] Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
        [unzip]  at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
        [unzip]  at org.h2.message.DbException.get(DbException.java:169)
        [unzip]  at org.h2.message.DbException.get(DbException.java:146)
        [unzip]  at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:502)
        [unzip]  at org.h2.engine.SessionRemote.removeServer(SessionRemote.java:433)
        [unzip]  at org.h2.command.CommandRemote.prepare(CommandRemote.java:80)
        [unzip]  at org.h2.command.CommandRemote.<init>(CommandRemote.java:46)
        [unzip]  at org.h2.engine.SessionRemote.prepareCommand(SessionRemote.java:439)
        [unzip]  at org.h2.jdbc.JdbcConnection.prepareCommand(JdbcConnection.java:1109)
        [unzip]  at org.h2.jdbc.JdbcPreparedStatement.<init>(JdbcPreparedStatement.java:74)
        [unzip]  at org.h2.jdbc.JdbcConnection.prepareStatement(JdbcConnection.java:264)
        [unzip]  at sun.reflect.GeneratedMethodAccessor21.invoke(Unknown Source)
        [unzip]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
        [unzip]  at java.lang.reflect.Method.invoke(Method.java:597)
        [unzip]  at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:246)
        [unzip]  at $Proxy0.prepareStatement(Unknown Source)
        [unzip]  at org.apache.ibatis.executor.statement.PreparedStatementHandler.instantiateStatement(PreparedStatementHandler.java:72)
        [unzip]  at org.apache.ibatis.executor.statement.BaseStatementHandler.prepare(BaseStatementHandler.java:82)
        [unzip]  at org.apache.ibatis.executor.statement.RoutingStatementHandler.prepare(RoutingStatementHandler.java:54)
        [unzip]  at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:70)
        [unzip]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
        [unzip]  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
        [unzip]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
        [unzip]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
        [unzip]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
        [unzip]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
        [unzip]  … 12 more

    internal.tomcat.copy.users:

    internal.tomcat.enable.debug:

    internal.tomcat.apply.javaopts.other:

    internal.tomcat.apply.javaopts.windows:
         [copy] Copying 1 file to /Users/bobking/activiti/apps/apache-tomcat-6.0.32/conf

    internal.define.jdbc.driver.libs:

    internal.build.webapps:
    [propertyfile] Updating property file: /Users/bobking/activiti/setup/build/webapps/activiti-explorer.war/WEB-INF/classes/db.properties
    [propertyfile] Updating property file: /Users/bobking/activiti/setup/build/webapps/activiti-rest.war/WEB-INF/classes/db.properties

    internal.deploy.activiti.rest.into.tomcat:
         [copy] Copying 163 files to /Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-rest

    internal.deploy.activiti.explorer.into.tomcat:
        [mkdir] Created dir: /Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-explorer
         [copy] Copying 524 files to /Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-explorer
         [copy] Oct 30, 2012 6:47:48 PM org.activiti.engine.impl.interceptor.CommandContext close
         [copy] SEVERE: Error while closing command context
         [copy] org.apache.ibatis.exceptions.PersistenceException:
         [copy] ### Error querying database.  Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
         [copy] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
         [copy] ### The error occurred while executing a query
         [copy] ### Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:187)
         [copy]  at org.activiti.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:105)
         [copy]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:51)
         [copy]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33)
         [copy]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
         [copy]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
         [copy]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
         [copy]  at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)
         [copy]  at java.lang.Thread.run(Thread.java:680)
         [copy] Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:135)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)
         [copy]  at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
         [copy]  at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
         [copy]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
         [copy]  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
         [copy]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
         [copy]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
         [copy]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
         [copy]  … 12 more
         [copy] Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
         [copy]  at org.h2.message.DbException.get(DbException.java:169)
         [copy]  at org.h2.message.DbException.get(DbException.java:146)
         [copy]  at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:502)
         [copy]  at org.h2.engine.SessionRemote.removeServer(SessionRemote.java:433)
         [copy]  at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:217)
         [copy]  at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:191)
         [copy]  at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:407)
         [copy]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [copy]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         [copy]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         [copy]  at java.lang.reflect.Method.invoke(Method.java:597)
         [copy]  at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:246)
         [copy]  at $Proxy0.setAutoCommit(Unknown Source)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:97)
         [copy]  … 22 more
         [copy] Oct 30, 2012 6:47:48 PM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run
         [copy] SEVERE: exception during job acquisition:
         [copy] ### Error querying database.  Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
         [copy] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
         [copy] ### The error occurred while executing a query
         [copy] ### Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy] org.apache.ibatis.exceptions.PersistenceException:
         [copy] ### Error querying database.  Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy] ### The error may exist in org/activiti/db/mapping/entity/Job.xml
         [copy] ### The error may involve org.activiti.engine.impl.persistence.entity.JobEntity.selectNextJobsToExecute
         [copy] ### The error occurred while executing a query
         [copy] ### Cause: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:95)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:216)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:200)
         [copy]  at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:187)
         [copy]  at org.activiti.engine.impl.persistence.entity.JobManager.findNextJobsToExecute(JobManager.java:105)
         [copy]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:51)
         [copy]  at org.activiti.engine.impl.cmd.AcquireJobsCmd.execute(AcquireJobsCmd.java:33)
         [copy]  at org.activiti.engine.impl.interceptor.CommandExecutorImpl.execute(CommandExecutorImpl.java:24)
         [copy]  at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:42)
         [copy]  at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:33)
         [copy]  at org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable.run(AcquireJobsRunnable.java:57)
         [copy]  at java.lang.Thread.run(Thread.java:680)
         [copy] Caused by: org.apache.ibatis.transaction.TransactionException: Error configuring AutoCommit.  Your driver may not support getAutoCommit() or setAutoCommit(). Requested setting: false.  Cause: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:102)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.openConnection(JdbcTransaction.java:135)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.getConnection(JdbcTransaction.java:58)
         [copy]   at org.apache.ibatis.executor.BaseExecutor.getConnection(BaseExecutor.java:279)
         [copy]  at org.apache.ibatis.executor.SimpleExecutor.prepareStatement(SimpleExecutor.java:69)
         [copy]  at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:56)
         [copy]  at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:267)
         [copy]  at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:141)
         [copy]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
         [copy]  at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
         [copy]  at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:101)
         [copy]  … 12 more
         [copy] Caused by: org.h2.jdbc.JdbcSQLException: Connection is broken: "session closed" [90067-168]
         [copy]  at org.h2.message.DbException.getJdbcSQLException(DbException.java:329)
         [copy]  at org.h2.message.DbException.get(DbException.java:169)
         [copy]  at org.h2.message.DbException.get(DbException.java:146)
         [copy]  at org.h2.engine.SessionRemote.checkClosed(SessionRemote.java:502)
         [copy]  at org.h2.engine.SessionRemote.removeServer(SessionRemote.java:433)
         [copy]  at org.h2.engine.SessionRemote.setAutoCommitSend(SessionRemote.java:217)
         [copy]  at org.h2.engine.SessionRemote.setAutoCommit(SessionRemote.java:191)
         [copy]  at org.h2.jdbc.JdbcConnection.setAutoCommit(JdbcConnection.java:407)
         [copy]  at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
         [copy]  at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
         [copy]  at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
         [copy]  at java.lang.reflect.Method.invoke(Method.java:597)
         [copy]  at org.apache.ibatis.datasource.pooled.PooledConnection.invoke(PooledConnection.java:246)
         [copy]  at $Proxy0.setAutoCommit(Unknown Source)
         [copy]  at org.apache.ibatis.transaction.jdbc.JdbcTransaction.setDesiredAutoCommit(JdbcTransaction.java:97)
         [copy]  … 22 more

    deploy.activiti.webapps.into.tomcat:

    internal.cfg.create:
         [copy] Copying 1 file to /Users/bobking/activiti/setup/build/activiti-cfg
          [zip] Building zip: /Users/bobking/activiti/setup/build/activiti-cfg.jar
         [echo] copying configuration to ../workspace/activiti-engine-examples/src/main/config
        [unzip] Expanding: /Users/bobking/activiti/setup/build/activiti-cfg.jar into /Users/bobking/activiti/workspace/activiti-engine-examples/src/main/config

    internal.classpath.libs:

    internal.taskdef.launch:

    h2.start:
         [echo] starting H2 database…
       [launch] launching cmd '/Users/bobking/activiti/apps/h2/h2.start.sh ' in dir '/Users/bobking/activiti/apps/h2'
       [launch] waiting for launch completion msg 'TCP server running'…
       [launch]   TCP server running at tcp://192.168.1.3:9092 (others can connect)
         [echo] H2 database started

    tomcat.start:
       [launch] launching cmd '/Users/bobking/activiti/apps/apache-tomcat-6.0.32/bin/startup.sh ' in dir '/Users/bobking/activiti/apps/apache-tomcat-6.0.32/bin'
       [launch] waiting for launch completion msg 'Using CLASSPATH:'…
       [launch] launched process completed

    explorer.browser.open:

    demo.start:

    BUILD SUCCESSFUL
    Total time: 20 seconds

    bobking256
    Champ in-the-making
    Champ in-the-making
    I am using Mac OS X with java 1.6.0_37 which is part of native install.

    Here is output of catalina.out:

    Oct 30, 2012 7:20:06 PM org.apache.catalina.core.AprLifecycleListener init
    INFO: The APR based Apache Tomcat Native library which allows optimal performance in production environments was not found on the java.library.path: .:/Library/Java/Extensions:/System/Library/Java/Extensions:/usr/lib/java
    Oct 30, 2012 7:20:07 PM org.apache.coyote.http11.Http11Protocol init
    INFO: Initializing Coyote HTTP/1.1 on http-8080
    Oct 30, 2012 7:20:07 PM org.apache.catalina.startup.Catalina load
    INFO: Initialization processed in 655 ms
    Oct 30, 2012 7:20:07 PM org.apache.catalina.core.StandardService start
    INFO: Starting service Catalina
    Oct 30, 2012 7:20:07 PM org.apache.catalina.core.StandardEngine start
    INFO: Starting Servlet Engine: Apache Tomcat/6.0.32
    Oct 30, 2012 7:20:07 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory activiti-explorer
    Oct 30, 2012 7:20:07 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
    INFO: validateJarFile(/Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-explorer/WEB-INF/lib/servlet-api-2.5.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
    Oct 30, 2012 7:20:07 PM org.apache.catalina.core.ApplicationContext log
    INFO: Initializing Spring root WebApplicationContext
    Oct 30, 2012 7:20:07 PM org.springframework.web.context.ContextLoader initWebApplicationContext
    INFO: Root WebApplicationContext: initialization started
    Oct 30, 2012 7:20:07 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh
    INFO: Refreshing Root WebApplicationContext: startup date [Tue Oct 30 19:20:07 EDT 2012]; root of context hierarchy
    Oct 30, 2012 7:20:07 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
    INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/applicationContext.xml]
    Oct 30, 2012 7:20:07 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
    INFO: Loading XML bean definitions from ServletContext resource [/WEB-INF/activiti-ui-context.xml]
    Oct 30, 2012 7:20:08 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
    INFO: Loading properties file from class path resource [db.properties]
    Oct 30, 2012 7:20:08 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
    INFO: Loading properties file from class path resource [ui.properties]
    Oct 30, 2012 7:20:08 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
    INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5ad75c47: defining beans [dbProperties,demoDataGenerator,dataSource,transactionManager,processEngineConfiguration,processEngine,repositoryService,runtimeService,taskService,historyService,managementService,identityService,activitiLoginHandler,activitiUiPropertyPlaceholder,navigatorManager,attachmentRendererManager,formPropertyRendererManager,variableRendererManager,componentFactories,userCache,navigationFragmentChangeListener,mainWindow,explorerApp,i18nManager,notificationManager,viewManager,userFormType]; root of factory hierarchy
    Oct 30, 2012 7:20:08 PM org.springframework.beans.factory.support.DefaultSingletonBeanRegistry destroySingletons
    INFO: Destroying singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@5ad75c47: defining beans [dbProperties,demoDataGenerator,dataSource,transactionManager,processEngineConfiguration,processEngine,repositoryService,runtimeService,taskService,historyService,managementService,identityService,activitiLoginHandler,activitiUiPropertyPlaceholder,navigatorManager,attachmentRendererManager,formPropertyRendererManager,variableRendererManager,componentFactories,userCache,navigationFragmentChangeListener,mainWindow,explorerApp,i18nManager,notificationManager,viewManager,userFormType]; root of factory hierarchy
    Oct 30, 2012 7:20:08 PM org.springframework.web.context.ContextLoader initWebApplicationContext
    SEVERE: Context initialization failed
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'demoDataGenerator' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngine' while setting bean property 'processEngine'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngineConfiguration' while setting bean property 'processEngineConfiguration'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngineConfiguration' while setting bean property 'processEngineConfiguration'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 39 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 49 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:997)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:943)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 59 more
    Caused by: java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at java.lang.Class.getDeclaredConstructors0(Native Method)
    at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
    at java.lang.Class.getConstructor0(Class.java:2699)
    at java.lang.Class.getDeclaredConstructor(Class.java:1985)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:67)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:990)
    … 67 more
    Caused by: java.lang.ClassNotFoundException: org.apache.commons.pool.KeyedObjectPoolFactory
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at sun.misc.Launcher$ExtClassLoader.findClass(Launcher.java:229)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    … 73 more
    Oct 30, 2012 7:20:08 PM org.apache.catalina.core.StandardContext listenerStart
    SEVERE: Exception sending context initialized event to listener instance of class org.springframework.web.context.ContextLoaderListener
    org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'demoDataGenerator' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngine' while setting bean property 'processEngine'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngineConfiguration' while setting bean property 'processEngineConfiguration'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:609)
    at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:918)
    at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:469)
    at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:383)
    at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:283)
    at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:111)
    at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4205)
    at org.apache.catalina.core.StandardContext.start(StandardContext.java:4704)
    at org.apache.catalina.core.ContainerBase.addChildInternal(ContainerBase.java:799)
    at org.apache.catalina.core.ContainerBase.addChild(ContainerBase.java:779)
    at org.apache.catalina.core.StandardHost.addChild(StandardHost.java:601)
    at org.apache.catalina.startup.HostConfig.deployDirectory(HostConfig.java:1079)
    at org.apache.catalina.startup.HostConfig.deployDirectories(HostConfig.java:1002)
    at org.apache.catalina.startup.HostConfig.deployApps(HostConfig.java:506)
    at org.apache.catalina.startup.HostConfig.start(HostConfig.java:1315)
    at org.apache.catalina.startup.HostConfig.lifecycleEvent(HostConfig.java:324)
    at org.apache.catalina.util.LifecycleSupport.fireLifecycleEvent(LifecycleSupport.java:142)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1061)
    at org.apache.catalina.core.StandardHost.start(StandardHost.java:840)
    at org.apache.catalina.core.ContainerBase.start(ContainerBase.java:1053)
    at org.apache.catalina.core.StandardEngine.start(StandardEngine.java:463)
    at org.apache.catalina.core.StandardService.start(StandardService.java:525)
    at org.apache.catalina.core.StandardServer.start(StandardServer.java:754)
    at org.apache.catalina.startup.Catalina.start(Catalina.java:595)
    at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
    at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:39)
    at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:25)
    at java.lang.reflect.Method.invoke(Method.java:597)
    at org.apache.catalina.startup.Bootstrap.start(Bootstrap.java:289)
    at org.apache.catalina.startup.Bootstrap.main(Bootstrap.java:414)
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngine' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'processEngineConfiguration' while setting bean property 'processEngineConfiguration'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 39 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'processEngineConfiguration' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Cannot resolve reference to bean 'dataSource' while setting bean property 'dataSource'; nested exception is org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:328)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveValueIfNecessary(BeanDefinitionValueResolver.java:106)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.applyPropertyValues(AbstractAutowireCapableBeanFactory.java:1360)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.populateBean(AbstractAutowireCapableBeanFactory.java:1118)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:517)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 49 more
    Caused by: org.springframework.beans.factory.BeanCreationException: Error creating bean with name 'dataSource' defined in ServletContext resource [/WEB-INF/applicationContext.xml]: Instantiation of bean failed; nested exception is java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:997)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:943)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:485)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:456)
    at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:294)
    at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:225)
    at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:291)
    at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:193)
    at org.springframework.beans.factory.support.BeanDefinitionValueResolver.resolveReference(BeanDefinitionValueResolver.java:322)
    … 59 more
    Caused by: java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory
    at java.lang.Class.getDeclaredConstructors0(Native Method)
    at java.lang.Class.privateGetDeclaredConstructors(Class.java:2389)
    at java.lang.Class.getConstructor0(Class.java:2699)
    at java.lang.Class.getDeclaredConstructor(Class.java:1985)
    at org.springframework.beans.factory.support.SimpleInstantiationStrategy.instantiate(SimpleInstantiationStrategy.java:67)
    at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateBean(AbstractAutowireCapableBeanFactory.java:990)
    … 67 more
    Caused by: java.lang.ClassNotFoundException: org.apache.commons.pool.KeyedObjectPoolFactory
    at java.net.URLClassLoader$1.run(URLClassLoader.java:202)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(URLClassLoader.java:190)
    at sun.misc.Launcher$ExtClassLoader.findClass(Launcher.java:229)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:306)
    at java.lang.ClassLoader.loadClass(ClassLoader.java:247)
    … 73 more
    Oct 30, 2012 7:20:08 PM org.apache.catalina.core.StandardContext start
    SEVERE: Error listenerStart
    Oct 30, 2012 7:20:08 PM org.apache.catalina.core.StandardContext start
    SEVERE: Context [/activiti-explorer] startup failed due to previous errors
    Oct 30, 2012 7:20:08 PM org.apache.catalina.core.ApplicationContext log
    INFO: Closing Spring root WebApplicationContext
    Oct 30, 2012 7:20:08 PM org.apache.catalina.loader.WebappClassLoader clearReferencesJdbc
    SEVERE: The web application [/activiti-explorer] registered the JDBC driver [org.h2.Driver] but failed to unregister it when the web application was stopped. To prevent a memory leak, the JDBC Driver has been forcibly unregistered.
    Oct 30, 2012 7:20:08 PM org.apache.catalina.loader.WebappClassLoader clearReferencesThreads
    SEVERE: The web application [/activiti-explorer] appears to have started a thread named [Abandoned connection cleanup thread] but has failed to stop it. This is very likely to create a memory leak.
    Oct 30, 2012 7:20:08 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory activiti-rest
    Oct 30, 2012 7:20:08 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
    INFO: validateJarFile(/Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-rest/WEB-INF/lib/geronimo-servlet_2.5_spec-1.1.2.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
    Oct 30, 2012 7:20:08 PM org.apache.catalina.loader.WebappClassLoader validateJarFile
    INFO: validateJarFile(/Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-rest/WEB-INF/lib/servlet-api-2.5.jar) - jar not loaded. See Servlet Spec 2.3, section 9.7.2. Offending class: javax/servlet/Servlet.class
    Oct 30, 2012 7:20:08 PM org.springframework.beans.factory.xml.XmlBeanDefinitionReader loadBeanDefinitions
    INFO: Loading XML bean definitions from URL [file:/Users/bobking/activiti/apps/apache-tomcat-6.0.32/webapps/activiti-rest/WEB-INF/classes/activiti-context.xml]
    Oct 30, 2012 7:20:09 PM org.springframework.context.support.AbstractApplicationContext prepareRefresh
    INFO: Refreshing org.springframework.context.support.GenericXmlApplicationContext@14db38a4: startup date [Tue Oct 30 19:20:09 EDT 2012]; root of context hierarchy
    Oct 30, 2012 7:20:09 PM org.springframework.core.io.support.PropertiesLoaderSupport loadProperties
    INFO: Loading properties file from class path resource [db.properties]
    Oct 30, 2012 7:20:09 PM org.springframework.beans.factory.support.DefaultListableBeanFactory preInstantiateSingletons
    INFO: Pre-instantiating singletons in org.springframework.beans.factory.support.DefaultListableBeanFactory@71a2f5b1: defining beans [dbProperties,dataSource,transactionManager,processEngineConfiguration,processEngine]; root of factory hierarchy
    SLF4J: Failed to load class "org.slf4j.impl.StaticLoggerBinder".
    SLF4J: Defaulting to no-operation (NOP) logger implementation
    SLF4J: See http://www.slf4j.org/codes.html#StaticLoggerBinder for further details.
    Oct 30, 2012 7:20:12 PM org.activiti.engine.impl.ProcessEngineImpl <init>
    INFO: ProcessEngine default created
    Oct 30, 2012 7:20:12 PM org.activiti.engine.impl.jobexecutor.JobExecutor start
    INFO: Starting up the JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor].
    Oct 30, 2012 7:20:12 PM org.activiti.engine.impl.jobexecutor.AcquireJobsRunnable run
    INFO: JobExecutor[org.activiti.engine.impl.jobexecutor.DefaultJobExecutor] starting to acquire jobs
    Oct 30, 2012 7:20:12 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory docs
    Oct 30, 2012 7:20:12 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory examples
    Oct 30, 2012 7:20:12 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory host-manager
    Oct 30, 2012 7:20:12 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory manager
    Oct 30, 2012 7:20:13 PM org.apache.catalina.startup.HostConfig deployDirectory
    INFO: Deploying web application directory ROOT
    Oct 30, 2012 7:20:13 PM org.apache.coyote.http11.Http11Protocol start
    INFO: Starting Coyote HTTP/1.1 on http-8080
    Oct 30, 2012 7:20:13 PM org.apache.jk.common.ChannelSocket init
    INFO: JK: ajp13 listening on /0.0.0.0:8009
    Oct 30, 2012 7:20:13 PM org.apache.jk.server.JkMain start
    INFO: Jk running ID=0 time=0/55  config=null
    Oct 30, 2012 7:20:13 PM org.apache.catalina.startup.Catalina start
    INFO: Server startup in 6146 ms

    jbarrez
    Star Contributor
    Star Contributor
    The error is pretty straightforwar:

    Caused by: java.lang.NoClassDefFoundError: org/apache/commons/pool/KeyedObjectPoolFactory

    It seens you don't have the commons pool lib on your classpath.

    bobking256
    Champ in-the-making
    Champ in-the-making
    Ok, I am at a loss still.  Any advice on how to resolve.  I'm still getting 404.

    christoph_retti
    Champ in-the-making
    Champ in-the-making
    You should get the commons pool library (e.g. commons-pool-1.6.jar downloaded from get http://commons.apache.org/pool/) and place it under <tomcat root> / lib.

    Then it is avilable to every web application in your tomcat. If you just want to have it for a single web application then place it under webapps/WEB-INF/lib.

      chris

    bobking256
    Champ in-the-making
    Champ in-the-making
    Thanks for baring with me.  I have commons-pool-1.6.jar copied to both places but still getting the same exact error.