Database server crash

[viresh_managool]

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>
‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍‍

[frederikherema1]

Maybe the behavior of the connection-pool, which keeps the connections open to reuse them. I see you are using NO custom datasource, depending on the default one in Activiti. Recommended to use another datasource and a datasource/connectionpool of your choice, which allows you to configure all the defaults you need for your system (timeouts, max open, …)

[viresh_managool]

Thanks for the response. I will try to implement.