You can translate the question and the replies:

Java connection to Oracle through Denodo

Hi, I need to access the oralce database through denodo server from my java program. I removed ojdbc7.jar but i am using denodo-vdp-jdbcdriver.jar I don't want to create tables in denodo from oracle.In such case I already have connection from denodo to oracle but I want to use that connection in my java application to use oralce table. I dont want to access oracle directly from my application.
user
21-08-2019 07:56:40 -0400

1 Answer

Hi, I understand that your are trying to connect to an oracle table using denodo-vdp-jdbcdriver.jar. This Jar file is used specifically to connect objects available in the Virtual DataPort server via any third-party JDBC applications. Hence to use this jar, I need to have the intended oracle table imported into the Virtual DataPort server as a view object. For your scenario, I would go with the recommended and simple approach which is to connect Denodo to Oracle database using the out of the box JDBC adapter. This will create the tables in Oracle as base views and then expose it through the Denodo JDBC driver to access it from any consuming application. You can refer to the [JDBC Sources](https://community.denodo.com/docs/html/browse/7.0/vdp/administration/creating_data_sources_and_base_views/jdbc_sources/jdbc_sources) section of the Virtual DataPort Administration guide and [Access through JDBC](https://community.denodo.com/docs/html/browse/7.0/vdp/developer/access_through_jdbc/access_through_jdbc) section of the Virtual DataPort Developer Guide for more detailed information. Hope this helps!
Denodo Team
22-08-2019 04:53:53 -0400
You must sign in to add an answer. If you do not have an account, you can register here