SQL Server

Duplicate Java AES Results

See more Encryption Examples

Demonstrates how to duplicate Java code for AES encryption. 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 @crypt int
    EXEC @hr = sp_OACreate 'Chilkat.Crypt2', @crypt OUT
    IF @hr <> 0
    BEGIN
        PRINT 'Failed to create ActiveX component'
        RETURN
    END

    EXEC sp_OASetProperty @crypt, 'CryptAlgorithm', 'aes'
    EXEC sp_OASetProperty @crypt, 'CipherMode', 'cbc'
    EXEC sp_OASetProperty @crypt, 'KeyLength', 256

    EXEC sp_OAMethod @crypt, 'SetEncodedIV', NULL, '000102030405060708090A0B0C0D0E0F', 'hex'
    EXEC sp_OAMethod @crypt, 'SetEncodedKey', NULL, 'uX1AytOx2bqKn1G1NiblFM3YrEMnvciC', 'ascii'

    EXEC sp_OASetProperty @crypt, 'EncodingMode', 'hex'

    DECLARE @encrypted nvarchar(4000)
    EXEC sp_OAMethod @crypt, 'EncryptStringENC', @encrypted OUT, 'tmpString'

    PRINT @encrypted

    EXEC sp_OAMethod @crypt, 'DecryptStringENC', @sTmp0 OUT, @encrypted
    PRINT @sTmp0

    -- The above Chilkat code duplicates the following Java code:

    -- import javax.crypto.Cipher;
    -- import javax.crypto.spec.IvParameterSpec;
    -- import javax.crypto.spec.SecretKeySpec;
    -- 
    -- public class Test {
    -- 	private static final String KEY = "uX1AytOx2bqKn1G1NiblFM3YrEMnvciC";
    -- 	private static final String IV = "000102030405060708090A0B0C0D0E0F";
    -- 
    -- 	private static final char[] HEX_ARRAY = "0123456789ABCDEF".toCharArray();
    -- 	public static String bytesToHex(byte[] bytes) {
    -- 	    char[] hexChars = new char[bytes.length * 2];
    -- 	    for (int j = 0; j < bytes.length; j++) {
    -- 	        int v = bytes[j] & 0xFF;
    -- 	        hexChars[j * 2] = HEX_ARRAY[v >>> 4];
    -- 	        hexChars[j * 2 + 1] = HEX_ARRAY[v & 0x0F];
    -- 	    }
    -- 	    return new String(hexChars);
    -- 	}
    -- 	public static byte[] hexToBytes(String s) {
    -- 	    int len = s.length();
    -- 	    byte[] data = new byte[len / 2];
    -- 	    for (int i = 0; i < len; i += 2) {
    -- 	        data[i / 2] = (byte) ((Character.digit(s.charAt(i), 16) << 4)
    -- 	                             + Character.digit(s.charAt(i+1), 16));
    -- 	    }
    -- 	    return data;
    -- 	}
    -- 	public static byte[] encrypt(String value) {
    -- 		try {
    -- 			System.out.println("---- encrypt ----");
    -- 			IvParameterSpec iv = new IvParameterSpec(hexToBytes(IV));
    -- 			SecretKeySpec skeySpec = new SecretKeySpec(KEY.getBytes("ASCII"), "AES");
    -- 			Cipher cipher = Cipher.getInstance("AES/CBC/PKCS5Padding");
    -- 			cipher.init(Cipher.ENCRYPT_MODE, skeySpec, iv);
    -- 			byte[] encrypted = cipher.doFinal(value.getBytes("ASCII"));
    -- 			String x = bytesToHex(encrypted);
    -- 			System.out.println(x);
    -- 			return encrypted;
    -- 		} catch (Exception ex) {
    -- 			ex.printStackTrace();
    -- 			return null;
    -- 		}
    -- 	}
    -- 
    -- 	public static String decrypt(byte[] encrypted) {
    -- 		try {
    -- 			System.out.println("---- decrypt ----");
    -- 			IvParameterSpec iv = new IvParameterSpec(hexToBytes(IV));
    -- 			SecretKeySpec skeySpec = new SecretKeySpec(KEY.getBytes("ASCII"), "AES");
    -- 			Cipher cipher = Cipher.getInstance("AES/CBC/PKCS5Padding");
    -- 			cipher.init(Cipher.DECRYPT_MODE, skeySpec, iv);
    -- 			byte[] original = cipher.doFinal(encrypted);
    -- 			String x = new String(original);
    -- 			System.out.println(x);
    -- 			return x;
    -- 		} catch (Exception ex) {
    -- 			ex.printStackTrace();
    -- 			return null;
    -- 		}
    -- 
    -- 	}
    -- 
    -- 	public static void main(String[] args) {
    -- 		byte[] encrypted = encrypt("tmpString");
    -- 		decrypt(encrypted);
    -- 	}
    -- }
    -- 

    EXEC @hr = sp_OADestroy @crypt


END
GO