Re: [GUSDEV] Concurrent inserts into GUS

[<sfi...@pc...>]

jeetendra-   see below.   -steve

Quoting Jeetendra Soneja <so...@vb...>:

>
> Steve,
>
> Thanks for your reply.
>
> No, I haven't tried such concurrent runs of plug-ins yet. However, I might
> have to do so in the near future.
>
> You said that objects written in one submit() function call are atomic.
> So, if I add a NALocation object as a child of NAFeature object, and I
> call submit() on NAFeature, do these two inserts become one atomic
> transaction ?

yes.   but, i don't think you need to do that.  i am not clear on why 
you think
you will have conflicts.  just running two plugins concurrently should not
cause a problem.

>
> Thanks,
> Jeetendra.
>
> On Fri, September 29, 2006 6:25 pm, sfi...@pc... wrote:
>> jeetendra-
>>
>> no, they are not atomic.  in gus plugins whatever objects are written in
>> one submit() function call are atomic.  but in this case it seems the
>> features are written first and the locations second.
>>
>> however, i do not think this will cause inconsistent data.
>>
>> do you have inconsistent data?
>>
>> steve
>>
>> Quoting Jeetendra Soneja <so...@vb...>:
>>
>>
>>>
>>> I had a question regarding concurrent inserts into GUS. Are the inserts
>>>  into GUS synchronized ? If I have multiple plug-ins inserting data at
>>> the same time, into same tables, can this lead to inconsistent data ?
>>> There are certain cases where the newly inserted primary key is
>>> referenced by other tables. For example, if we are inserting features and
>>> their locations, the plug-in inserts feature first, and uses the primary
>>> key (na_feature_id) of the feature to insert its location(s). Are such
>>> inserts done as one atomic and synchonized transaction ?
>>>
>>> Please let me know.
>>>
>>>
>>> Thank you for your help,
>>> Jeetendra.
>>>
>>>
>>>
>>> -----------------------------------------------------------------------
>>> --
>>> Take Surveys. Earn Cash. Influence the Future of IT
>>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>>> your opinions on IT & business topics through brief surveys -- and earn
>>> cash
>>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVD
>>> EV
>>> _______________________________________________
>>> Gusdev-gusdev mailing list
>>> Gus...@li...
>>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>>
>>>
>>
>>
>>
>>
>> -------------------------------------------------------------------------
>>  Take Surveys. Earn Cash. Influence the Future of IT
>> Join SourceForge.net's Techsay panel and you'll get the chance to share
>> your opinions on IT & business topics through brief surveys -- and earn
>> cash
>> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
>>  _______________________________________________
>> Gusdev-gusdev mailing list
>> Gus...@li...
>> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>>
>>
>
>
> --
> Jeetendra Soneja
> Research Associate (Software Engineer)
> Virginia Bioinformatics Institute
> 0477 Washington St, Phase II - 162-04
> Blacksburg, VA 24060, USA
> Phone: (540)-231-2789
> http://www.vbi.vt.edu
>
>
>
> -------------------------------------------------------------------------
> Take Surveys. Earn Cash. Influence the Future of IT
> Join SourceForge.net's Techsay panel and you'll get the chance to share your
> opinions on IT & business topics through brief surveys -- and earn cash
> http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
> _______________________________________________
> Gusdev-gusdev mailing list
> Gus...@li...
> https://lists.sourceforge.net/lists/listinfo/gusdev-gusdev
>