tracking data of business process execution

[sophea]

Dear everyone,

Please help me.
Before I use web logic, in web logic we can get the tracking data of execution of business process from the schema SOA_INFRA. From these data I can get the information of execution time, number of call, number of failure and success.
Now I use activiti and WSO2. I don't know how can I get the tracking data/payload.

Please reply me if you know the solution.
thanks,
sophea

[jbarrez]

Sure, all the information is in the ACT_HI tables

[sophea]

Dear jbarrez,

Thank you so much for your detail.
could you give me more detail info about this table?
I don't know how to access it, because I just install WSO2.
In web logic, i am the one who install the data base and create schema. So I know how to access.
when I use WSO2, i don't unstall the database, could you give a little bit detail.

thanks,
sophea

[sophea]

Dear jbarrez,

If you could tell me step by step to get the execution data, it is great.
1. how to access to the database
2. query

thanks,
sophea

[martin_grofcik]

1. how to access to the database

You should have jdbc connection url in the activiti configuration (file activiti.cfg.xml)
TO access history from the code:
http://www.activiti.org/userguide/#historyQuery

Regards
Martin

[sophea]

dear Martin,

thank you so much for your reply.

regards,
sophea