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 02:38:05 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 11:37:40 +0100
Message-ID: <MPG.1a4f9663f0f0e7859897a5@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>
 <MPG.1a4f893e2d8c3c2a9897a4@News.CIS.DFN.DE>
NNTP-Posting-Host: 76137-cm.able.es (212.97.176.137)
X-Trace: news.uni-berlin.de 1072003083 9711605 212.97.176.137 ([49872])
X-Newsreader: MicroPlanet Gravity v2.50
Xref: archiver1.google.com comp.lang.ada:3659
Date: 2003-12-21T11:37:40+01:00
List-Id: <comp.lang.ada>

Jano dice...
> 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.

Just for the record, connecting from the same tasks makes no difference.