Q&A BY TAG 'JDBC'

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

Oracle Set Role
answered 17-06-2020 02:26:20 -0400

Is there a way to have Denodo set the role for the user connecting to an Oracle database through a Denodo view? e.g. "set role <role_name>"

Answers: 1

Data Source JDBC Access to Oralce

Active connections staying opened
answered 15-05-2020 01:05:04 -0400

I have been observing in my monitoring logs that VDPActiveConn are high and constantly growing. You would expect a connection to be opened, used and closed. Yet in my logs they are staying oepned. I checked via JConsole the connections and 140 were ope...

Answers: 1

ODBC JDBC

How to connect to Denodo VDP using Oracle SQL Developer?
answered 07-05-2020 00:37:41 -0400

Is it possible to connect to Denodo VDP 7.0 using Oracle SQL Developer client using Denodo JDBC Driver?

Answers: 1

JDBC

No suitable driver exception when trying to connect using Jmeter
answered 31-03-2020 07:47:41 -0400

Hi, When I try to establish a connection in Jmeter I am getting the error exception as "Cannot create JDBC driver of class 'com.denodo.vdp.jdbc.driver for connect URL' and "SQL Exception: No suitable driver found". I have followed this document to se...

Answers: 1

Jmeter JDBC AWS SQL

Unable to access Denodo from mulesoft using JDBC driver
answered 16-03-2020 08:29:22 -0400

I'm trying to establish a connection with denodo using JDBC driver to mulesoft which is a maven based application. Mule runtime: 3.8.6 Denodo version: Denodo 7.0 update-20181011 JDBC Jar used: denodo-vdp-jdbcdriver-7.0-update-20181011.jar Maven depend...

Answers: 3

mulesoft driver denodo jdbc

Oracle DB enforce parallelism
answered 31-01-2020 01:53:34 -0500

Hi Team, We are facing issues while fetching data from Oracle DB, which is taking longer time than usual. When checking with DB team, they suggested to use below(with parallel option) while running a select command. I tried to run the same manually an...

Answers: 1

performance parallel JDBC Oracle DB connection Issue

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