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]