Q&A BY TAG 'JDBC'

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

Python JDBC access to Denodo
answered 20-11-2019 06:50:00 -0500

Hi, I have been trying connect our Denodo Server via python, I have been trying from windows and now from MacOs Mojave. I have read other JAYDEBE API posts, which basically Denodo Support team didn't/couldn't help. My code is below user = #### pasw ...

Answers: 1

JDBC Python

Denodo driver does not support datasource pooling
answered 16-10-2019 08:24:44 -0400

I am trying to connect to Denodo server using VDB JDBC driver. I want to access it through a WebSphere Application Server Application where I am trying to set a Pooled data source with following config: Implementation class: com.denodo.vdb.jdbcdriver....

Answers: 3

Driver JDBC

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