Activiti and MySql Database | Urgent

[agrawalanish]

Hi,

Have done the configurations as specified in user guide. Getting below error when using mysql database with activiti. Please help me out on this.

2014-04-03 18:32:24,958 ERROR [localhost-startStop-1    ] (CommandContext.java           :140)        - Error while closing command context
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: java.lang.IllegalArgumentException: null source
### The error may exist in org/activiti/db/mapping/entity/Property.xml
### The error may involve defaultParameterMap
### The error occurred while setting parameters
### SQL: select VALUE_ from ACT_GE_PROPERTY where NAME_ = 'schema.version'
### Cause: java.lang.IllegalArgumentException: null source
                at org.apache.ibatis.exceptions.ExceptionFactory.wrapException(ExceptionFactory.java:23)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:107)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:98)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:62)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectOne(DefaultSqlSession.java:57)
                at org.activiti.engine.impl.db.DbSqlSession.getDbVersion(DbSqlSession.java:642)
                at org.activiti.engine.impl.db.DbSqlSession.dbSchemaCheckVersion(DbSqlSession.java:598)
                at org.activiti.engine.impl.db.DbSqlSession.performSchemaOperationsProcessEngineBuild(DbSqlSession.java:1012)
                at org.activiti.engine.impl.SchemaOperationsProcessEngineBuild.execute(SchemaOperationsProcessEngineBuild.java:25)
                at org.activiti.engine.impl.interceptor.CommandInvoker.execute(CommandInvoker.java:24)
                at org.activiti.engine.impl.interceptor.CommandContextInterceptor.execute(CommandContextInterceptor.java:57)
                at org.activiti.spring.SpringTransactionInterceptor$1.doInTransaction(SpringTransactionInterceptor.java:47)
                at org.springframework.transaction.support.TransactionTemplate.execute(TransactionTemplate.java:133)
                at org.activiti.spring.SpringTransactionInterceptor.execute(SpringTransactionInterceptor.java:45)
                at org.activiti.engine.impl.interceptor.LogInterceptor.execute(LogInterceptor.java:31)
                at org.activiti.engine.impl.cfg.CommandExecutorImpl.execute(CommandExecutorImpl.java:40)
                at org.activiti.engine.impl.ProcessEngineImpl.<init>(ProcessEngineImpl.java:72)
                at org.activiti.engine.impl.cfg.ProcessEngineConfigurationImpl.buildProcessEngine(ProcessEngineConfigurationImpl.java:363)
                at org.activiti.spring.SpringProcessEngineConfiguration.buildProcessEngine(SpringProcessEngineConfiguration.java:61)
                at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:56)
                at org.activiti.spring.ProcessEngineFactoryBean.getObject(ProcessEngineFactoryBean.java:32)
                at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.doGetObjectFromFactoryBean(FactoryBeanRegistrySupport.java:144)
                at org.springframework.beans.factory.support.FactoryBeanRegistrySupport.getObjectFromFactoryBean(FactoryBeanRegistrySupport.java:103)
                at org.springframework.beans.factory.support.AbstractBeanFactory.getObjectForBeanInstance(AbstractBeanFactory.java:1514)
                at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:252)
                at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
                at org.springframework.beans.factory.support.ConstructorResolver.instantiateUsingFactoryMethod(ConstructorResolver.java:354)
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.instantiateUsingFactoryMethod(AbstractAutowireCapableBeanFactory.java:1094)
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBeanInstance(AbstractAutowireCapableBeanFactory.java:989)
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.doCreateBean(AbstractAutowireCapableBeanFactory.java:504)
                at org.springframework.beans.factory.support.AbstractAutowireCapableBeanFactory.createBean(AbstractAutowireCapableBeanFactory.java:475)
                at org.springframework.beans.factory.support.AbstractBeanFactory$1.getObject(AbstractBeanFactory.java:304)
                at org.springframework.beans.factory.support.DefaultSingletonBeanRegistry.getSingleton(DefaultSingletonBeanRegistry.java:228)
                at org.springframework.beans.factory.support.AbstractBeanFactory.doGetBean(AbstractBeanFactory.java:300)
                at org.springframework.beans.factory.support.AbstractBeanFactory.getBean(AbstractBeanFactory.java:195)
                at org.springframework.beans.factory.support.DefaultListableBeanFactory.preInstantiateSingletons(DefaultListableBeanFactory.java:700)
                at org.springframework.context.support.AbstractApplicationContext.finishBeanFactoryInitialization(AbstractApplicationContext.java:760)
                at org.springframework.context.support.AbstractApplicationContext.refresh(AbstractApplicationContext.java:482)
                at org.springframework.web.context.ContextLoader.configureAndRefreshWebApplicationContext(ContextLoader.java:381)
                at org.springframework.web.context.ContextLoader.initWebApplicationContext(ContextLoader.java:293)
                at org.springframework.web.context.ContextLoaderListener.contextInitialized(ContextLoaderListener.java:106)
                at org.apache.catalina.core.StandardContext.listenerStart(StandardContext.java:4939)
                at org.apache.catalina.core.StandardContext.startInternal(StandardContext.java:5434)
                at org.apache.catalina.util.LifecycleBase.start(LifecycleBase.java:150)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1559)
                at org.apache.catalina.core.ContainerBase$StartChild.call(ContainerBase.java:1549)
                at java.util.concurrent.FutureTask$Sync.innerRun(FutureTask.java:334)
                at java.util.concurrent.FutureTask.run(FutureTask.java:166)
                at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1145)
                at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:615)
                at java.lang.Thread.run(Thread.java:722)
