Fetch and update from database in activiti Explorer

[vaib]

As per my application I have changed the database to Oracle,so i am not able to fetch any value from my table(i Have two table one is user master and second one is updatw usermaster).
Kindly Suggest me a way to fetch the record from the database and update. can you help me out with demo
link and its implemenattion on Activiti Explorer UI or From IDE(Eclipse).

I have a requirement to add custom roles like editor, approver, user. These roles can have different permissions like read only, read write, etc.
I would like to know how can activiti allow me to add roles, assign permissions, and assign users to those roles.
Please help me so that I can test it out. I am very hopeful about making this solution work but so far this is a hurdle in me using activiti

I am very Newbie here thanks in Advance

[vaib]

any sugesstion is very helpful

[jbarrez]

I'm not really following exactly what you want - you kinda are jumping from topic to topic.

Is this about doing a database query? or is this about users and roles?

What is your use case? What do you need to the roles for?

[vaib]

We have a java web application, wherein there is a user management and roles and permission modules. Now each user belongs to a particular domain. We have a list of pre-defined domains. And each user will also be linked to a particular role. All these information is currently being maintained in the application's RDBMS structure.
Now, we need to create a simple workflow, wherein the process is defined based on the roles. Example, first user belonging to Role-A will initiate the task and then it moves to user belonging to Role-B for approval and once approved the task ends. The level of approvals may be customizable. From what I have understood and done in Activiti, it uses information from its own database. So how do we flow our data into activiti or use both at same time??

Also, while creating a workflow, how do we ensure that when the process moves from Role-A to Role-B user, only the Role-B user belonging to the particular domain of Role-A user gets notified about the approval?
Please let me know your suggestions on the same, or if any other details are needed.

[jbarrez]

> it uses information from its own database. So how do we flow our data into activiti or use both at same time??

Activiti uses its own user/group database by default.
If you decide to not use it, you can put into the assignee field whatever you want. However, then you need to do the resolving in the layer of logic you write above Activiti.

> how do we ensure that when the process moves from Role-A to Role-B user, only the Role-B user belonging to the particular domain of
> Role-A user gets notified about the approval

That would be again something you'd have to manage in the layer above. Activiti only cares about assignments and offers queries to retrieve the information. It does not have an opinion on roles, user hierarchies, groups, etc.

[vaib]

Thank you for the response. By the word "managing in the layer above" do you mean that we should perform the operations using the rest-apis available of activiti?

Appreciate your help.

[jbarrez]

No, Activiti is a jar, and you can simply call the API's in java. So you can have your own custom logic 'above' activiti that calls the activiti api's.