My Oracle Support Banner

'Test Connection Failed' and 'No suitable driver found' Errors Creating External Data Source (Doc ID 2851459.1)

Last updated on JUNE 06, 2023

Applies to:

Oracle Financial Services Data Integration Hub - Version 8.1.0.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Data Integration Hub (DIH)

Symptoms

In Configure > External Data Store (EDS), you are defining an External Data Store / Data Source.  After entering all of the connection details for an Oracle type, when clicking on the "Test Connection" button, the following error appears:

Test Connection Failed

Additionally, the following error exists in the web server's DIH.log:

[26-01-22 19:27:47.335][ERROR] [DataStoreServiceClient][testConnection]Class not found:
[26-01-22 19:27:47.335][ERROR] [DBConnect][getDBConnection]
java.lang.ClassNotFoundException:
     at java.lang.Class.forName0(Native Method) ~[?:1.8.0_281]
     at java.lang.Class.forName(Class.java:264) ~[?:1.8.0_281]
     at com.ofs.reveleus.DIH.model.DBConnect.getDBConnection(DBConnect.java:195) ~[dih.jar:8.1.0.1.0_10376220982968]
     at com.ofss.fsgbu.dihapp.client.DataStoreServiceClient.testConnection(DataStoreServiceClient.java:179) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.client.DataStoreServiceClient.performAction(DataStoreServiceClient.java:119) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.servlet.DIHServletHelper.invokeActions(DIHServletHelper.java:144) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.servlet.DIHServlet.doPost(DIHServlet.java:15) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[servlet-api.jar:4.0.FR]
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[servlet-api.jar:4.0.FR]
     etc.

and

[26-01-22 19:27:47.355][ERROR] [DBConnect][getDBConnection]No suitable driver found for jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER1>)(PORT=<PORT>))(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER2>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>.<DOMAIN>)))
java.sql.SQLException: No suitable driver found for jdbc:oracle:thin:@(DESCRIPTION=(ADDRESS_LIST=(FAILOVER=ON)(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER1>)(PORT=<PORT>))(ADDRESS=(PROTOCOL=TCP)(HOST=<SERVER2>)(PORT=<PORT>)))(CONNECT_DATA=(SERVICE_NAME=<SERVICE NAME>.<DOMAIN>)))
     at java.sql.DriverManager.getConnection(DriverManager.java:689) ~[?:1.8.0_281]
     at java.sql.DriverManager.getConnection(DriverManager.java:247) ~[?:1.8.0_281]
     at com.ofs.reveleus.DIH.model.DBConnect.getDBConnection(DBConnect.java:201) ~[dih.jar:8.1.0.1.0_10376220982968]
     at com.ofss.fsgbu.dihapp.client.DataStoreServiceClient.testConnection(DataStoreServiceClient.java:179) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.client.DataStoreServiceClient.performAction(DataStoreServiceClient.java:119) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.servlet.DIHServletHelper.invokeActions(DIHServletHelper.java:144) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at com.ofss.fsgbu.dihapp.servlet.DIHServlet.doPost(DIHServlet.java:15) ~[dih-app.jar:8.1.0.1.1_10376223977845]
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:652) ~[servlet-api.jar:4.0.FR]
     at javax.servlet.http.HttpServlet.service(HttpServlet.java:733) ~[servlet-api.jar:4.0.FR]
     etc


As a result, you cannot complete the Data Store definition.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.