regarding mail server configuration and database configuration

[skverma02]

hello everyone ,

when i configure mail server in activiti-custom-context.xml file and database configuration in db.proprieties  then i am not able to access configure database.
In this case activiti run default database (h2 database ) and if   in this case check  mail server work properly.

activiti-custom-context.xml  mail server configuration

<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">
<property name="mailServerHost" value="cp-47.webhostbox.net" />
<property name="mailServerPort" value="465" />
<property name="mailServerUseSSL" value="true" />
<property name="mailServerUseTLS" value="true" />
<property name="mailServerDefaultFrom" value="saurabh.varma@karexpert.com" />
<property name="mailServerUsername" value="saurabh.varma@karexpert.com" />
<property name="mailServerPassword" value="passward" />
</bean>

and db.properties configuration is

db=mysql
jdbc.driver=com.mysql.jdbc.Driver
jdbc.url=jdbc:mysql://localhost:3306/activiti
jdbc.username=root
jdbc.password=xyz

i want to access mail server with mysql database how i can use it plz help?

[skverma02]

activiti-custom-context.xml mail server configuration


<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">
<property name="mailServerHost" value="cp-47.webhostbox.net" />
<property name="mailServerPort" value="465" />
<property name="mailServerUseSSL" value="true" />
<property name="mailServerUseTLS" value="true" />
<property name="mailServerDefaultFrom" value="saurabh.varma@karexpert.com" />
<property name="mailServerUsername" value="saurabh.varma@karexpert.com" />
<property name="mailServerPassword" value="acx" />
</bean>

[skverma02]

i dont know what is the problem .
But when i crate a new databse in mysql and restart activiti its work fine with new database but again restart activiti, its not use old database ?

[skverma02]

may be problem is solved
actually i am use <property name="jdbcUrl" value="jdbc:mysql://localhost:3306/activiti123" />
    <property name="jdbcDriver" value="com.mysql.jdbc.Driver" />
    <property name="jdbcUsername" value="root" />
    <property name="jdbcPassword" value="root" />

    <!– Database configurations –>
    <property name="databaseSchemaUpdate" value="drop-create" /> 



when i chage this

<property name="databaseSchemaUpdate" value="true" /> 
its work properly..