Path: utzoo!news-server.csri.toronto.edu!rutgers!usc!elroy.jpl.nasa.gov!jarthur!uunet!bonnie.concordia.ca!antares.concordia.ca!nathab
From: nathab@Antares.Concordia.CA ( NATHALIE BELANGER)
Newsgroups: comp.databases
Subject: Re: Ingres:  set lockmode timeout Question
Keywords: Ingres   Ultrix/SQL
Message-ID: <800@antares.Concordia.CA>
Date: 12 Mar 91 23:50:40 GMT
References: <19@mhinfo.UUCP>
Distribution: na
Organization: Concordia University, Montreal Quebec
Lines: 29

In article <19@mhinfo.UUCP> bishop@mhinfo.UUCP (Deborah Bishop) writes:
>We are building a multi-user application using ABF.  I am trying to get    
>timeout (= 2) to return a timeout error 2 seconds after the conflicting 
>lock is requested NOT 2 SECONDS AFTER THE FIRST LOCK IS RELEASED.  (I 
>-- 
>		Deborah Bishop	(uunet!mhinfo!bishop)
>		Mile High Information Services  Suite 3400
>		9101 E. Kenyon   Denver  CO  	80237
>		303) 721-0851

I can't vouch for the Ultrix versions of Ingres but I was working on a 
similar problem on a MIPS machine running Ingres 6.2. My application
(ESQL fortran) issues this command:

        exec sql set lockmode session where
              level = page
              readlock = exclusive
              timeout = 1

right at the beginning of the session.

I specifically tested it this morning, because I had been working on a
'friendly' error message to return to the users. We set up the test this
way: user 1 retreives a record and holds on to it, meanwhile user 2 tries
to retreive the same record. User 2 received a message saying record busy.
User 1 didn't receive any messages. The program in question uses the 
SQLCA facility to check for errors. FYI the sqlcod returned is -4702.

Hope this helps!!!