-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Hello, I don't know if this is the right place for this question,
sorry in advance.
So, the question is: how can I wait for a transaction commited data
to be available to other sessions programmatically? I need to read
data in a different session than the one that commits it, but I'm
having timing problems, and can't seem to be able to synchronize
them.
What I've got is something like this:
Session1> INSERT INTO Table VALUES(0);
Session1> COMMIT;
Session2> SELECT FROM Table;
And Session2 is not gettint the values I've just commited.
Many thanks,
Pablo
- --
An assertion is Zen only when it is itself an act and does not refer
to
anything that is asserted in it.
-- (from Bruce Lee's book, The Tao of Jeet Kune Do)
-----BEGIN PGP SIGNATURE-----
Version: PGP 8.0.3
iQA/AwUBQGSRxr6KEogX0AkqEQKGLwCgmR+sn1/YnoRNlNIzK6OVkNo2cm8An2tm
b0dz1bNuAUpFtQbaa/KZHkl3
=ZkFI
-----END PGP SIGNATURE-----