Caused by: java.lang.IllegalArgumentException: null source
                at java.util.EventObject.<init>(EventObject.java:56)
                at javax.sql.StatementEvent.<init>(StatementEvent.java:64)
                at com.mysql.jdbc.jdbc2.optional.JDBC4PreparedStatementWrapper.close(JDBC4PreparedStatementWrapper.java:70)
                at org.apache.ibatis.executor.BaseExecutor.closeStatement(BaseExecutor.java:231)
                at org.apache.ibatis.executor.SimpleExecutor.doQuery(SimpleExecutor.java:59)
                at org.apache.ibatis.executor.BaseExecutor.queryFromDatabase(BaseExecutor.java:259)
                at org.apache.ibatis.executor.BaseExecutor.query(BaseExecutor.java:132)
                at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:105)
                at org.apache.ibatis.executor.CachingExecutor.query(CachingExecutor.java:81)
                at org.apache.ibatis.session.defaults.DefaultSqlSession.selectList(DefaultSqlSession.java:104)
                … 49 more

[agrawalanish]

To add, using below confiuration -

<bean id="processEngineConfiguration" class="org.activiti.spring.SpringProcessEngineConfiguration">
              <property name="databaseType" value="mysql" />
              <property name="dataSource" ref="tradeDataSource2" />
              <property name="transactionManager" ref="transactionManager" />
              <property name="jpaEntityManagerFactory" ref="entityManagerFactory2" />
              <property name="transactionsExternallyManaged" value="true" />
              <property name="databaseSchemaUpdate" value="true" />
              <property name="jobExecutorActivate" value="false" />
              <property name="mailServerHost" value="${mailServer.host}" />
              <property name="mailServerPort" value="${mailServer.port}" />
              <property name="mailServerUsername" value="${mailServer.user}" />
              <property name="mailServerPassword" value="${mailServer.password}" />
       </bean>

[jbarrez]

Could you post your config file?

If I google your error, it seems to indicate that the driver is outdated.

[agrawalanish]

Attached is config file

[agrawalanish]

Hi,

Any update on this.

Regards,
Anish

[agrawalanish]

Hi,

Please help.

Regards,
Anish

[agrawalanish]

Hi Everyone,

Please help me out on this.

Regards,
Anish