topic The best way to get data from Mysql DB in Alfresco Archive

The best way to get data from Mysql DB

bargan — Wed, 25 Jun 2014 16:44:07 GMT

Hi all,I want to create a custom vacation request process.In my project i have to add somme users in the activiti Mysql DB (i add them in act_user_id), and i create two other tables calls service (this table contains ids, names of services and manager_name) and a table relationship (id_user and id_

Re: The best way to get data from Mysql DB

martin_grofcik — Thu, 26 Jun 2014 06:28:38 GMT

Hi,

1) am i right to create ohter users and tables in activiti DB?

It is possible. On the other hand engine upgrade can be more difficult.
Another possibility is to use expression to get user's manager.

2) How can i get the current user ( should i use serivceTask and implemsts a java code and sql queries or other there is other choice)?

You can use authenticatedUserId in expressions
http://www.activiti.org/userguide/#apiExpressions

3) To store the result of this java class should i use resultVariable ?

If the class implements JavaDelegate interface you can create/update any process variable.

4) at last, how can i do the unit test for this ServiceTask to test if i get the true result?

http://www.activiti.org/userguide/#apiUnitTesting

Regards
Martin

Re: The best way to get data from Mysql DB

bargan — Thu, 26 Jun 2014 09:35:24 GMT

Thank you Martin,
For the first question, can you please give me an example for how using expressions to get the user's manager.

regards

Re: The best way to get data from Mysql DB

martin_grofcik — Fri, 27 Jun 2014 06:52:20 GMT

Hi,

for example you can use beans in expressions to get result.

http://www.activiti.org/userguide/#exposingConfigurationBeans
http://www.activiti.org/userguide/#N10A60

Regards
Martin

Re: The best way to get data from Mysql DB

bargan — Fri, 27 Jun 2014 10:14:54 GMT

Thank you for your response.
Sorry i have an other question: When i try to test my activiti projetc i get this error:
""couldn't check if tables are already present using metadata.
#Error getting a new connection. Cause: java.sql.ESQLException: No suitable driver found for jdbc.mysql://localhost:3306/activiti"".

All Jars are on the projct ( jdbc.mysql, … etc) , also pom.xml and activiti.cfg.xml are configured.

regards,

Re: The best way to get data from Mysql DB

bargan — Fri, 27 Jun 2014 16:08:45 GMT

oh i resolved it,
In act.cfg.xml, i made an error "jdbc.mysql://localhost:3306/activiti", replaced it by "jdbc:mysql://localhost:3306/activiti"

regards,

Re: The best way to get data from Mysql DB

bargan — Fri, 27 Jun 2014 16:15:22 GMT

oh i resolved it,
In act.cfg.xml, i made an error "jdbc.mysql://localhost:3306/activiti", replaced it by "jdbc:mysql://localhost:3306/activiti"

regards,