I recently installed OpenFire to test functionality and so far so good. However we have a desire to encrypt the communications between the OpenFire server and the Oracle database we are using on the back end. The installation was setup with the Oracle Thin Client using the @/servername:port/service syntax as specified in the OpenFire documentation. This worked perfectly for establishing an unencrypted connection, but now we want to try using an encrypted connection to the database. According to an April 2010 whitepaper on the Oracle JDBC Thin driver the JDBC URL must ust the “tcps” protocol in order to activate SSL and it provides the following example:
jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS=(PROTOCOL=tcps) (HOST=servername) (PORT=2484)) (CONECT_DATA=(SERVICE_NAME=servicename)))
Unfortunately, OpenFire does not support this type of entry. Anyone know if there is another way to configure encryption between OpenFire and an Oracle Database?