Changes between Version 20 and Version 21 of MapGuideRfc86
- Timestamp:
- 10/06/09 10:05:45 (15 years ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
MapGuideRfc86
v20 v21 64 64 In the example above, it is possible that FDO connections used by executing SQL statements "SAVEPOINT X", "SAVEPOINT Y", "ROLLBACK TO X", "ROLLBACK TO Y" and "COMMIT" are completely different FDO connections. If so, it will result in an error when executing SQL statement "ROLLBACK TO X", "ROLLBACK TO Y" or "COMMIT". If it isn't a nested transaction, it can be resolved by passing an !MgTransaction instance when executing SQL statements because !MapGuide Server will guarantee that operations in the same transaction use the same FDO connection. However, it still has the following two issues. 65 65 * There are only three methods supporting transaction, MgFeatureService::!UpdateFeatures, MgFeatureService::!ExecuteSqlQuery and MgFeatureService::!ExecuteSqlNoQuery. 66 * !MgFeatureService::!BeginTransaction will do something on the DRBMS serverwhen opening a transaction. This has consequences such as updates are only visible in this transaction, and data gets locked.66 * MgFeatureService::!BeginTransaction will do something on the DRBMS serverwhen opening a transaction. This has consequences such as updates are only visible in this transaction, and data gets locked. 67 67 68 68 Another issue is that it may result in a whole bunch of connections are open when using !MgFeatureReader, !MgDataReader or !MgSqlDataReader. Each reader will use an FDO connection exclusively. So in the example below, it will have all of a sudden a whole bunch of admin connections open when you open a connection with admin rights.