[mapguide-internals] RE: Motion: vote MapGuide RFC 78

[Trevor Wekel]

Do we also want to clarify which providers support transactions in the Doxygen generated documentation?  It might save some traffic on the mapguide-users list.

+1 Trevor


-----Original Message-----
From: mapguide-internals-bounces at lists.osgeo.org [mailto:mapguide-internals-bounces at lists.osgeo.org] On Behalf Of Tom Fukushima
Sent: Monday, July 27, 2009 9:55 AM
To: MapGuide Internals Mail List
Subject: [mapguide-internals] Motion: vote MapGuide RFC 78

Hi,

I motion for a vote on

MapGuide RFC 78 - Enhance transaction capability to Feature Service
http://trac.osgeo.org/mapguide/wiki/MapGuideRfc78

Summary of review:

What happens when one of ExecuteSqlQuery or ExecuteSqlNonQuery fails?  Does the user need to rollback transaction within exception handling, or is this done automatically?
>>> No action taken.  To give flexibility, the user can do a Rollback in the exception handler.

In case that FDO provider doesn't support transaction, it throws exception?
>>> RFC updated: if a provider doesn't support transaction, BeginTransaction() will throw an MgInvalidOperationException saying transaction is not supported.
 
I think too that it doesn't have to do auto roll back but another question comes to me. I assume that MgTransaction will get hold on one particular FDO connection until either Rollback or Commit is executed ?
>>> Yes, MgTransaction will hold on the particular FDO connection until Commit or Rollback is executed. And there is also a timeout for transaction that if it's not committed or rollbacked within the timeout, the server will automatically rollback the transaction as mentioned in the RFC.  

Add a UpdateFeatures that uses transaction:
>>> Description added.

+1 Tom

Thanks
Tom
_______________________________________________
mapguide-internals mailing list
mapguide-internals at lists.osgeo.org
http://lists.osgeo.org/mailman/listinfo/mapguide-internals