Re: Command Timeout, because of a locked entry in a table

Article View: borland.public.cppbuilder.database.ado

Article #2559

Back to borland.public.cppbuilder.database.ado Previous Next

#2559

From: Arnie Mauer
Date: Tue, 27 May 2003 12:35

24 lines
1767 bytes

As long as you use only Oracle, you can "SELECT ... FOR UPDATE NOWAIT" and
then handle the exception that gets thrown due to the locked record.

- Arnie

"Wolfgang" <wolfixx@gmx.at> wrote in message
news:3ecd325c$1@newsgroups.borland.com...
> Hi guys,
>
> Can somebody tell me how you would prevent your C++ program into runining
in
> a timeout because you are trying to update a row which somebody else has
> locked (with e.g. select fro update).
>
> I doesn't dependy which class i'm using (BDE or ADO). It takes about 3
> minutes to get an Exception.
> Setting CommandTimeout and ConnectionTimeout to 10 seconds doen't help
> I'm trying to connect to a Oracle 9.2.0.1 server (9.2.0.1 client is
> installed)
>
> hope for some hints
> Wolfgang
>
>

Technical Details

Message-ID: <3ed35b78$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3ecd325c$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,dfefa0183db59a15
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-27 05:40:05 PST
From: "Arnie Mauer" <arnie@earthlink.net>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3ecd325c$1@newsgroups.borland.com>
Subject: Re: Command Timeout, because of a locked entry in a table
Date: Tue, 27 May 2003 08:35:08 -0400
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 209.140.211.97
Message-ID: <3ed35b78$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1054038904 209.140.211.97 (27 May 2003 05:35:04 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-04!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message