Re: Impact of making a stored program transactional while running under transaction manager?

2009-03-09 Thread Al
David Karr wrote: it's supposedly good advice in a multi-step stored procedure to have an explicit "start transaction" and "commit" wrapping the work. What is the impact of doing this if the stored procedure is called from code managed by a transaction manager. For instance, in a JEE appserver

Impact of making a stored program transactional while running under transaction manager?

2009-03-09 Thread David Karr
it's supposedly good advice in a multi-step stored procedure to have an explicit "start transaction" and "commit" wrapping the work. What is the impact of doing this if the stored procedure is called from code managed by a transaction manager. For instance, in a JEE appserver and a transaction ma