Q&A BY TAG 'JDBC'
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
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
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
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
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
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
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
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
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
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