slfan1989 commented on PR #5663:
URL: https://github.com/apache/hadoop/pull/5663#issuecomment-1556879293
> SQLServer2008
- sp_addApplicationHomeSubCluster
```
FederationStateStore> CREATE PROCEDURE
[dbo].[sp_addApplicationHomeSubCluster]
@applicationId_IN VARCHAR(64),
@homeSubCluster_IN VARCHAR(256),
@applicationContext_IN VARBINARY(MAX),
@storedHomeSubCluster_OUT VARCHAR(256) OUTPUT,
@rowCount_OUT int OUTPUT
AS BEGIN
DECLARE @errorMessage nvarchar(4000)
BEGIN TRY
BEGIN TRAN
-- If application to sub-cluster map
doesn't exist, insert it.
-- Otherwise don't change the current
mapping.
IF NOT EXISTS (SELECT TOP 1 *
FROM
[dbo].[applicationsHomeSubCluster]
WHERE [applicationId] =
@applicationId_IN)
INSERT INTO
[dbo].[applicationsHomeSubCluster] (
[applicationId],
[homeSubCluster],
[createTime],
[applicationContext])
VALUES (
@applicationId_IN,
@homeSubCluster_IN,
GETUTCDATE(),
@applicationContext_IN);
-- End of the IF block
SELECT @rowCount_OUT = @@ROWCOUNT;
SELECT @storedHomeSubCluster_OUT =
[homeSubCluster]
FROM [dbo].[applicationsHomeSubCluster]
WHERE [applicationId] = @applicationId_IN;
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
SET @errorMessage =
dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE())
/* raise error and terminate the execution */
RAISERROR(@errorMessage, --- Error Message
1, -- Severity
-1 -- State
) WITH log
END CATCH
END;
[2023-05-22 17:22:37] completed in 49 ms
```
- sp_updateApplicationHomeSubCluster
```
[2023-05-22 17:22:37] completed in 49 ms
FederationStateStore> IF OBJECT_ID ( '[sp_updateApplicationHomeSubCluster]',
'P' ) IS NOT NULL
DROP PROCEDURE
[sp_updateApplicationHomeSubCluster];
[2023-05-22 17:22:37] completed in 49 ms
FederationStateStore> CREATE PROCEDURE
[dbo].[sp_updateApplicationHomeSubCluster]
@applicationId_IN VARCHAR(64),
@homeSubCluster_IN VARCHAR(256),
@applicationContext_IN VARBINARY(MAX),
@rowCount_OUT int OUTPUT
AS BEGIN
DECLARE @errorMessage nvarchar(4000)
BEGIN TRY
BEGIN TRAN
UPDATE [dbo].[applicationsHomeSubCluster]
SET [homeSubCluster] = @homeSubCluster_IN,
[applicationContext] =
@applicationContext_IN
WHERE [applicationId] = @applicationId_IN;
SELECT @rowCount_OUT = @@ROWCOUNT;
COMMIT TRAN
END TRY
BEGIN CATCH
ROLLBACK TRAN
SET @errorMessage =
dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE())
/* raise error and terminate the execution */
RAISERROR(@errorMessage, --- Error Message
1, -- Severity
-1 -- State
) WITH log
END CATCH
END;
[2023-05-22 17:22:37] completed in 48 ms
```
- sp_getApplicationHomeSubCluster
```
[2023-05-22 17:22:38] completed in 53 ms
FederationStateStore> IF OBJECT_ID ( '[sp_getApplicationHomeSubCluster]',
'P' ) IS NOT NULL
DROP PROCEDURE [sp_getApplicationHomeSubCluster];
[2023-05-22 17:22:38] completed in 49 ms
FederationStateStore> CREATE PROCEDURE
[dbo].[sp_getApplicationHomeSubCluster]
@applicationId_IN VARCHAR(64),
@homeSubCluster_OUT VARCHAR(256) OUTPUT,
@createTime_OUT datetime OUT,
@applicationContext_OUT VARBINARY(MAX) OUTPUT
AS BEGIN
DECLARE @errorMessage nvarchar(4000)
BEGIN TRY
SELECT @homeSubCluster_OUT = [homeSubCluster],
@createTime_OUT = [createTime],
@applicationContext_OUT =
[applicationContext]
FROM [dbo].[applicationsHomeSubCluster]
WHERE [applicationId] = @applicationId_IN;
END TRY
BEGIN CATCH
SET @errorMessage =
dbo.func_FormatErrorMessage(ERROR_MESSAGE(), ERROR_LINE())
/* raise error and terminate the execution */
RAISERROR(@errorMessage, --- Error Message
1, -- Severity
-1 -- State
) WITH log
END CATCH
END;
[2023-05-22 17:22:38] completed in 48 ms
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
