Sybase NNTP forums - End Of Life (EOL)

The NNTP forums from Sybase - forums.sybase.com - are now closed.

All new questions should be directed to the appropriate forum at the SAP Community Network (SCN).

Individual products have links to the respective forums on SCN, or you can go to SCN and search for your product in the search box (upper right corner) to find your specific developer center.

Help Needed. ASA READ_COMMITTED issue

2 posts in General Discussion Last posting was on 2003-10-17 17:56:04.0Z
Raj Pokalori Posted on 2003-10-17 16:50:07.0Z
Reply-To: "Raj Pokalori" <rpokalor@cisco.com>
From: "Raj Pokalori" <rpokalor@cisco.com>
Newsgroups: ianywhere.public.general
Subject: Help Needed. ASA READ_COMMITTED issue
Lines: 27
Organization: Cisco Systems, Inc.
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
X-Original-NNTP-Posting-Host: sj-natpool-220.cisco.com
Message-ID: <3f901ea9$1@forums-2-dub>
X-Original-Trace: 17 Oct 2003 09:54:01 -0700, sj-natpool-220.cisco.com
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 17 Oct 2003 09:43:42 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 17 Oct 2003 09:50:07 -0700
X-Trace: forums-1-dub 1066409407 10.22.108.75 (17 Oct 2003 09:50:07 -0700)
X-Original-Trace: 17 Oct 2003 09:50:07 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1874
Article PK: 4125

Hi all,

I am using ASA v8 and my database setting for isolation level is 1, which is
read committed.

Here is the problem description.

I opened two connections to the database and in the first connection, I
deleted a row from a table but HAVE NOT COMMITTED the transaction.

From the second connection, I selected the rows from the table from where I
deleted a row. The deleted row, though not committed in the other
connection, is not seen in the selected list. With isolation level set to 1,
read committed, I expected to see the deleted row in the selected list of
rows since it was not committed to the database yet by the first connection.

This behavior is causing unexpected results with our application.

Is there a fix for this issue or is there any work around? Any help would be
much appreciated.

Thanks.

Raj Pokalori


Chris Keating (iAnywhere Solutions) Posted on 2003-10-17 17:56:04.0Z
From: "Chris Keating \(iAnywhere Solutions\)" <FightSpam_keating@iAnywhere.com>
Newsgroups: ianywhere.public.general
References: <3f901ea9$1@forums-2-dub>
Subject: Re: Help Needed. ASA READ_COMMITTED issue
Lines: 66
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: keating-xp.sybase.com
X-Original-NNTP-Posting-Host: keating-xp.sybase.com
Message-ID: <3f902d34$1@forums-1-dub>
Date: 17 Oct 2003 10:56:04 -0700
X-Trace: forums-1-dub 1066413364 172.31.140.66 (17 Oct 2003 10:56:04 -0700)
X-Original-Trace: 17 Oct 2003 10:56:04 -0700, keating-xp.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.general:1875
Article PK: 4126

Please do not crosspost. I posted a response to your question in the
sybase.public.sqlanywhere.general to this question.

--

Chris Keating
Sybase Adaptive Server Anywhere Professional Version 8

****************************************************************************
*
Sign up today for your copy of the SQL Anywhere Studio 9 Developer Edition
and try out the market-leading database for mobile, embedded and small to
medium sized business environments for free!

http://www.ianywhere.com/promos/deved/index.html

****************************************************************************
*

iAnywhere Solutions http://www.iAnywhere.com

** Please only post to the newsgroup

** Whitepapers can be found at http://www.iAnywhere.com/developer
** EBFs can be found at http://downloads.sybase.com/swx/sdmain.stm
** Use CaseXpress to report bugs http://casexpress.sybase.com

****************************************************************************
*

"Raj Pokalori" <rpokalor@cisco.com> wrote in message
news:3f901ea9$1@forums-2-dub...
> Hi all,
>
> I am using ASA v8 and my database setting for isolation level is 1, which
is
> read committed.
>
> Here is the problem description.
>
> I opened two connections to the database and in the first connection, I
> deleted a row from a table but HAVE NOT COMMITTED the transaction.
>
> From the second connection, I selected the rows from the table from where
I
> deleted a row. The deleted row, though not committed in the other
> connection, is not seen in the selected list. With isolation level set to
1,
> read committed, I expected to see the deleted row in the selected list of
> rows since it was not committed to the database yet by the first
connection.
>
> This behavior is causing unexpected results with our application.
>
> Is there a fix for this issue or is there any work around? Any help would
be
> much appreciated.
>
> Thanks.
>
> Raj Pokalori
>
>
>