Question

TCP vs. TCPS Protocol for JDBC Database Connection

  • 22 February 2024
  • 1 reply
  • 102 views

Badge +3

I know that the JDBC database connection can be changed in the MWS Admin console to switch ro another database. So, it follows that we could change the protocol from TCP to TCPS.

The question is: Since TCP is automatically placed in the database connection string, will IFS support the TCPS protocol, or is that configured somewhere in the Oracle database?

 


1 reply

Userlevel 5
Badge +10

It is possible to setup Apps10 and IFS Cloud with Oracle TCPS connection. 
Both sides need to be configured to use certificate on the TCPS connection. I.e. Both Oracle listener and the client jdbcURL need to point to the certificate (wallet). 

Someone followed this once and got it working.
https://docs.oracle.com/en/cloud/paas/data-safe/admds/create-wallet-or-certificates-tls-connection.html#GUID-87A6335A-E403-4007-9C2A-A07BA25AE064

Reply