AnsweredAssumed Answered

Database server crash

Question asked by viresh.managooli on Apr 18, 2014
Latest reply on Apr 24, 2014 by viresh.managooli
Hello,

We are using Activiti in our project. It is great engine. We are facing issue with respect to Database connections.

Connections once opened are not getting closed. Due to which our Database server is getting crashed. Please provide solution to get rid of this issue.

Details:
1. Database : Oracle
2. Following is the Activiti.cnf.xml


<?xml version="1.0" encoding="UTF-8"?>
<beans xmlns="http://www.springframework.org/schema/beans"
       xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
       xsi:schemaLocation="http://www.springframework.org/schema/beans   http://www.springframework.org/schema/beans/spring-beans.xsd">

  <bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration">
 

   
    <property name="jdbcUrl" value="jdbc:oracle:thin:@server" />
    <property name="jdbcDriver" value="oracle.jdbc.driver.OracleDriver" />
    <property name="jdbcUsername" value="username" />
    <property name="jdbcPassword" value="password" />
   
    <property name="databaseSchemaUpdate" value="true" />
   
    <property name="jobExecutorActivate" value="true" />
   
    <property name="mailServerHost" value="msxsmtp.server" />
    <property name="mailServerPort" value="123" />
    <property name="processDefinitionCacheLimit" value="10" />
  </bean>
</beans>

Outcomes