While connecting thru JDBC to Oracle 12c Could not initialize class oracle.jdbc.driver.DMSFactory

Hello Experts, While I try connecting to Orcale 12c, I am getting the error "Could not initialize class oracle.jdbc.driver.DMSFactory". Error details below, please note this is first time installed Denodo and trying connect to Oracle db. Details below: at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162] 841610 [SwingWorker-pool-2-thread-2] ERROR 2019-05-15T17:44:11.309 com.denodo.vdb.admin.model.introspect.VQLSourceIntrospectionService [] - com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: java.lang.NoClassDefFoundError: oracle/dms/console/DMSConsole 896604 [SwingWorker-pool-2-thread-1] ERROR 2019-05-15T17:45:06.303 com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy [] - java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory com.denodo.vdb.vdbinterface.common.clientResult.VQLException: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory at com.denodo.vdb.vdbinterface.client.printer.GetVDBObjectPrinter.format(Unknown Source) ~[denodo-vdp-client.jar:7.0.4] at com.denodo.vdb.vdbinterface.common.clientResult.ErrorResult.accept(Unknown Source) ~[denodo-vdp-client.jar:7.0.4] at com.denodo.vdb.vdbinterface.client.VDBProxy.exec(Unknown Source) ~[denodo-vdp-client.jar:7.0.4] at com.denodo.vdb.vdbinterface.client.VDBProxy.exec(Unknown Source) ~[denodo-vdp-client.jar:7.0.4] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy$4.call(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy.execute(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy.execStatement(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at com.denodo.vdb.admin.model.wrapper.WrapperAdminFacade.testJDBCConnection(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at com.denodo.vdb.admin.model.introspect.VQLSourceIntrospectionService.testJDBCConnection(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at com.denodo.vdb.util.introspectionservice.util.jdbc.JDBCAdminUtil.testConnection(Unknown Source) [denodo-vdp-admin.jar:7.0.4] at com.denodo.vdb.admin.gui.components.dockable.datasources.edition.JDBCDataSourceConnectionPanel$5.doInBackground(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at com.denodo.vdb.admin.gui.components.dockable.datasources.edition.JDBCDataSourceConnectionPanel$5.doInBackground(Unknown Source) [denodo-vdp-admintool.jar:7.0.4] at javax.swing.SwingWorker$1.call(SwingWorker.java:295) [?:1.8.0_162] at java.util.concurrent.FutureTask.run(FutureTask.java:266) [?:1.8.0_162] at javax.swing.SwingWorker.run(SwingWorker.java:334) [?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1149) [?:1.8.0_162] at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:624) [?:1.8.0_162] at java.lang.Thread.run(Thread.java:748) [?:1.8.0_162] 896606 [SwingWorker-pool-2-thread-1] ERROR 2019-05-15T17:45:06.305 com.denodo.vdb.admin.model.introspect.VQLSourceIntrospectionService [] - com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxyException: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory 1047619 [SwingWorker-pool-2-thread-6] ERROR 2019-05-15T17:47:37.318 com.denodo.vdb.admin.model.vdbserverproxy.VDBServerProxy [] - java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory com.denodo.vdb.vdbinterface.common.clientResult.VQLException: java.lang.NoClassDefFoundError: Could not initialize class oracle.jdbc.driver.DMSFactory at com.denodo.vdb.vdbinterface.client.printer.GetVDBObjectPrinter.format(Unknown Source) ~[denodo-vdp-client.jar:7.0.4] at com.denodo.vdb.vdbinterface.common.clientResult.ErrorResult.accept(Unknown Source) ~[denodo-vdp-client.jar:7.0.4]
user
15-05-2019 14:20:20 -0400

1 Answer

Hi, You can check if the Oracle driver which comes with denodo is working properly with other clients, if it’s not working then there’s some issue with the driver and not denodo. You can then download oracle driver and use this driver to connect to the JDBC Another thing you can check is if you are using the internal JRE/JDK from the denodo. This error seems to arise because of some library conflicts which java cannot use. I would suggest you to use the internal JRE/JDK to see if you can reproduce the same error You can also download the ojdbc6dms.jar, but the class oracle.jdbc.driver.DMSFactory is already present in the Oracle driver jars located at the location <DENODO_HOME>\lib\extensions\jdbc-drivers\oracle-12c I would also suggest you check if you have configured the data source properly, to connect to Oracle make sure you have selected the proper adapter, in your case Oracle 12c. Denodo platform includes Oracle JDBC driver and once you select the adapter the Driver classpath and Driver class are auto-filled. Make sure, the Driver classpath for Oracle is 'oracle-12c-v12.2.0.1' and Driver class is oracle.jdbc.OracleDriver. The database URI is in format jdbc:oracle:thin:@host:port:database. You can use the login and password authentication for your database and then test the connection. Hope this helps!
Denodo Team
22-05-2019 20:53:51 -0400
You must sign in to add an answer. If you do not have an account, you can register here