Unified and persistent system and method for automatic configuration of encryption

A computer program product comprising a computer usable non-transitory medium having a computer readable program, wherein said computer readable program when executed on a computer causes said computer to:

• receive an encryption property from an application;
• receive information relating to a database server;
• request security access to the database server using a first encryption algorithm;
• determine that the request for security access to the database server using the first encryption algorithm is rejected by said database server;
• receive additional information from said database server related to encryption algorithms supported by said database server;
• identify a second encryption algorithm based on the additional information from the database server;
• request security access to the database server using the second encryption algorithm;
• calculate encryption keys;
• and
• cache said second encryption algorithm along with said calculated encryption keys in persistent storage.

A computer system comprising:

• a database driver and a processor, the system configured to perform a method comprising:
• receiving an encryption property from an application;
• receiving information relating to a database server;
• requesting security access to the database server using a first encryption algorithm;
• determining that the request for security access to the database server using the first encryption algorithm is rejected by the database server;
• receiving information from said database server related to encryption algorithms supported by said database server;
• identifying a second encryption algorithm from the encryption algorithms supported by said database server;
• requesting security access to the database server using the second encryption algorithm;
• calculating encryption keys;
• and
• caching said second encryption algorithm along with said calculated encryption keys in persistent storage.