AnsweredAssumed Answered

Activiti Database Exception

Question asked by sarkar92 on Feb 25, 2014
Latest reply on Feb 26, 2014 by sarkar92
I am using activiti 5.14 .
In activiti database i am getting the following exception..


Feb 22, 2014 9:05:29 PM org.springframework.transaction.support.TransactionTemplate rollbackOnException
SEVERE: Application exception overridden by rollback exception
org.apache.ibatis.exceptions.PersistenceException:
### Error querying database.  Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 8,015,918 milliseconds ago.  The last packet sent successfully to the server was 8,015,920 milliseconds ago.
### The error may exist in org/activiti/db/mapping/entity/Task.xml
### The error may involve org.activiti.engine.impl.persistence.entity.TaskEntity.selectTaskByQueryCriteria-Inline
### The error occurred while setting parameters
### SQL: select distinct RES.*              from ACT_RU_TASK RES                                    WHERE  RES.ASSIGNEE_ = ?                order by RES.ID_ asc      LIMIT ? OFFSET ?
### Cause: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure

The last packet successfully received from the server was 8,015,918 milliseconds ago.  The last packet sent successfully to the server was 8,015,920 milliseconds ago.
        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.activiti.engine.impl.db.DbSqlSession.selectListWithRawParameter(DbSqlSession.java:286)
        at org.activiti.engine.impl.db.DbSqlSession.selectList(DbSqlSession.java:277)




Recently i came to know that there is a firewall in our production environment which is dropping idle connection after some time.
and this my database config


<bean id="dataSource" class="org.apache.commons.dbcp.BasicDataSource">
        <property name="driverClassName" value="com.mysql.jdbc.Driver" />
        <property name="url" value="jdbc:mysql://10.10.8.23:3306/prod_activiti?autoReconnect=true"/>
        <property name="username" value="dbadmin" />
        <property name="password" value="SfWhfUa35Kun7Fm7" />
        <property name="poolPreparedStatements" value="true" />
        <property name="maxActive" value="300" />
        <property name="maxIdle" value="100" />
        <property name="testOnBorrow" value="true" />
        <property name="testWhileIdle" value="true" />
        <property name="maxWait" value="3000" />
        <property name="validationQuery" value="select 1" />

</bean>



am i doing right configuration ? please help

Outcomes