title: How to prevent database renewing its data in camunda
body: <p>I am using 
   - camunda-bpm-wildfly-7.4.0
   - mysql-5.6.24-winx64
   - wildfly-8.2.1.Final
  I have integerated mysql with camunda wildfly.
  My datasource code in the standalone.xml is as follows, </p>
  
  <pre><code>&lt;datasource jta="true" jndi-name="java:jboss/datasources/ProcessEngine" pool-name="ProcessEngine" enabled="true" use-java-context="true" use-ccm="true"&gt;
                  &lt;connection-url&gt;jdbc:mysql://localhost:8888/camundabpm?DB_CLOSE_DELAY=-1;MVCC=TRUE;DB_CLOSE_ON_EXIT=FALSE&lt;/connection-url&gt;
                  &lt;driver&gt;mysql&lt;/driver&gt;
  </code></pre>
  
  <p>How do I prevent the database resetting on server restart? It removes all data and replaces it with new data on every server start. So I am unable to persist my data between server on and off.</p>
  
  <p><strong>Update:</strong>
  I found out that hibernate was deleting the tables from the db So I changed the property from this 
  <code>&lt;property name="hibernate.hbm2ddl.auto" value="create-drop" /&gt;</code> 
  to 
  <code>&lt;property name="hibernate.hbm2ddl.auto" value="update" /&gt;</code> 
  after having a look at  <a href="https://stackoverflow.com/questions/6611437/how-to-make-hibernate-not-drop-tables">How to make Hibernate not drop tables</a>. But now the tasklist process instances are removed and only the tables created by my project remain and all other tables are refreshed with new data.</p>