0

encrypt the database connection over SSL

Situation:

I'm trying to determine if there is a way to encrypt the database connection (to a remote database) over SSL.

It would be of great benefit to be able to access the data in a database via a secure tunnel.

Specifically, Oracle recommends specifying the database URL like this:

-----------------
String url =
"jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps)(HOST=servernam
e)(PORT=2484))(CONNECT_DATA=(SERVICE_NAME=servicename)))";
Properties props = new Properties();
props.setProperty("user", "Homer");
props.setProperty("password", "Simpson");
props.setProperty("oracle.net.ssl_cipher_suites",
"(SSL_DH_anon_WITH_3DES_BDE_CBC_SHA, SSL_DH_anon_WITH_RC4_128_MD5,
SSL_DH_anon_WITH_DES_ABC_SHA)");
Connection conn=DriverManager.getConnection(url,props);
-----------------

So I'd like to know where to put this, if at all.

 

Solution:

 

At this time, placing that URL in the within the Server URL field of the respective Database Info activity will throw an error. The problem is the field will only accept up to 256 characters.

Unfortunately, the 256 character limit seems to be originating from the database. We are planning to release this limitation in a future version.

In the meantime, you can try dynamically overwriting the Database Connection Information using the following forum links:

1) http://support.adeptia.com/entries/21587228-dynamically-over-riding-dbinfo-parameters
2) http://support.adeptia.com/entries/21268792-dynamically-overwriting-activity-attributes

 

0 comments

Post is closed for comments.