cancel
Showing results for 
Search instead for 
Did you mean: 

Separate Schema(s) for JPA Entities?

ryanj1
Champ in-the-making
Champ in-the-making
First, the functionality that allows Activiti process modelers to interact with JPA entities easily from within models is fantastic and is a greatly appreciated piece of functionality within the tool.

With the above said, I've been playing around with the functionality in an effort to write JPA entities to a separate database schema (without using a Service Task and separate classes and configuration files, of course), and it doesn't appear to be possible without making significant modifications within the Activiti code base.

I'm placing this within the Activiti Explorer area of the Forum, because my hope is that I'll be able to interact with processes from within Activiti Explorer and have them update JPA entities in a separate schema while doing so.

If I'm missing something and this is possible without the significant modifications referenced above, please let me know.

-Ryan

P.S. My read is that the issue is with the transaction manager; specifically, the transaction manager needs to apply to both the Activiti schema *and* the JPA transactions, meaning they both have to be co-located in the same database schema.
3 REPLIES 3

ryanj1
Champ in-the-making
Champ in-the-making
Never mind. Apparently all I needed was a few minutes away from this so I could see the proverbial forest instead of the trees. Smiley Happy

If anyone - by chance - is having the same problem, drop me a line and let me know. I'll be happy to help.

lucasmauricio
Champ in-the-making
Champ in-the-making
hi Ryan,

I want to do this, but I don't have a clue.
Can you show me some sample?

regards,
Lucas

meyerd
Champ on-the-rise
Champ on-the-rise
Hi ryanj,

I gather that you are using Spring? If you use Spring's org.springframework.jdbc.datasource.DataSourceTransactionManager than you must make sure that both the process engine and the Jpa EntityManager use the same Datasource.