WebSphere Application Server - Can WAS take over the transaction manager of database?

This is Interesting: Free IT Magazines  
Home > Archive > WebSphere Application Server > April 2005 > Can WAS take over the transaction manager of database?





You are viewing an archived Text-only version of the thread. To view this thread in it's original format and/or if you want to reply to this thread please [click here]

Author Can WAS take over the transaction manager of database?

2005-04-29, 3:10 am

If I have more than one store procedure in database, and these store procedures should be invoked by a ejb class, can I put the transactions of stored procedures and other Java process into the same transaction together?

In other words, the transaction manager can take over the transaction of database? Is there some requirement to set some configuration for this? How?

Thanks very much in advance.
Paul Ilechko

2005-04-29, 8:11 am

bill_bill_chca@hotmail.com wrote:
> If I have more than one store procedure in database, and these store
> procedures should be invoked by a ejb class, can I put the
> transactions of stored procedures and other Java process into the
> same transaction together?
>
> In other words, the transaction manager can take over the transaction
> of database? Is there some requirement to set some configuration for
> this? How?


Yes, provided you don't have any transaction control statements (such as
commit) in your stored procedures.

Sponsored Links






Free braindumps | Software forum | Database administration forum

Copyright 2003 - 2008 webservertalk.com