SQL Server

Combine Multiple PKCS12's into a Single Java KeyStore

See more Java KeyStore (JKS) Examples

Combines multiple PKCS12's into a single Java KeyStore (JKS) file. To combine multiple PKCS12 files into a single JKS, simply load each PKCS12 into a PFX object, add it to the Java keystore object via the AddPfx method, and then finally write the Java keystore at the very end. 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

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

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

    DECLARE @pfx int
    EXEC @hr = sp_OACreate 'Chilkat.Pfx', @pfx OUT

    -- Combines several PKCS12's into a single JKS.
    -- Simply load each, add it to the keystore, and then 
    -- save at the very end.

    DECLARE @alias nvarchar(4000)

    DECLARE @pfxPassword nvarchar(4000)

    DECLARE @jksPassword nvarchar(4000)
    SELECT @jksPassword = 'jksSecret'

    -- Add the 1st PFX...
    SELECT @pfxPassword = 'secret1'
    EXEC sp_OAMethod @pfx, 'LoadPfxFile', @success OUT, '/someDir/file1.p12', @pfxPassword
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @pfx, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @jks
        EXEC @hr = sp_OADestroy @pfx
        RETURN
      END

    SELECT @alias = 'alias1'
    EXEC sp_OAMethod @jks, 'AddPfx', @success OUT, @pfx, @alias, @jksPassword
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @jks, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @jks
        EXEC @hr = sp_OADestroy @pfx
        RETURN
      END

    -- Add the 2nd PFX...
    SELECT @pfxPassword = 'secret2'
    EXEC sp_OAMethod @pfx, 'LoadPfxFile', @success OUT, '/someDir/file2.p12', @pfxPassword
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @pfx, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @jks
        EXEC @hr = sp_OADestroy @pfx
        RETURN
      END

    SELECT @alias = 'alias2'
    EXEC sp_OAMethod @jks, 'AddPfx', @success OUT, @pfx, @alias, @jksPassword
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @jks, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
        EXEC @hr = sp_OADestroy @jks
        EXEC @hr = sp_OADestroy @pfx
        RETURN
      END

    -- We can continue adding as many PFX's as desired...

    -- Write the Java keystore to a file:
    EXEC sp_OAMethod @jks, 'ToFile', @success OUT, @jksPassword, '/jksFiles/my.jks'
    IF @success <> 1
      BEGIN
        EXEC sp_OAGetProperty @jks, 'LastErrorText', @sTmp0 OUT
        PRINT @sTmp0
      END
    ELSE
      BEGIN

        PRINT 'Successfully combined multiple PKCS12''s into a single JKS'
      END

    EXEC @hr = sp_OADestroy @jks
    EXEC @hr = sp_OADestroy @pfx


END
GO