You can translate the question and the replies:

JDBC driver not connecting to database

I have downloaded & installed denodo-vdp-jdbcdriver-8.0-update-20210209 in an Windows application to create a connection. I am able to successfully connect to the server but it does not appear to be connecting to the database. Full connection URL which includes a database name: jdbc:denodo://myServerName.com:9999/admin I can see a list of all the VDBs on the server but cannot access any data. Are there some additional JDBC settings required? Thanks js
JDBC JDBC driver for Denodo 8 Denodo vdp jdbc driver
user
25-01-2022 14:58:53 -0500
code

1 Answer

Hi, I also came across a similar situation when trying to access the virtual database with the user having **only** CONNECT privilege(not other privileges like metadata, execute, etc.,) over that database. Hence, ensure whether the **user** connecting to the Virtual DataPort has the **necessary privileges** to access the elements in the Virtual Database. For more information, you can refer to [**Types of Access Rights**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/administration/databases_users_and_access_rights_in_virtual_dataport/user_and_access_right_in_virtual_dataport/user_and_access_right_in_virtual_dataport#types-of-access-rights) and [**Access Through JDBC**](https://community.denodo.com/docs/html/browse/8.0/en/vdp/developer/access_through_jdbc/access_through_jdbc#access-through-jdbc) documentation. Hope this helps!
Denodo Team
27-01-2022 05:58:40 -0500
code
You must sign in to add an answer. If you do not have an account, you can register here