comp.lang.ada
 help / color / mirror / Atom feed
From: Jano <nono@celes.unizar.es>
Subject: Re: GNADE insert problem
Date: Sun, 21 Dec 2003 11:37:40 +0100
Date: 2003-12-21T11:37:40+01:00	[thread overview]
Message-ID: <MPG.1a4f9663f0f0e7859897a5@News.CIS.DFN.DE> (raw)
In-Reply-To: MPG.1a4f893e2d8c3c2a9897a4@News.CIS.DFN.DE

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.



  reply	other threads:[~2003-12-21 10:37 UTC|newest]

Thread overview: 10+ messages / expand[flat|nested]  mbox.gz  Atom feed  top
2003-12-19 16:40 GNADE insert problem Jano
2003-12-20  1:55 ` Stephen Leake
2003-12-20  9:47   ` Jano
2003-12-20 18:35     ` Robert I. Eachus
2003-12-21  9:41       ` Jano
2003-12-21 10:37         ` Jano [this message]
2003-12-21 20:32           ` Robert I. Eachus
2003-12-31 12:12         ` Michael Erdmann
2003-12-31 15:42           ` Robert I. Eachus
2004-01-01  9:17             ` Michael Erdmann
replies disabled

This is a public inbox, see mirroring instructions
for how to clone and mirror all data and code used for this inbox