From mboxrd@z Thu Jan  1 00:00:00 1970
X-Spam-Checker-Version: SpamAssassin 3.4.4 (2020-01-24) on polar.synack.me
X-Spam-Level: 
X-Spam-Status: No, score=-1.9 required=5.0 tests=BAYES_00 autolearn=ham
	autolearn_force=no version=3.4.4
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 103376,7179b046d1b6799f
X-Google-Attributes: gid103376,public
X-Google-ArrivalTime: 2003-12-21 01:42:03 PST
Path: 
 archiver1.google.com!news2.google.com!fu-berlin.de!uni-berlin.de!76137-cm.able.ES!not-for-mail
From: Jano <nono@celes.unizar.es>
Newsgroups: comp.lang.ada
Subject: Re: GNADE insert problem
Date: Sun, 21 Dec 2003 10:41:39 +0100
Message-ID: <MPG.1a4f893e2d8c3c2a9897a4@News.CIS.DFN.DE>
References: <MPG.1a4d4871a4a0214a9897a2@News.CIS.DFN.DE>
 <mailman.144.1071885384.31149.comp.lang.ada@ada-france.org>
 <MPG.1a4e39297fd4edd69897a3@News.CIS.DFN.DE>
 <OPKdnWEu7rUWC3miRVn-tA@comcast.com>
NNTP-Posting-Host: 76137-cm.able.es (212.97.176.137)
X-Trace: news.uni-berlin.de 1071999722 9393753 212.97.176.137 ([49872])
X-Newsreader: MicroPlanet Gravity v2.50
Xref: archiver1.google.com comp.lang.ada:3657
Date: 2003-12-21T10:41:39+01:00
List-Id: <comp.lang.ada>

Robert I. Eachus dice...
> Jano wrote:
> 
> > I've workaround it disconnecting from the DB after each insert. Since I 
> > insert a record per minute and the db is local, it can hold that way 
> > until I get into the package you have suggested.
> 
> As an aside, this problem is why I quickly get headaches mixing Ada and 
> SQL.  SQL has this concept of an implicit cursor, and you have to be 
> very careful that every Ada thread containing SQL maintains its own 
> cursor correctly.

My program as a few tasks, but only one of them is making SQL calls 
(though now I think that maybe the initial connection is done from 
another task... room for some experimentation). Good to be warned 
though.

Kind regards,

Alex.