Q&A BY TAG 'JDBC'

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

Scheduler DB connection
answered 23-08-2019 02:30:34 -0400

HI, I am trying to get all the jobs history information, so that I can analyze the scheduling times, failures and then reschedule them to minize the failures. Also, to perform other type of analysis. For that, I need to get list of all jobs(with hist...

Answers: 1

Denodo Scheduler 6.0 JDBC

Issue with Qubole Presto JDBC connection from Denodo
answered 12-08-2019 17:33:29 -0400

HI Team, I am trying to establish JDBC connection from Denodo to Qubole Presto cluster but I am getting below error while establishing the connection. I downloaded and copied the QUbole JDBC driver to $DENODO_HOME/<path> where we usually keep ou...

Answers: 2

Presto JDBC Qubole

Denodo JDBC Connection Parameter to set Current Catalog
answered 10-06-2019 07:48:48 -0400

Hi Team, Do we have any JDBC Parameter to set Current Schema/Catalog when null is passed in the API Call? I'm looking for something like CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX- Snowflake https://docs.snowflake.net/manuals/sql-reference/parameters....

Answers: 4

JDBC

Update a JDBC wrapper view
answered 13-05-2019 19:40:50 -0400

I have a JDBC wrapper view created for inserting data into a table. Due to recent business requirement we now need to add one more column to the table .Can you please help us to understand how to update existing view so that we can now insert value for...

Answers: 1

JDBC

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