Connect and discuss with the Denodo team and data management professionals and enthusiasts
com.denodo.solutionmanager.exceptions.ValidationException: Cannot load driver class: oracle.jdbc.OracleDriver
Hi Team,
i tried to create 'solution manager database' as mentioned in the below link & got error as 'Cannot load driver class: oracle.jdbc.OracleDriver'
https://community.denodo.com/docs/html/browse/8.0/en/solution_manager/administration/configuration/database_configuration/database_configuration#changing-the-password-of-the-external-database
Oracle path :
/app0/SM8-150721/lib/extensions/jdbc-drivers/ oracle-12c-v12.2.0.1
Error:
19384197 [https-jsse-nio-10090-exec-3] ERROR 2021-08-09T13:46:55.453 com.denodo.solutionmanager.rest.controller.util.BaseErrorController [] - Validation error: Cannot load driver class: oracle.jdbc.OracleDriver
com.denodo.solutionmanager.exceptions.ValidationException: Cannot load driver class: oracle.jdbc.OracleDriver
at com.denodo.solutionmanager.service.DatabaseConfigurationService.testDatabaseConfiguration(Unknown Source) ~[solution-manager-lib.jar:8.0.2]
at com.denodo.solutionmanager.service.DatabaseConfigurationService$$FastClassBySpringCGLIB$$17640ba1.invoke(<generated>) ~[solution-manager-lib.jar:8.0.2]
at org.springframework.cglib.proxy.MethodProxy.invoke(MethodProxy.java:218) ~[spring-core-5.2.12.RELEASE.jar!/:5.2.12.RELEASE]
at org.springframework.aop.framework.CglibAopProxy$DynamicAdvisedInterceptor.intercept(CglibAopProxy.java:687) ~[spring-aop-5.2.6.RELEASE.jar!/:5.2.6.RELEASE]
at com.denodo.solutionmanager.service.DatabaseConfigurationService$$EnhancerBySpringCGLIB$$4ee41a35.testDatabaseConfiguration(<generated>) ~[solution-manager-lib.jar:8.0.2]
at com.denodo.solutionmanager.rest.controller.DatabaseConfigurationRestController.testDatabaseConfiguration(Unknown Source) ~[classes!/:8.0.2]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke0(Native Method) ~[?:?]
at jdk.internal.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62) ~[?:?]
at jdk.internal.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43) ~[?:?]
at java.lang.reflect.Method.invoke(Method.java:566) ~[?:?]
at org.springframework.web.method.support.InvocableHandlerMethod.doInvoke(InvocableHandlerMethod.java:190) ~[spring-web-5.2.12.RELEASE.jar!/:5.2.12.RELEASE]
at org.springframework.web.method.support.InvocableHandlerMethod.invokeForRequest(InvocableHandlerMethod.java:138) ~[spring-web-5.2.12.RELEASE.jar!/:5.2.12.RELEASE]
could you please help us on fixing the issue
It seems the jar file(s) of the JDBC driver of Oracle12c is not copied properly to the folder <SOLUTION_MANAGER_HOME>/lib/solution-manager-extensions.
Regards,
Yes, typically to solve this error, I will need to copy the database driver in the correct path.
Before changing the database server, copy the JDBC driver jar to the folder <SOLUTIONMANAGER_HOME>/lib/solution-manager-extensions
I can find the files to be copied in <SOLUTION_MANAGER_HOME>/libextensions/jdbc-drivers. After this for the changes to take effect, I will need to restart the Denodo servers.
Hope this helps!
