io.ebean.config.dbplatform.oracle

Class OracleDbEncrypt

java.lang.Object

io.ebean.config.dbplatform.AbstractDbEncrypt

io.ebean.config.dbplatform.oracle.OracleDbEncrypt

All Implemented Interfaces:

DbEncrypt

public class OracleDbEncrypt
extends AbstractDbEncrypt

Oracle encryption support.

You will typically need to create your own encryption and decryption functions similar to the example ones below.

 // Remember your DB user needs execute privilege on DBMS_CRYPTO
 // as well as your encryption and decryption functions


 // This is an Example Encryption function only - please create your own.

CREATE OR REPLACE FUNCTION eb_encrypt(data IN VARCHAR, key in VARCHAR) RETURN RAW IS

    encryption_mode NUMBER := DBMS_CRYPTO.ENCRYPT_AES128 + DBMS_CRYPTO.CHAIN_CBC  + DBMS_CRYPTO.PAD_PKCS5;

    BEGIN
         RETURN DBMS_CRYPTO.ENCRYPT(UTL_I18N.STRING_TO_RAW (data, 'AL32UTF8'),
           encryption_mode, UTL_I18N.STRING_TO_RAW(key, 'AL32UTF8') );
    END;
    /



 // This is an Example Decryption function only - please create your own.

CREATE OR REPLACE FUNCTION eb_decrypt(data IN RAW, key IN VARCHAR) RETURN VARCHAR IS

    encryption_mode NUMBER := DBMS_CRYPTO.ENCRYPT_AES128 + DBMS_CRYPTO.CHAIN_CBC  + DBMS_CRYPTO.PAD_PKCS5;

    BEGIN
         RETURN UTL_RAW.CAST_TO_VARCHAR2(DBMS_CRYPTO.DECRYPT
           (data, encryption_mode, UTL_I18N.STRING_TO_RAW(key, 'AL32UTF8')));
    END;
    /

Constructor Summary

Constructors

Constructor and Description
OracleDbEncrypt() Constructs the Oracle10DbEncrypt with default encrypt and decrypt stored procedures.
OracleDbEncrypt(String encryptFunction, String decryptFunction) Constructs the Oracle10DbEncrypt specifying encrypt and decrypt stored procedures.

Method Summary

Methods inherited from class io.ebean.config.dbplatform.AbstractDbEncrypt

getDbEncryptFunction, getEncryptDbType, isBindEncryptDataFirst

Methods inherited from class java.lang.Object

equals, getClass, hashCode, notify, notifyAll, toString, wait, wait, wait

Constructor Detail

OracleDbEncrypt

public OracleDbEncrypt()

Constructs the Oracle10DbEncrypt with default encrypt and decrypt stored procedures.

OracleDbEncrypt

public OracleDbEncrypt(String encryptFunction,
                       String decryptFunction)

Constructs the Oracle10DbEncrypt specifying encrypt and decrypt stored procedures.

Parameters:

encryptFunction - the encrypt stored procedure

decryptFunction - the decrypt stored procedure