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: 2004-01-01 01:22:38 PST Path: archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!news-out.visi.com!petbe.visi.com!eusc.inter.net!news.eusc.inter.net!boavista.snafu.de!news From: Michael Erdmann Newsgroups: comp.lang.ada Subject: Re: GNADE insert problem Date: Thu, 01 Jan 2004 10:17:50 +0100 Organization: http://www.snafu.de/~boavista Message-ID: References: Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1 Content-Transfer-Encoding: 8bit X-Trace: news.eusc.inter.net 1072948957 507 213.73.71.241 (1 Jan 2004 09:22:37 GMT) X-Complaints-To: abuse@eusc.inter.net User-Agent: Pan/0.14.0 (I'm Being Nibbled to Death by Cats!) Xref: archiver1.google.com comp.lang.ada:4011 Date: 2004-01-01T10:17:50+01:00 List-Id: On Wed, 31 Dec 2003 10:42:45 -0500, Robert I. Eachus wrote: > > Maybe the best 'simplification' would be to define the SQL > cursor/environment as a per task attribute. > http://www.adaic.org/standards/95lrm/html/RM-C-7-2.html (Actually a > pointer to the (potentially shared) enviroment would probably be the > best implementation.) > At least i can provide this concept by means of embedded SQL. Them embedded SQL implementation of GNADE does not realy consider any tasking issues. > That way a user who needed to care could insure that either different > tasks did have different (SQL) environments or shared a single environment. > > I don't see any way to get rid of the (mental) pain of those cases where > you do need multiple active SQL cursors, but this way at least, the > simpler cases can be dealt with. I agree on this, if you are using ODBC then you need to take care about cursors, we could provide an intermediate layer which checks, if a cursor is only used within the same task, where it has been allocated. Michael