Re: Inconsitent data

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" <[email protected]>
To: <[email protected]>
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: [email protected] [mailto:[email protected]] On Behalf Of Nicholas
Daniels
Sent: Friday, December 16, 2005 9:00 AM
To: [email protected]
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

On Fri, 2005-12-16 at 08:08 +0100, Koller, Georg wrote:
> Hello,
>
> I have a problem with inconstent data.
> Am accessing the Mckoi (1.0.3) database from two different
applications,
> 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.
>
> >>> Both applications get the same values. <<<
>
> 6. Application A modifies data of table.
> 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 data.
> <<<
>
> 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.
>
------------------------------------------------------------------------
------------------------
> [mf2]
>
>
> ---------------------------------------------------------------
> Mckoi SQL Database mailing list  http://www.mckoi.com/database/
> To unsubscribe, send a message to [email protected]
>



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]




------------------------------------------------------------------------------------------------
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 [email protected] 



---------------------------------------------------------------
Mckoi SQL Database mailing list  http://www.mckoi.com/database/
To unsubscribe, send a message to [email protected]