Howdy folks,
Has anyone been able to get an encrypted JDBC thin connection setup with SQL Developer?
I'm using version 4.1.1.19 on a 12.1.0.2 database and I've tried to use the method mentioned in this post with no luck:
I set up everything in the database sqlnet.ora file, created a connection with connection type advanced and used this as my JDBC URL(names changed to protect the innocent databases):
Properties prop = new Properties();
prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_LEVEL,"REQUIRED");
prop.setProperty(OracleConnection.CONNECTION_PROPERTY_THIN_NET_ENCRYPTION_TYPES,"(AES128)");
OracleDataSource ods = new OracleDataSource(); ods.setProperties(prop); ods.setURL(jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(ADDRESS=(PROTOCOL=TCP)(HOST=TEST-BOX)(PORT=1521)))(CONNECT_DATA=(SERVICE_NAME=TESTDB)(INSTANCE_NAME=TESTDB))));
Connection conn = ods.getConnection();
When I test the connection in SQL Developer I get the following error:
Status: Failure -Test failed: Invalid connection information specified. Verify the URL format for the specified driver.
Since I can't seem to add encryption properties to the JDBC URL and I can't seem to find a way to add encryption properties anywhere else in SQL Developer I'm kind of stuck.