topic Problem connecting to H2 database in Alfresco Archive

Problem connecting to H2 database

koteswarrao — Wed, 16 Mar 2011 07:56:27 GMT

hi alli am trying to connect to h2 database from my acitiviti application program without using apache or any other(simply to say, as a standalone system). i implemented one sample application which deployes "start——>user task——->end". when i tried to deploy this workflow i am getting followin

Re: Problem connecting to H2 database

frederikherema1 — Wed, 16 Mar 2011 09:28:38 GMT

What's the value of the property in your activiti config?


<property name="databaseSchemaUpdate"

Re: Problem connecting to H2 database

koteswarrao — Wed, 16 Mar 2011 09:40:41 GMT

thankyou for the prompt reply.

the value of <property name="databaseSchemaUpdate" is set to "true"
why i am getting that error i dont know and moreover, when i create a new activiti project in my eclipse its not creating activiti.cfg.xml file..dont know why?

Re: Problem connecting to H2 database

frederikherema1 — Wed, 16 Mar 2011 10:03:55 GMT

How do you build your process-engine (code in at com.sample.activiti.MainClass.main(MainClass.java:52)) ?

Re: Problem connecting to H2 database

koteswarrao — Wed, 16 Mar 2011 10:24:28 GMT

while creating "activiti" project, i didnt get "activiti.cfg.xml" file in my "src/test/resources". so i manually created one xml file and copied the required properties to it. some times i am getting abover error and if i point out to the "activiti.cfg.xml" file while building processengine its giving error like "there is no "activiti.cfg.xml file found in the classpath".

now i am trying to build processEngine using API as follows

ProcessEngine cachedprocessEngine = ProcessEngineConfiguration.createStandaloneProcessEngineConfiguration()
    .setDatabaseSchemaUpdate(ProcessEngineConfiguration.DB_SCHEMA_UPDATE_TRUE)
    .setJdbcUrl("jdbc:h2:mem:my-own-db;DB_CLOSE_DELAY=1000")
    .setJobExecutorActivate(true)
    .buildProcessEngine();

Re: Problem connecting to H2 database

frederikherema1 — Wed, 16 Mar 2011 10:31:17 GMT

What version of activiti are you running? Setting the databaseSchemaUpdate should do the trick…

Re: Problem connecting to H2 database

koteswarrao — Wed, 16 Mar 2011 10:48:35 GMT

activiti version : 5.3

i dont have "H2" database installed in my system but i am trying to access it
i just started the "h2.start.bat" file which was provided in "activiti installation folder"

Re: Problem connecting to H2 database

koteswarrao — Wed, 16 Mar 2011 11:11:04 GMT

Hi frederikheremans
this is the total summary of my approach

first i downloaded activiti designer plugins using "eclipse s/w updates" then i created Activiti project and included all the actviti jars through "eclipse build path". after creation of project these are the folders which i found in my package explorer
i attached the file with name "package_explorer". there is nothing inside "src/test/resources".

then i tried programing for the workflow using following snippet

package org.activiti;

import org.activiti.engine.ProcessEngine;
import org.activiti.engine.ProcessEngineConfiguration;

public class SampleTask
{
private static ProcessEngine processEngine;
public static void main(String[] args)
{

if(processEngine==null)
{
ProcessEngine processEngine=ProcessEngineConfiguration.createStandaloneProcessEngineConfigurationFromResource("activiti.cfg.xml").buildProcessEngine();
}

System.out.println("processengine"+processEngine.getName());
}

}

then i am getting following error "actviti.cfg.xml" file not found
if i dont specify the file name and tried building with "createdefaultprocessengine" then i am getting above first said error, which is "database tables are not found"

note: i am not using anything other than these. namely no server, no database installation and all.