Re: transaction isolation level

2006-07-13 Thread sheeri kritzer
Apologies for a late reply. 1) The query that tries to insert the invalid entry into Table2 fails. Therefore, if you have 3 separate queries as in the first case, the last one fails, but the first 2 are successful. In the second case, they're all in one query, and if one fails, they all fail. F

Re: Transaction isolation level - potential bug?

2002-10-15 Thread Mark Matthews
Amine Korch wrote: > Hello all. > I have encountered an really annoying problem in MySQL 3.23.49 on Win32. > I am using InnoDB because I need transactions. I use autocommit off. > I'll try best to describe the problem I have: > I have two sessions to my DB. > Session 1 inserts some data into a

RE: transaction isolation level

2002-10-08 Thread Jianliang Zhao
-Jianliang -Original Message- From: Heikki Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 9:56 To: Jianliang Zhao; Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Jianliang, I tested that with two mysql clients, and it appeared to work ok. Check with S

Re: transaction isolation level

2002-10-08 Thread Heikki Tuuri
--+ 1 row in set (0.00 sec) mysql> - Original Message - From: "Jianliang Zhao" <[EMAIL PROTECTED]> To: "Heikki Tuuri" <[EMAIL PROTECTED]>; "Mark Matthews" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Tuesday, October 08,

RE: transaction isolation level

2002-10-08 Thread Jianliang Zhao
i Tuuri [mailto:[EMAIL PROTECTED]] Sent: 2002?10?8? 0:22 To: Mark Matthews Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level Hi! - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002

Re: transaction isolation level

2002-10-07 Thread Heikki Tuuri
Hi! - Original Message - From: "Mark Matthews" <[EMAIL PROTECTED]> Newsgroups: mailing.database.mysql Sent: Tuesday, October 08, 2002 5:07 AM Subject: Re: transaction isolation level > Jianliang Zhao wrote: ... > >>I am connecting to MySql 3.23(innodb) w

Re: transaction isolation level

2002-10-07 Thread Mark Matthews
o:[EMAIL PROTECTED]] >Sent: 2002?10?7? 17:36 >To: Jianliang Zhao >Cc: [EMAIL PROTECTED] >Subject: Re: transaction isolation level > > >On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote: > > >>Hi, >> >>I am connecting to MySql 3.23(inn

RE: transaction isolation level

2002-10-07 Thread Jianliang Zhao
ao Cc: [EMAIL PROTECTED] Subject: Re: transaction isolation level On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote: > Hi, > > I am connecting to MySql 3.23(innodb) with > mysql-connector-java-2.0.14-bin.jar. I set the global transaction > isolation level to READ C

Re: transaction isolation level

2002-10-07 Thread Jeremy Zawodny
On Mon, Oct 07, 2002 at 05:30:57PM -0700, Jianliang Zhao wrote: > Hi, > > I am connecting to MySql 3.23(innodb) with > mysql-connector-java-2.0.14-bin.jar. I set the global transaction > isolation level to READ COMMITTED. However, I still couldn't see the > committed changes through JDBC client.