Q&A BY TAG 'JDBC'

You must sign in to ask a question. If you do not have an account, you can register here

DriverManager.getDriver() for denodo-vdp-jdbcdriver.jar gives com.denodo.vdb.jdbcdriver.VDBJDBCDriver instead of com.denodo.vdp.jdbc.Driver
answered 22-04-2019 18:30:11 -0400

As part of an application code, I'm trying to get the Driver Classname from the provided JDBC URL. In case of Denodo, for the JDBC URL "jdbc:vdb://localhost:port/dataasset", I'm getting "com.denodo.vdb.jdbcdriver.VDBJDBCDriver" as the Driver Class Name...

Answers: 1

JDBC

Retrieve Cache Mode for a VIEW using JDBC
answered 08-04-2019 06:16:37 -0400

I am tring to retrieve "Cache Mode for a VIEW" (OFF, FULL, PARTIAL), But I didnt find a way to fetch it. I used "DESC VQL VIEW <viewName>", but it require write permission for the view. Please advice me to fetch "Cache Mode associated with a VIEW"

Answers: 2

JDBC

Connection refused on Impala connection with JDBC, kerberos
answered 07-04-2019 23:34:39 -0400

We have Cloudera5.12.2 and we’d like to connect to Impala(impala-2.9.0+cdh5.12.2+0) with JDBC. We use kerberos and we checked that we can kinit with the user we intend to use. We just DL the latest denodo express. Java is version8. We have DL Clouder...

Answers: 6

Kerberos JDBC impala

Slf4j dependency conflict changing to "Insufficient resources to execute operation" when trying to connect Dremio as a JDBC datasource
answered 04-04-2019 07:04:38 -0400

Hi, I'm currently running Denodo Platform v7.0 on Windows. I'm attempting to connect Dremio as a JDBC datasource and running into errors when testing the connection. I have added the Dremio JDBC driver .jar file to a new directory in the {DENODO HOME...

Answers: 3

JDBC JDBC Data Sources

StackOverFlow error in JDBC Vertica Driver
answered 12-03-2019 00:27:32 -0400

I am using sqoop to fetch data from HP Vertica using Vertica's JDBC driver. My Vertica setup has node to node encryption enabled and is on SSL. I have a single mapper that fetches data, and there are more than 300 million rows in the projection. I am e...

Answers: 2

vertica JDBC

Denodo JDBC driver backwards compatible?
answered 31-10-2018 16:10:54 -0400

Is the Denodo JDBC driver provided with the Denodo 7 installation backwards compatible to access a Denodo 6 VDB with it? I found this in the documentation: From Denodo Platform 6.0 and newer versions when a new Denodo Platform update is installed, eve...

Answers: 1

JDBC

How to get files referenced in https://community.denodo.com/kb/view/document/How%20to%20access%20VDP%20from%20SAP%20BusinessObjects?category=Northbound+Connections
answered 09-10-2018 11:26:31 -0400

So we are attempting to create a JDBC connection in SAP's BOBJ to Denodo and are following the instructions in https://community.denodo.com/kb/view/document/How%20to%20access%20VDP%20from%20SAP%20BusinessObjects?category=Northbound+Connections We noti...

Answers: 3

JDBC

Connecting R to Denodo
answered 27-09-2018 23:23:43 -0400

Has anyone successfully connected to Denodo using Rstudio or any of the R tools using JDBC?

Answers: 1

Denodo 7 R JDBC

Cannot connect to JDBC database for Lab
answered 06-09-2018 12:55:21 -0400

I'm going through the Lab: DEN60EDU0105LAB01 - Create ds_call_center data source and import all tables I've installed Denodo AccessDatabaseEngine_X64 Calltracking.mdb is in: C:\Users\ehayes\Desktop\Denodo\DEN60EDU0105LAB01 I've configured th...

Answers: 3

Access JDBC

Cannot Connect to Denodo using JDBC via Mulesoft code
answered 06-09-2018 10:01:02 -0400

Hi All, We are trying to figure out this issue since long but no help. I am trying to connect to Denodo via JDBC from my Mulesoft code (Anypoint Studio) on my desktop but always getting connection timeout. URL: jdbc:vdb://${denodo.host}:${denodo.por...

Answers: 2

Denodo VDB Connection Time out Connection JDBC