topic Issues Running BPMN 2.0 HelloWorld on MySQL in Alfresco Archive

Issues Running BPMN 2.0 HelloWorld on MySQL

zicongwang — Tue, 22 Feb 2011 06:30:05 GMT

Hi all, I installed the Eclipse designer and run a hello world example it can run smoothly. And I configure the database from h2 to mysql the example can run smoothly and no error occurs but I can not find any record in the mysql database when I run the process in the eclipse.The steps I perform is

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

frederikherema1 — Tue, 22 Feb 2011 08:28:57 GMT

Hi,

I recommend putting the activiti.cfg.xml in src/test/resources and check if there are more activiti.cfg.xml files on your test-classpath…

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

zicongwang — Tue, 22 Feb 2011 11:53:48 GMT

Yeah,I have put the activiti.cfg.xml in src/test/resources,but the same issue occurs, I can not get any record from mysql database

Hi,

I recommend putting the activiti.cfg.xml in src/test/resources and check if there are more activiti.cfg.xml files on your test-classpath…

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

frederikherema1 — Wed, 23 Feb 2011 07:10:42 GMT

Does your test leave resources behind? If you use the @Deployment in your tests, the deployment is cascade deleted after the test is finished.

If you cant to be absolutely sure you're using the DB you want, you can add something like this in your test to check:


Assert.assertEquals("mysql", activitiRule.get((ProcessEngineImpl)activitiRule.getProcessEngine()).getProcessEngineConfiguration().getDatabaseType());

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

zicongwang — Thu, 24 Feb 2011 02:19:05 GMT

Thanks for your reply
I add the code to the test and can get the result that I use the mysql

Assert.assertEquals("mysql", activitiRule.get((ProcessEngineImpl)activitiRule.getProcessEngine()).getProcessEngineConfiguration().getDatabaseType());

I use the @Deployment in my test that may caused the problem.
If I do not use @Deployment , Any other way to replace it so that I can run the test correctly and can also get the result in the mysql databse?

Does your test leave resources behind? If you use the @Deployment in your tests, the deployment is cascade deleted after the test is finished.

If you cant to be absolutely sure you're using the DB you want, you can add something like this in your test to check:
Assert.assertEquals("mysql", activitiRule.get((ProcessEngineImpl)activitiRule.getProcessEngine()).getProcessEngineConfiguration().getDatabaseType());

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

frederikherema1 — Thu, 24 Feb 2011 08:29:28 GMT

Hi,

AFAIK there is nothing wrong with your unit-test, you can check everything you want in the test-method using assertions and afterwards your data is cleaned up, so other tests get a clean DB again.

If you really want to leave things behind, you shouldn't use the @Deployment annotation, but just manually deploy the process-definition in the beginnin of your test, without removing it:


activitiRule.getProcessEngine().getRepositoryService().createDeployment()…

Re: Issues Running BPMN 2.0 HelloWorld on MySQL

jbarrez — Thu, 24 Feb 2011 08:38:00 GMT

You can just call repositoryService.createDeployment().addClasspathResource("your-process').deploy()

That will not clean up your test afterwards.