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.

Concurrency Violation Problem

2 posts in QAnywhere Last posting was on 2006-08-30 15:19:12.0Z
Thomas Posted on 2006-08-29 02:42:06.0Z
From: "Thomas" <thomasyung@danielco.com.hk>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
Subject: Concurrency Violation Problem
Lines: 18
X-Newsreader: Microsoft Outlook Express 6.00.2800.1807
X-MIMEOLE: Produced By Microsoft MimeOLE V6.00.2800.1807
X-Original-NNTP-Posting-Host: 210.3.40.190
Message-ID: <44f3a6e9$1@forums-2-dub>
X-Original-Trace: 28 Aug 2006 19:31:05 -0700, 210.3.40.190
X-Original-NNTP-Posting-Host: forums-2-dub.sybase.com
X-Original-Trace: 28 Aug 2006 19:31:06 -0700, forums-2-dub.sybase.com
NNTP-Posting-Host: forums-master.sybase.com
X-Original-NNTP-Posting-Host: forums-master.sybase.com
Date: 28 Aug 2006 19:42:06 -0700
X-Trace: forums-1-dub 1156819326 10.22.108.75 (28 Aug 2006 19:42:06 -0700)
X-Original-Trace: 28 Aug 2006 19:42:06 -0700, forums-master.sybase.com
X-Authenticated-User: ngsysop
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:208
Article PK: 18777

Hi All,

I use VC# and ADO.Net to write program and connect Sybase Anywhere database.
If I run my program to update database using data adapter, after updated
around 100,000 lines of record. I have tested the program in debug mode.
The problem does not happen to a regular location. It is just happened when
there was a large of data handled. It is un-predictable. There is a
"Concurrency Violation" problem message from catch exception message. Do
you have idea about this?

My Sybase Anywhere database Version is 9.0.2.3320.

Regards,

Thomas


Rob Waywell Posted on 2006-08-30 15:19:12.0Z
From: "Rob Waywell" <rwaywell_no_spam_please@ianywhere.com>
Newsgroups: ianywhere.public.sqlanywhere.qanywhere
References: <44f3a6e9$1@forums-2-dub>
Subject: Re: Concurrency Violation Problem
Lines: 49
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2869
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2962
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: rwaywell-xp2.sybase.com
X-Original-NNTP-Posting-Host: rwaywell-xp2.sybase.com
Message-ID: <44f5ac70$1@forums-1-dub>
Date: 30 Aug 2006 08:19:12 -0700
X-Trace: forums-1-dub 1156951152 10.25.98.235 (30 Aug 2006 08:19:12 -0700)
X-Original-Trace: 30 Aug 2006 08:19:12 -0700, rwaywell-xp2.sybase.com
X-Authenticated-User: techsupp
Path: forums-1-dub!not-for-mail
Xref: forums-1-dub ianywhere.public.sqlanywhere.qanywhere:209
Article PK: 18774

This question would be better off posted to the
sybase.public.sqlanywhere.general newsgroup. When you post there make sure
that you show the actual update you are executing and the SQLCode value that
is being returned from the database provider.

--
-----------------------------------------------
Robert Waywell
Sybase Adaptive Server Anywhere Developer - Version 8
Sybase Certified Professional

Sybase's iAnywhere Solutions

Please respond ONLY to newsgroup

EBF's and Patches: http://downloads.sybase.com
choose SQL Anywhere Studio >> change 'time frame' to all

To Submit Bug Reports:
http://case-express.sybase.com/cx/cx.stm?starturl=casemessage.ssc?CASETYPE=Bug

SQL Anywhere Studio Supported Platforms and Support Status
http://my.sybase.com/detail?id=1002288

"Thomas" <thomasyung@danielco.com.hk> wrote in message
news:44f3a6e9$1@forums-2-dub...
> Hi All,
>
> I use VC# and ADO.Net to write program and connect Sybase Anywhere
> database.
> If I run my program to update database using data adapter, after updated
> around 100,000 lines of record. I have tested the program in debug
> mode.
> The problem does not happen to a regular location. It is just happened
> when
> there was a large of data handled. It is un-predictable. There is a
> "Concurrency Violation" problem message from catch exception message. Do
> you have idea about this?
>
> My Sybase Anywhere database Version is 9.0.2.3320.
>
> Regards,
>
> Thomas
>
>
>