Yes, we've tested connecting to a secure database via TCPS and can confirm that this functions.
In our tests, we created an Oracle database (Oracle SE One 18.104.22.168.v7) and configured it to accept TCP as well as TCPS connections.
Upon first connecting you will experience a handshake issue because no valid certificate chain can be created. This is easily resolved by moving the new certificate from the
trusteddirectory in the Acrolinx configuration directory (<ACROLINX_INSTALL_DIR>/ServerConfiguration/server/certificates).
We took the following steps to ensure a successful database connection:
- The default Oracle JDK didn't find a suitable cipher suite to communicate with the server. We downloaded the unlimited JCE policy from the Oracle website and patched the java installation according to the Oracle documentation included in the download. Without this step, we received a handshake_failure.
- If you are still experiencing an SQLException 'Invalid package length'. Please update the JDBC driver in the Acrolinx installation by downloading the latest Java 8 driver from the Oracle website and save it in
server/libs. You can then adjust the 'ojdbc' reference in the Acrolinx