Bertrand Szoghy
2005-12-16 13:47:44 UTC
Thanks Andrzej,
I read this and learned something new.
Cheers,
Bert
This is because:
"The McKoi database engine supports the strongest [transaction]
isolation
level defined by the [SQL] standard - TRANSACTION_SERIALIZABLE."
This means that data read once in the transaction remain unchanged
while
this transaction is open.
Greetings,
Andrzej Miazga
----- Original Message -----
From: "Koller, Georg" <***@andrew.com>
To: <***@mckoi.com>
Sent: Friday, December 16, 2005 9:31 AM
Subject: RE: Inconsitent data
Hello Nick,
thanks for your hint,
BUT I already use auto-commit off and I use commit after modifying the
table.
I want to describe a important detail of my problem description.
I stated, that the connection to the database stays open. This means,
when I reconnect application B to the database I get the correct
values.
Thanks,
Georg
-----Original Message-----
From: ***@mckoi.com [mailto:***@mckoi.com] On Behalf Of
Nicholas
Daniels
Sent: Friday, December 16, 2005 9:00 AM
To: ***@mckoi.com
Subject: Re: Inconsitent data
This sounds like you've got auto commit off in, at least, application
A
- if not both. If you had to commit after your write, then both
connections should see the result in your second read.
i.e.:
Application A modifies data of table AND COMMITS.
Application A reads data from table.
Application B reads data from table.
Both applications should have the same data
Hope this helps,
Nick
------------------------
------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
------------------------------------------------------------------------------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information.
If you have received it in error, please notify the sender
immediately and delete the original. Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------------------------------
[mf2]
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
I read this and learned something new.
Cheers,
Bert
This is because:
"The McKoi database engine supports the strongest [transaction]
isolation
level defined by the [SQL] standard - TRANSACTION_SERIALIZABLE."
This means that data read once in the transaction remain unchanged
while
this transaction is open.
Greetings,
Andrzej Miazga
----- Original Message -----
From: "Koller, Georg" <***@andrew.com>
To: <***@mckoi.com>
Sent: Friday, December 16, 2005 9:31 AM
Subject: RE: Inconsitent data
Hello Nick,
thanks for your hint,
BUT I already use auto-commit off and I use commit after modifying the
table.
I want to describe a important detail of my problem description.
I stated, that the connection to the database stays open. This means,
when I reconnect application B to the database I get the correct
values.
Thanks,
Georg
-----Original Message-----
From: ***@mckoi.com [mailto:***@mckoi.com] On Behalf Of
Nicholas
Daniels
Sent: Friday, December 16, 2005 9:00 AM
To: ***@mckoi.com
Subject: Re: Inconsitent data
This sounds like you've got auto commit off in, at least, application
A
- if not both. If you had to commit after your write, then both
connections should see the result in your second read.
i.e.:
Application A modifies data of table AND COMMITS.
Application A reads data from table.
Application B reads data from table.
Both applications should have the same data
Hope this helps,
Nick
Hello,
I have a problem with inconstent data.
Am accessing the Mckoi (1.0.3) database from two different
applications,I have a problem with inconstent data.
Am accessing the Mckoi (1.0.3) database from two different
running on different JVM.
I will explain the behaviour in the next few lines.
1. The mckoi DB is running as a multi-user server. A table with data
exists.
2. Application A starts up and creates a connection to the database.
This connection stays open.
3. Application B starts up and creates a connection to the database.
This connection stays open.
4. Application A reads data from a table.
5. Application B reads data from a table.
6. Application A modifies data of table.
7. Application A reads data from table.
8. Application B reads data from table.
data.I will explain the behaviour in the next few lines.
1. The mckoi DB is running as a multi-user server. A table with data
exists.
2. Application A starts up and creates a connection to the database.
This connection stays open.
3. Application B starts up and creates a connection to the database.
This connection stays open.
4. Application A reads data from a table.
5. Application B reads data from a table.
Both applications get the same values. <<<
7. Application A reads data from table.
8. Application B reads data from table.
Application A gets the new data, Application B gets the old
<<<
Does anyone have a glue?
Thanks in advance for your help,
Georg
------------------------------------------------------------------------Does anyone have a glue?
Thanks in advance for your help,
Georg
------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information.
If you have received it in error, please notify the sender
immediately and delete the original. Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------contain privileged, proprietary, or otherwise private information.
If you have received it in error, please notify the sender
immediately and delete the original. Any unauthorized use of
this email is prohibited.
------------------------
[mf2]
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
------------------------------------------------------------------------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
------------------------------------------------------------------------------------------------
This message is for the designated recipient only and may
contain privileged, proprietary, or otherwise private information.
If you have received it in error, please notify the sender
immediately and delete the original. Any unauthorized use of
this email is prohibited.
------------------------------------------------------------------------------------------------
[mf2]
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com
---------------------------------------------------------------
Mckoi SQL Database mailing list http://www.mckoi.com/database/
To unsubscribe, send a message to mckoidb-***@mckoi.com