jdbc rollback - best practices ? :)

[MichalKrawczyk]

Hi,

just wanted to ask if anyone has some new thoughts

about jdbc rollbacks in a BPM

scenario:

BPM

send jdbc step

something

send jdbc step

the second step fails and we have to rollback the first one

thanks for any ideas - except new send step with delete:)

BTW

I know if much boader issue but maybe ....

Regards,

michal

[Former Member]

In my opinion, we cannot hold the transactional context open in between two JDBC Send Steps.

If you are accessing the same database schema, then you may consider having ONE Send Step with mutliple Statement nodes in the XML-SQL message.

<root>

<StatementName1>....</StatementName1>

<StatementName2>....</StatementName2>

</root>

Other Option:

If you want solid transactional contexts, then Container Managed Persistence EJBs will help.

[MichalKrawczyk]

Hi,

>>> then Container Managed Persistence EJBs will help.

codking in the java proxy and will probably be the only solution but I wanted to give it a try anyway

thx Adhappan,

Regards,

michal