Connecting Tech Pros Worldwide Help | Site Map

locks, transactions and stored procedures

Newbie
 
Join Date: Oct 2009
Posts: 1
#1: 4 Weeks Ago
hello,

Im calling a db2 sp from a java application. Im not declaring explicitly any transaction at client side.

The stored procedure has a configuration like the following. There is no explicit transaction declared inside the SP as well.

Run_some_code_area1
Select statement to row_xy
Run_some_code_area2
an Update statement to row_xy (the same from the select statement)
Run_some_code_area3

Now, imagine there are two application invoking this same SP, an that each one will try to select and update exactly the same row: row_xy. If application_A is in the Run_some_code_area2 block, will Application B be able to execute with sucess the select statement?


Thank you
Reply