Connection (transaction problem)

[mduarte]

Sorry all, but I could not find the anwers in the forum.

I am using jBPM as a jar of my server. And my server has its own database. So I have some operations that "integrate" some jbpm tables with my tables.

The problem is when I have a foreign key for a database table. e.g. When I deploy a process definition I have to insert some data in another table with a foreign key to the process definition id.

The problem is the transaction control. as I did not commit my deploy I do not have how to insert a data that has some dependencies of the process definition.

To solve that I thing there is two options:
1. Get the same connection used by jbpm to deploy the process definition and use it to create my statements;
2. Set jbpm to in some cases use a jdbc connection created by me.

is there anyway to do that? the second option could be much better

[kukeltje]

Both are possible. Search the wiki/forums for additional info

[mduarte]

As I said I already tried to look in the wiki and forums to solve the problem. I always do. But I could not find the answer.

[cocampo]

Have you tried to create the jBPM database in the RDBMS you're using? That way, it will be easier to acomplish your mission. Chapter 8 explains how, step by step, and jBPM includes scripts for many RDBMS (in case they didn't included it for your DB, you can always create your script, is not difficult, almost trivial with tools like ERwin, and then contribute to the comunity by sharing your effort and experience).

Regards.

[mduarte]

tks

but as I understood in the chapter 8 its only defined how to create the database. My database is already created in oracle database. My problem is when I need to create a new feature that should use the same connection that jBPM does.