topic Re: Connect a mySQL database in Alfresco Archive

Connect a mySQL database

pkruch — Tue, 17 Jul 2012 10:13:06 GMT

Hi,I have designed a simple process under activiti (start event –> taskuser1 –> taskuser2 –> end event).In the taskuser1, I have a form with some form properties.When I deploy my process under activiti explorer, it works fine with the form.But, my next step is : take data form a mysql datab

Re: Connect a mySQL database

frederikherema1 — Tue, 17 Jul 2012 10:15:15 GMT

You should point the explorer's database config to the right DB, you can't just presume that it's gonna magically find your eclipse-settings :

http://activiti.org/userguide/index.html#databaseConfiguration

Re: Connect a mySQL database

pkruch — Tue, 17 Jul 2012 12:20:05 GMT

Thanks for your very fast response !

I think I don't explain my problem clearly.

I want to keep the H2 Database for the explorer and to have an external database (mysql) where my clients (for example) are stored.
And, I would populate my forms with the data of this external database.

Thanks

Re: Connect a mySQL database

ronald_van_kuij — Tue, 17 Jul 2012 12:29:14 GMT

Uhhmmmm I would not use h2 for production…

Re: Connect a mySQL database

pkruch — Tue, 17 Jul 2012 12:38:30 GMT

No, I am not in production, I am just testing the product and its capabilities for the moment.

Re: Connect a mySQL database

ronald_van_kuij — Tue, 17 Jul 2012 13:45:42 GMT

Let me ask you first to use the user forum next time…

If you want to populate forms form a different database, I suggest using a speparate forms solution e.g. JSF and not the functionality of Activiti. The opinion of others might differ though, but imo te amount of non functional code you have to write to get what you want is to high.

Re: Connect a mySQL database

pkruch — Tue, 17 Jul 2012 14:47:01 GMT

Ok, sorry for this mistake…

I think understand what you said.
In an other way, could we populate an external database with the data filled by a user in a form ?
Or is it also too complicated ?

(And I will repost on the good forum, sorry)