Re: GNADE insert problem

["Robert I. Eachus" <rieachus@comcast.net>]

Michael Erdmann wrote:

> Maybe there is some kind to simplifcation requiered for Ada 95 which 
> could be provided by GNADE? Anny sutiable interface you want to propose?
...
> 
>>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.

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.)

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.  Of course, I would implement things so 
that there was a "default" environment that all tasks shared unless you 
explicitly changed the SQL environment for a task by opening an SQL 
session outside the environment task. (Note that the original poster is 
doing that, which puts him at best in a currently undefined situation.) 
  The package that supports this could probably be made optional to 
accomodate any compilers that don't support per task attributes.

-- 
                                           Robert I. Eachus

"The war on terror is a different kind of war, waged capture by capture, 
cell by cell, and victory by victory. Our security is assured by our 
perseverance and by our sure belief in the success of liberty." -- 
George W. Bush