That doesn’t look like the JDBC url format, but, if the issue is ‘no suitable driver’ that means that the driver to handle the jdbc ins’t loaded. You should check your logs for messages related to ‘failed to load driver…’
WebAPI is the only thing that connects to the database, so I’m not sure what yo umean when you distingish 'between the webserver and oracle db or between webapi database and oracle db).
The WebAPI is a java program that will make a connection to your postgresql database when it needs to read things like cohort definitions. This connection setting is defined in your settings.xml file and populated in the application during the .WAR file build (with the mvn command). WebAPI will connect to your CDM database using the values in the source database when trying to do cohort generation or vocabulary searches. But in both cases the WebAPI Java program makes the connection to either the postgresql or oracle.
In your case, I think the problem is that the oracle driver is not being installed in the WAR file, but I can’t be sure unless you can find the error of ‘Failed to load driver for Oracle’ in the log. If you do find that message, that means we have to configure the WebAPI WAR build to include the oracle driver.
@gregk, you have an environment which hosts the WebAPI database on Postgresql, but has SOURCE records that point to a Oracle CDM instance, right? Can you provide any special instructions to get the oracle driver loaded in the WAR file when people have their WebAPI database in PostgresSQL, but have other sources configured for other DBMS like oracle?