Unable to save the ODI settings from the UI
(Doc ID 2774743.1)
Last updated on MAY 22, 2023
Applies to:
Oracle Financial Services Data Integration Hub - Version 8.1.1 and laterInformation in this document applies to any platform.
Symptoms
Unable to save the ODI settings and we can see the below error in the DIH.log file.
Caused by: java.sql.SQLException: Cannot create JDBC driver of class '' for connect URL 'null'
at org.apache.tomcat.dbcp.dbcp2.DriverFactory.createDriver(DriverFactory.java:75) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:461) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:527) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) ~[tomcat-dbcp.jar:9.0.41]
at com.ofs.aai.database.generic.jndi.TomcatDataSource.getConnection(TomcatDataSource.java:85) ~[aai-core.jar:?]
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConnection(GenericOFSAAConnectionFactory.java:389) ~[aai-core.jar:?]
... 38 more
Caused by: java.sql.SQLException: No suitable driver
at java.sql.DriverManager.getDriver(DriverManager.java:315) ~[?:1.8.0_281]
at org.apache.tomcat.dbcp.dbcp2.DriverFactory.createDriver(DriverFactory.java:60) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createConnectionFactory(BasicDataSource.java:461) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.createDataSource(BasicDataSource.java:527) ~[tomcat-dbcp.jar:9.0.41]
at org.apache.tomcat.dbcp.dbcp2.BasicDataSource.getConnection(BasicDataSource.java:733) ~[tomcat-dbcp.jar:9.0.41]
at com.ofs.aai.database.generic.jndi.TomcatDataSource.getConnection(TomcatDataSource.java:85) ~[aai-core.jar:?]
at com.ofs.aai.database.impl.GenericOFSAAConnectionFactory.getConnection(GenericOFSAAConnectionFactory.java:389) ~[aai-core.jar:?]
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |