[storm] Objects not notified when DB chnages
James Henstridge
james at jamesh.id.au
Fri Aug 22 01:49:08 BST 2008
On Fri, Aug 22, 2008 at 1:20 AM, Gerdus van Zyl <gerdusvanzyl at gmail.com> wrote:
> Does find not perform a sql select which will reflect the current
> state of the database?
It will reflect the current state of the database *as seen by the
connection*. Consider the following sequence of events:
1. connection A begins a transaction
2. connection B begins a transaction
3. connection B inserts a row into a table
4. connection B commits its transaction
5. connection A selects all rows from that table
Here, connection A may not see the row inserted by connection B. Once
it commits and starts a new transaction, it will definitely see the
external changes.
James.
More information about the storm
mailing list