(SQL Server) Get PDF Signer Certs

See more PDF Signatures Examples

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

Chilkat ActiveX Downloads ActiveX for 32-bit and 64-bit Windows

-- 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)
    -- This example requires the Chilkat API to have been previously unlocked.
    -- See Global Unlock Sample for sample code.

    DECLARE @pdf int
    -- Use "Chilkat_9_5_0.Pdf" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Pdf', @pdf OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    -- Load a PDF that has cryptographic signatures to be validated
    DECLARE @success int
    EXEC sp_OAMethod @pdf, 'LoadFile', @success OUT, 'qa_data/pdf/sign_testing_1/helloSigned2.pdf'
    IF @success = 0
      BEGIN
        EXEC sp_OAGetProperty @pdf, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @pdf
        RETURN
      END

    -- Each time we verify a signature, information about the signature is written into
    -- sigInfo (replacing whatever sigInfo previously contained).
    DECLARE @sigInfo int
    -- Use "Chilkat_9_5_0.JsonObject" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.JsonObject', @sigInfo OUT

    -- Iterate over each signature and validate each.
    DECLARE @numSignatures int
    EXEC sp_OAGetProperty @pdf, 'NumSignatures', @numSignatures OUT
    DECLARE @validated int
    SELECT @validated = 0
    DECLARE @cert int
    -- Use "Chilkat_9_5_0.Cert" for versions of Chilkat < 10.0.0
    EXEC @hr = sp_OACreate 'Chilkat.Cert', @cert OUT

    DECLARE @i int
    SELECT @i = 0
    WHILE @i < @numSignatures
      BEGIN
        EXEC sp_OAMethod @pdf, 'VerifySignature', @validated OUT, @i, @sigInfo


        PRINT 'Signature ' + @i + ' validated: ' + @validated

        -- The GetSignerCert method was added in Chilkat v9.5.0.87
        -- After calling VerifySignature, you can get the signer certificate by calling
        -- GetSignerCert with the same index. 
        EXEC sp_OAMethod @pdf, 'GetSignerCert', @success OUT, @i, @cert
        IF @success <> 0
          BEGIN

            EXEC sp_OAGetProperty @cert, 'SubjectDN', @sTmp0 OUT
            PRINT 'PDF signer certificate: ' + @sTmp0
          END

        SELECT @i = @i + 1
      END


    PRINT 'Finished.'

    EXEC @hr = sp_OADestroy @pdf
    EXEC @hr = sp_OADestroy @sigInfo
    EXEC @hr = sp_OADestroy @cert


END
GO