topic Database server crash in Alfresco Archive https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154580#M109023 <HTML><HEAD></HEAD><BODY><SPAN>Hello,</SPAN><BR /><BR /><SPAN>We are using Activiti in our project. It is great engine. We are facing issue with respect to Database connections.</SPAN><BR /><BR /><SPAN>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.</SPAN><BR /><BR /><SPAN>Details:</SPAN><BR /><SPAN>1. Database : Oracle</SPAN><BR /><SPAN>2. Following is the Activiti.cnf.xml</SPAN><BR /><BR /><PRE class="language-none line-numbers"><CODE><BR />&lt;?xml version="1.0" encoding="UTF-8"?&gt;<BR />&lt;beans xmlns="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>" <BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xmlns:xsi="<A href="http://www.w3.org/2001/XMLSchema-instance" rel="nofollow noopener noreferrer">http://www.w3.org/2001/XMLSchema-instance</A>"<BR />&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp; xsi:schemaLocation="<A href="http://www.springframework.org/schema/beans" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans</A>&nbsp;&nbsp; <A href="http://www.springframework.org/schema/beans/spring-beans.xsd" rel="nofollow noopener noreferrer">http://www.springframework.org/schema/beans/spring-beans.xsd</A>"&gt;<BR /><BR />&nbsp; &lt;bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneProcessEngineConfiguration"&gt;<BR />&nbsp; <BR /> <BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="jdbcUrl" value="jdbc:oracle:thin:@server" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="jdbcDriver" value="oracle.jdbc.driver.OracleDriver" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="jdbcUsername" value="username" /&gt;<BR />&nbsp;&nbsp;&nbsp; &lt;property name="jdbcPassword" value="password" /&gt;<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="databaseSchemaUpdate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="jobExecutorActivate" value="true" /&gt;<BR />&nbsp;&nbsp;&nbsp; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="mailServerHost" value="msxsmtp.server" /&gt; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="mailServerPort" value="123" /&gt; <BR />&nbsp;&nbsp;&nbsp; &lt;property name="processDefinitionCacheLimit" value="10" /&gt;<BR />&nbsp; &lt;/bean&gt;<BR />&lt;/beans&gt;<BR /><SPAN class="line-numbers-rows"><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN><SPAN>‍</SPAN></SPAN></CODE></PRE><BR /></BODY></HTML> Fri, 18 Apr 2014 05:51:17 GMT viresh_managool 2014-04-18T05:51:17Z Database server crash https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154580#M109023 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 : Oracle2 Fri, 18 Apr 2014 05:51:17 GMT https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154580#M109023 viresh_managool 2014-04-18T05:51:17Z Re: Database server crash https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154581#M109024 <HTML><HEAD></HEAD><BODY><SPAN>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, …)</SPAN></BODY></HTML> Tue, 22 Apr 2014 09:19:12 GMT https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154581#M109024 frederikherema1 2014-04-22T09:19:12Z Re: Database server crash https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154582#M109025 <HTML><HEAD></HEAD><BODY><SPAN>Thanks for the response. I will try to implement.</SPAN></BODY></HTML> Thu, 24 Apr 2014 05:12:59 GMT https://connect.hyland.com/t5/alfresco-archive/database-server-crash/m-p/154582#M109025 viresh_managool 2014-04-24T05:12:59Z