topic Re: configure mysql for activiti 5-10 in Alfresco Archive

configure mysql for activiti 5-10

nommyravian — Fri, 05 Oct 2012 10:21:51 GMT

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

Re: configure mysql for activiti 5-10

jbarrez — Thu, 11 Oct 2012 12:38:49 GMT

Thanks for posting this!

Re: configure mysql for activiti 5-10

bobking256 — Tue, 30 Oct 2012 17:04:34 GMT

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?

Re: configure mysql for activiti 5-10

nommyravian — Tue, 30 Oct 2012 17:34:14 GMT

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

Re: configure mysql for activiti 5-10

bobking256 — Tue, 30 Oct 2012 22:49:01 GMT

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

Re: configure mysql for activiti 5-10

bobking256 — Tue, 30 Oct 2012 23:27:35 GMT

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

Re: configure mysql for activiti 5-10

jbarrez — Wed, 31 Oct 2012 07:00:47 GMT

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.

Re: configure mysql for activiti 5-10

bobking256 — Sat, 03 Nov 2012 02:45:46 GMT

Ok, I am at a loss still. Any advice on how to resolve. I'm still getting 404.

Re: configure mysql for activiti 5-10

christoph_retti — Sat, 03 Nov 2012 13:25:46 GMT

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

Re: configure mysql for activiti 5-10

bobking256 — Sun, 04 Nov 2012 21:31:33 GMT

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

Re: configure mysql for activiti 5-10

jbarrez — Mon, 05 Nov 2012 08:17:39 GMT

Hmmm… not really a clue, actually.

Did you already try the beta war on http://activiti.org/download.html ?

Re: configure mysql for activiti 5-10

smoltok — Mon, 12 Nov 2012 13:59:19 GMT

Just to tell you that you spare me some waste of time !!

Thanks for this post !

Re: configure mysql for activiti 5-10

jbarrez — Tue, 17 Mar 2015 09:33:10 GMT

Yes, that is the correct file indeed.