SQL Server

Create JWS using the Flattened JSON Serialization Format

See more JSON Web Signatures (JWS) Examples

Creates a JSON Web Signature (JWS) containing 1 signature and output using the flattened JSON serialization format.

Note: This example requires Chilkat v9.5.0.66 or greater.

SQL Server

-- Important: See this note about string length limitations for strings returned by sp_OAMethod calls.
--
CREATE PROCEDURE ChilkatSample
AS
BEGIN
    DECLARE @hr int
    DECLARE @iTmp0 int
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

    --  This requires the Chilkat API to have been previously unlocked.
    --  See Global Unlock Sample for sample code.

    --  Note: This example requires Chilkat v9.5.0.66 or greater.

    --  The JWS to be created will contain one signature using an ECDSA key.

    DECLARE @sbEccJwk int
    EXEC @hr = sp_OACreate 'Chilkat.StringBuilder', @sbEccJwk OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '{"kty":"EC",'
    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '"crv":"P-256",'
    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '"x":"f83OJ3D2xF1Bg8vub9tLe1gHMzV76e8Tus9uPHvRVEU",'
    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '"y":"x_FEzRu9m36HLN_tue659LNpXW6pCyStikYjKIWI5a0",'
    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '"d":"jpsQnnGQmL-YBIffH1136cspYG6-0iY7X1fCE9-E9LI"'
    EXEC sp_OAMethod @sbEccJwk, 'Append', @success OUT, '}'

    DECLARE @eccKey int
    EXEC @hr = sp_OACreate 'Chilkat.PrivateKey', @eccKey OUT

    --  Note: This example loads the ECDSA key from JWK format.  Any format can be loaded
    --  into the private key object. (See the online reference documentation..)
    EXEC sp_OAMethod @sbEccJwk, 'GetAsString', @sTmp0 OUT
    EXEC sp_OAMethod @eccKey, 'LoadJwk', @success OUT, @sTmp0
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @eccKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbEccJwk
        EXEC @hr = sp_OADestroy @eccKey
        RETURN
      END

    --  ---------------------------------------------------
    --  Prepare both a protected and unprotected header.

    DECLARE @jwsProtHdr int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jwsProtHdr OUT

    EXEC sp_OAMethod @jwsProtHdr, 'AppendString', @success OUT, 'alg', 'ES256'

    DECLARE @jwsUnprotHdr int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @jwsUnprotHdr OUT

    EXEC sp_OAMethod @jwsUnprotHdr, 'AppendString', @success OUT, 'kid', 'myEcKey'

    --  ---------------------------------------------------
    DECLARE @jws int
    EXEC @hr = sp_OACreate 'Chilkat.Jws', @jws OUT

    EXEC sp_OAMethod @jws, 'SetProtectedHeader', @success OUT, 0, @jwsProtHdr
    EXEC sp_OAMethod @jws, 'SetUnprotectedHeader', @success OUT, 0, @jwsUnprotHdr

    EXEC sp_OAMethod @jws, 'SetPrivateKey', @success OUT, 0, @eccKey

    DECLARE @bIncludeBom int
    SELECT @bIncludeBom = 0
    DECLARE @payloadStr nvarchar(4000)
    SELECT @payloadStr = 'In our village, folks say God crumbles up the old moon into stars.'
    EXEC sp_OAMethod @jws, 'SetPayload', @success OUT, @payloadStr, 'utf-8', @bIncludeBom

    --  ---------------------------------------------------
    --  Create the JWS.
    --  Indicate we prefer the non-compact, flattened serialization.
    EXEC sp_OASetProperty @jws, 'PreferCompact', 0
    EXEC sp_OASetProperty @jws, 'PreferFlattened', 1

    DECLARE @jwsStr nvarchar(4000)
    EXEC sp_OAMethod @jws, 'CreateJws', @jwsStr OUT
    EXEC sp_OAGetProperty @jws, 'LastMethodSuccess', @iTmp0 OUT
    IF @iTmp0 <> 1
      BEGIN
        EXEC sp_OAGetProperty @jws, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @sbEccJwk
        EXEC @hr = sp_OADestroy @eccKey
        EXEC @hr = sp_OADestroy @jwsProtHdr
        EXEC @hr = sp_OADestroy @jwsUnprotHdr
        EXEC @hr = sp_OADestroy @jws
        RETURN
      END

    --  The jwsStr is contains the flattened JSON in the smallest possible size, which is a single line.
    --  To get in human-readable format, load into a Chilkat JSON object and emit..
    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT

    EXEC sp_OAMethod @json, 'Load', @success OUT, @jwsStr
    EXEC sp_OASetProperty @json, 'EmitCompact', 0
    EXEC sp_OAMethod @json, 'Emit', @sTmp0 OUT
    PRINT @sTmp0

    --  Sample output:

    --  { 
    --    "payload": "SW4gb3VyIHZpbGxhZ2UsIGZvbGtzIHNheSBHb2QgY3J1bWJsZXMgdXAgdGhlIG9sZCBtb29uIGludG8gc3RhcnMu",
    --    "protected": "eyJhbGciOiJFUzI1NiJ9",
    --    "header": { 
    --      "kid": "myEcKey"
    --    },
    --    "signature": "b7V2UpDPytr-kMnM_YjiQ3E0J2ucOI9LYA7mt57vccrK1rb84j9areqgQcJwOA00aWGoz4hf6sMTBfobdcJEGg"
    --  }

    EXEC @hr = sp_OADestroy @sbEccJwk
    EXEC @hr = sp_OADestroy @eccKey
    EXEC @hr = sp_OADestroy @jwsProtHdr
    EXEC @hr = sp_OADestroy @jwsUnprotHdr
    EXEC @hr = sp_OADestroy @jws
    EXEC @hr = sp_OADestroy @json


END
GO