[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