SQL Server

Load RSA Public Key from JWK Format (JSON Web Key)

See more RSA Examples

Demonstrates how to load an RSA public key from JWK (JSON Web Key) format.

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

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
    -- Important: Do not use nvarchar(max).  See the warning about using nvarchar(max).
    DECLARE @sTmp0 nvarchar(4000)
    DECLARE @success int
    SELECT @success = 0

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

    -- First build a JWK sample to load..
    DECLARE @json int
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @json OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'kty', 'RSA'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'n', '33TqqLR3eeUmDtHS89qF3p4MP7Wfqt2Zjj3lZjLjjCGDvwr9cJNlNDiuKboODgUiT4ZdPWbOiMAfDcDzlOxA04DDnEFGAf-kDQiNSe2ZtqC7bnIc8-KSG_qOGQIVaay4Ucr6ovDkykO5Hxn7OU7sJp9TP9H0JH8zMQA6YzijYH9LsupTerrY3U6zyihVEDXXOv08vBHk50BMFJbE9iwFwnxCsU5-UZUZYw87Uu0n4LPFS9BT8tUIvAfnRXIEWCha3KbFWmdZQZlyrFw0buUEf0YN3_Q0auBkdbDR_ES2PbgKTJdkjc_rEeM0TxvOUf7HuUNOhrtAVEN1D5uuxE1WSw'
    EXEC sp_OAMethod @json, 'UpdateString', @success OUT, 'e', 'AQAB'

    -- The JSON contains the following:
    -- { 
    --   "kty": "RSA",
    --   "n": "33TqqLR3eeUmDtHS89qF3p4MP7Wfqt2Zjj3lZjLjjCGDvwr9cJNlNDiuKboODgUiT4ZdPWbOiMAfDcDzlOxA04DDnEFGAf-kDQiNSe2ZtqC7bnIc8-KSG_qOGQIVaay4Ucr6ovDkykO5Hxn7OU7sJp9TP9H0JH8zMQA6YzijYH9LsupTerrY3U6zyihVEDXXOv08vBHk50BMFJbE9iwFwnxCsU5-UZUZYw87Uu0n4LPFS9BT8tUIvAfnRXIEWCha3KbFWmdZQZlyrFw0buUEf0YN3_Q0auBkdbDR_ES2PbgKTJdkjc_rEeM0TxvOUf7HuUNOhrtAVEN1D5uuxE1WSw",
    --   "e": "AQAB",
    -- } 

    -- Note: The JSON can contain other members, such as "use", "kid", or anything else.  These will be ignored.
    EXEC sp_OASetProperty @json, 'EmitCompact', 0

    -- Show the JWK string to be loaded:
    DECLARE @jwkStr nvarchar(4000)
    EXEC sp_OAMethod @json, 'Emit', @jwkStr OUT

    DECLARE @pubKey int
    EXEC @hr = sp_OACreate 'Chilkat.PublicKey', @pubKey OUT

    -- The LoadFromString method will automatically detect the format.
    EXEC sp_OAMethod @pubKey, 'LoadFromString', @success OUT, @jwkStr
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @pubKey, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @json
        EXEC @hr = sp_OADestroy @pubKey
        RETURN
      END

    -- OK.. the JWK is loaded.  It can be used in whatever way desired...

    -- The key can be retrieved in any other format, such as XML or PEM..
    EXEC sp_OAMethod @pubKey, 'GetXml', @sTmp0 OUT
    PRINT @sTmp0

    -- XML output:
    -- <RSAPublicKey>
    --     <Modulus>33TqqLR3eeUmDtHS89qF3p4MP7Wfqt2Zjj3lZjLjjCGDvwr9cJNlNDiuKboODgUiT4ZdPWbOiMAfDcDzlOxA04DDnEFGAf+kDQiNSe2ZtqC7bnIc8+KSG/qOGQIVaay4Ucr6ovDkykO5Hxn7OU7sJp9TP9H0JH8zMQA6YzijYH9LsupTerrY3U6zyihVEDXXOv08vBHk50BMFJbE9iwFwnxCsU5+UZUZYw87Uu0n4LPFS9BT8tUIvAfnRXIEWCha3KbFWmdZQZlyrFw0buUEf0YN3/Q0auBkdbDR/ES2PbgKTJdkjc/rEeM0TxvOUf7HuUNOhrtAVEN1D5uuxE1WSw==</Modulus>
    --     <Exponent>AQAB</Exponent>
    -- </RSAPublicKey>

    -- Choose PCKS1 or PCKS8 PEM format..
    DECLARE @bPreferPkcs1 int
    SELECT @bPreferPkcs1 = 0
    EXEC sp_OAMethod @pubKey, 'GetPem', @sTmp0 OUT, @bPreferPkcs1
    PRINT @sTmp0

    -- PEM output
    -- -----BEGIN PUBLIC KEY-----
    -- MIIBIjANBgkqhkiG9w0BAQEFAAOCAQ8AMIIBCgKCAQEA33TqqLR3eeUmDtHS89qF
    -- 3p4MP7Wfqt2Zjj3lZjLjjCGDvwr9cJNlNDiuKboODgUiT4ZdPWbOiMAfDcDzlOxA
    -- 04DDnEFGAf+kDQiNSe2ZtqC7bnIc8+KSG/qOGQIVaay4Ucr6ovDkykO5Hxn7OU7s
    -- Jp9TP9H0JH8zMQA6YzijYH9LsupTerrY3U6zyihVEDXXOv08vBHk50BMFJbE9iwF
    -- wnxCsU5+UZUZYw87Uu0n4LPFS9BT8tUIvAfnRXIEWCha3KbFWmdZQZlyrFw0buUE
    -- f0YN3/Q0auBkdbDR/ES2PbgKTJdkjc/rEeM0TxvOUf7HuUNOhrtAVEN1D5uuxE1W
    -- SwIDAQAB
    -- -----END PUBLIC KEY-----

    EXEC @hr = sp_OADestroy @json
    EXEC @hr = sp_OADestroy @pubKey


END
GO