Database Connection Encryption and Integrity Using ColdFusion and Oracle Thin Client

Question

As a ColdFusion data source, we use the Oracle thin client to connect to the database. So basically we use a JDBC URL like jdbc: oracle: thin: @ ... and as the driver class oracle.jdbc.OracleDriver

This works successfully, but we would also like to set the encryption and integrity settings. In Java, this is done in a similar way, setting the Properties object before receiving the connection as follows:

Properties prop = new Properties();
prop.put("oracle.net.encryption_client", "REQUIRED");
prop.put("oracle.net.encryption_types_client", "( DES40 )");
prop.put("oracle.net.crypto_checksum_client", "REQUESTED");
prop.put("oracle.net.crypto_checksum_types_client", "( MD5 )");

...

OracleDataSource ods = new OracleDataSource();
ods.setProperties(prop);
ods.setURL("jdbc:oracle:thin:@localhost:1521:main");
Connection conn = ods.getConnection();

...

Is there a way to pass these parameters to a ColdFusion data source. Ideally, I would like to do this centrally in such a way that no change to all cfquery or cfstoredproc is required.

, , Oracle AS, , " ". . , JNDI DS . , , .

, CF API- CF admin (cfide.adminapi.administrator), Oracle, CF .

.

Answer 1

, ...

ANY ColdFusion datasource.

CF ADMIN, . , " ", " ". , (&), .

:

encryption_client=REQUIRED&encryption_types_client=DES40&crypto_checksum_client=REQUESTED&crypto_checksum_types_client=MD5`

OP , URL- JDBC.

:

Progress Datadirect, JDBC-URL :

jdbc:datadirect:oracle://server;SID=someSID;encryption_client=REQUIRED;encryption_types_client=DES40;crypto_checksum_client=REQUIRED;crypto_checksum_types_client=MD5

, , .

, KIND ... , OTHER.

Answer 2

ColdFusion . , .

, CF- " ". , .

, , .

, .