Sorry to resend, but didn't see an answer and this is really bugging me...
Is the following scenario or something like it possible? Why and/or where in
the code is this managed...
Client A calls a stateless session bean (A) which starts a new transaction
Stateless session bean A issues call to finder Collection
FooHome.findCheapFoos()
Foo A issues SQL from the ejbFindCheapFoos() - select id, description, price
from foo where price < 10.00;
Foo A returns a collection of FooPK to the container including pk of Foo X
Client B calls a stateless session bean (B) which starts a new transaction
Stateless Session bean B issues call to FooHome.findFooByPK( pk of Foo X )
Stateless Session bean B then updates Foo X so it's price goes from 9.00 to
11.00.
Stateless Session bean completes transaction and commits change to bean to
database
Container decides to load bean X and now reads the new price 11.00... oh oh
Cheers
Jay Walters
