Connect a mySQL database

[pkruch]

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 database and display it into a form property.

How can I do that ?
I tried to add in Preferences –> Data Management –> Connectivity –> Driver Definitions my jdbc driver and it's ok.
But when I right click on my project in the activiti Explorer and choose New –> Other –> Connection Profile and try to add a connection, It doesn't work.
Is it the best way to take data from a database and inject them into a form ?

I try since yesterday but no way to do that.

Thanks for your responses

[frederikherema1]

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

[pkruch]

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

[ronald_van_kuij]

Uhhmmmm I would not use h2 for production…

[pkruch]

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

[ronald_van_kuij]

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.

[pkruch]

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)