private void commitDataStore(IGxDataStore ds, String auditObjectName)
        {
            GXLogging.Debug(log, "DataStoreProvider commit auditObjectName:" + auditObjectName);
            GxCommand cmd = new GxCommand(ds.Db, "commit", ds, 0, false, true, _errorHandler);

            cmd.ErrorMask = GxErrorMask.GX_NOMASK;
            try
            {
                ds.Commit();
            }
            catch (Exception dbEx)
            {
                //If commit fails it should not retry, it makes no sense because it will no longer be possible. just close the existing connection.
                int status           = 0;
                GxADODataException e = new GxADODataException(dbEx);
                bool retry           = false;
                int  retryCount      = 0;
                bool pe = ds.Connection.DataRecord.ProcessError(e.DBMSErrorCode, e.ErrorInfo, cmd.ErrorMask, ds.Connection, ref status, ref retry, retryCount);
                GXLogging.Error(log, "Commit Transaction Error", e);
                retryCount++;
                cmd.processErrorHandler(status, e.DBMSErrorCode, e.SqlState, e.ErrorInfo, cmd.ErrorMask, "FETCH", ref pe, ref retry);
                if (!pe)
                {
                    try
                    {
                        ds.Connection.Close();
                        if (retry)
                        {
                            ds.Connection.Open();
                        }
                    }
                    catch (Exception ex)
                    {
                        GXLogging.Error(log, "beginTransaction in commit transaction failed", ex);
                        throw (new GxADODataException(e.ToString(), e));
                    }
                }
            }
            cmd.Dispose();
        }
        private void rollbackDataStore(IGxDataStore ds, String auditObjectName)
        {
            GxCommand cmd = new GxCommand(ds.Db, "rollback", ds, 0, false, true, _errorHandler);

            cmd.ErrorMask = GxErrorMask.GX_NOMASK;
            try
            {
                ds.Rollback();
            }
            catch (Exception dbEx)
            {
                int status           = 0;
                GxADODataException e = new GxADODataException(dbEx);
                bool retry           = false;
                int  retryCount      = 0;
                bool pe = ds.Connection.DataRecord.ProcessError(e.DBMSErrorCode, e.ErrorInfo, cmd.ErrorMask, ds.Connection, ref status, ref retry, retryCount);
                GXLogging.Error(log, "Rollback Transaction Error", e);
                retryCount++;
                cmd.processErrorHandler(status, e.DBMSErrorCode, e.SqlState, e.ErrorInfo, cmd.ErrorMask, "FETCH", ref pe, ref retry);
                if (!pe)
                {
                    try
                    {
                        ds.Connection.Close();
                        if (retry)
                        {
                            ds.Connection.Open();
                        }
                    }
                    catch (Exception ex)
                    {
                        GXLogging.Error(log, "beginTransaction in Rollback transaction failed", ex);
                        throw (new GxADODataException(e.ToString(), e));
                    }
                }
            }
            cmd.Dispose();
        }