Flow Designer - Not authenticating on Oracle Clusters for JDBC connection strings - Support and Troubleshooting

Flow Designer - Not authenticating on Oracle Clusters for JDBC connection strings Issue This is regarding a connectivity issue when connecting to a clustered Oracle Database instead of a singular database. The JDBC Step has been used in a Flow Design to connect to the "Connection URL". This step will Create a reusable action to send SQL commands to a relational database. When attempting to connect to the database, you may come across the error "Could not connect to the specified database. Please check the logs for more detail.

Cause The connection URL is currently set up to use the SID format and cannot be overridden within the field on the form. The business rule "Build JDBC Connection URL" is forcing the SID format for all Oracle connections and must be modified to include clusters.

Resolution The sampled fix that can be applied to the business rule includes the following:

if (format == Oracle) { this.connection_url = "jdbc:oracle:thin:@" + server + ":" + // bug fix: we need to use service name syntax vs. sid syntax (/ vs. :) // this.sysDataSourceGR.oracle_port + ":" + this.sysDataSourceGR.oracle_sid; this.sysDataSourceGR.oracle_port + "/" + this.sysDataSourceGR.oracle_sid; }