topic Re: Why could Activiti Test class not getting mysql database access in Alfresco Archive

Why could Activiti Test class not getting mysql database access

pratikbhatt — Fri, 05 Jul 2013 11:25:05 GMT

package org.pratik;import java.util.List;import org.activiti.engine.HistoryService;import org.activiti.engine.ProcessEngine;import org.activiti.engine.ProcessEngineConfiguration;import org.activiti.engine.RepositoryService;import org.activiti.engine.RuntimeService;import org.activiti.engine.TaskServ

Re: Why could Activiti Test class not getting mysql database access

jbarrez — Fri, 05 Jul 2013 11:46:20 GMT

It tries to go to an H2 db, not a Mysql db:

> No suitable driver found for jdbc:h2:tcp://localhost/activiti

Re: Why could Activiti Test class not getting mysql database access

pratikbhatt — Fri, 05 Jul 2013 12:27:50 GMT

Thank you sir for reply, but I have configured activiti.config.xml for mysql yet this error occurring on and on… please give me the guideline if I am missing something
Here is the activiti.config.xml file below.

<bean id="processEngineConfiguration" class="org.activiti.engine.impl.cfg.StandaloneInMemProcessEngineConfiguration">
<property name="jdbcUrl" value="jdbc.mysql://localhost:3306/Activiti" />
<property name="jdbcDriver" value="com.mysql.jdbc.Driver" />
<property name="jdbcUsername" value="root" />
<property name="jdbcPassword" value="root" />
<property name="databaseSchemaUpdate" value="true"/>
</bean>

Re: Why could Activiti Test class not getting mysql database access

frederikherema1 — Tue, 09 Jul 2013 07:45:10 GMT

How do you bootstrap you're process-engine? It seems that the activiti.cfg.xml is not used…

Re: Why could Activiti Test class not getting mysql database access

monika_b — Tue, 26 Nov 2013 06:15:18 GMT

Re: Why could Activiti Test class not getting mysql database access

monika_b — Thu, 28 Nov 2013 06:56:34 GMT

Able to resolve it. I just removed spring style of configuration and used simple way as per user guide. pasting same might help someone.

My activiti.cfg file is:
<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="jdbcracle:thin:@(DESCRIPTION =(ADDRESS_LIST=(ADDRESS = (PROTOCOL = TCP)(HOST = <your IP Address>)(PORT = <your port no>)))(CONNECT_DATA =(SERVER = DEDICATED)(SID =<your SID>)))" /" />
    <property name="jdbcDriver" value="oracle.jdbc.driver.OracleDriver" />
    <property name="jdbcUsername" value="<your username>" />
    <property name="jdbcPassword" value="<your password>" />

    <property name="databaseSchemaUpdate" value="true" />

    <property name="jobExecutorActivate" value="false" />

    <property name="mailServerHost" value="mail.my-corp.com" />
    <property name="mailServerPort" value="5025" />
</bean>

</beans>

and

main method is:
public class MainApp {
/**
* @param args
*/
public static void main(String[] args) {
                ProcessEngine processEngine = ProcessEngines.getDefaultProcessEngine();
RepositoryService repositoryService = processEngine.getRepositoryService();
RuntimeService runtimeService = processEngine.getRuntimeService();
repositoryService.createDeployment().addClasspathResource("diagrams/MyProcess.bpmn20.xml").deploy();
ProcessInstance processInstance = runtimeService.startProcessInstanceByKey("myProcess");
System.out.println("Started Process instance id " +processInstance.getProcessInstanceId());
}

Re: Why could Activiti Test class not getting mysql database access

monika_b — Thu, 28 Nov 2013 06:57:30 GMT

I am facing the same issue. I am bootstrapping through below main method. Please help I am very new to activiti.

Exception: java.sql.SQLException: Error setting driver on UnpooledDataSource. Cause: java.lang.ClassNotFoundException: org.h2.Driver

Re: Why could Activiti Test class not getting mysql database access

michael_vu — Fri, 01 Aug 2014 21:17:13 GMT

Hi,
I can resolve this problem by add db.properties file, and set jdbc.url to my Activiti database
jdbc.url=jdbcostgresql://localhost:5432/activiti

Re: Why could Activiti Test class not getting mysql database access

frederikherema1 — Wed, 06 Aug 2014 08:16:39 GMT

Thanks for coming back on this. You should indeed make sure you use the "activiti.cfg.xml" as name, if you use createStandaloneProcessEngineConfiguration(). if you're config file has a different name or is located elsewhere, you can always use createProcessEngineConfigurationFromInputStream(..).