Q&A BY TAG 'JDBC'

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

Getting Source Tables and Columns of a Datasource through Query
answered 14-10-2020 06:23:36 -0400

Hi Denodo team, Are there any queries to get all the tables in the datasource and also columns in a datasource for a specified table. I have seen that GET_SOURCE_TABLE() procedure is giving table but it takes view name as a parameter,but I don't want t...

Answers: 1

JDBC query Database JDBC DataSource

Connecting to SSL Enabled Denodo Using NodeJS and JDBC
answered 22-09-2020 08:25:15 -0400

I am trying to connect to Denodo to obtain access to a view using a web app created from Node JS and the jdbc library. I was able to figure out how to successfully connect to a non SSL version of Denodo but I would like to know how to do it for an SSL ...

Answers: 4

Connectivity JDBC nodejs SSL

db2 jdbc connection errors
answered 21-09-2020 07:34:33 -0400

I verified we are using java 1.8 on a denodo 7.0 installation. I have downlaoded v10.5fp11_linuxx64_dsdriver from ibm and loaded onto the vdp server drivers directory. I can now connect to my db2/udb luw instance. I can create a view just fine. but exe...

Answers: 1
Related to: Java versions supported by the Denodo Platform

DB2 10 JDBC jdbc

connect denodo from java program
answered 20-07-2020 09:26:32 -0400

Hi,Iam trying to connect denodofrom java program , I installed the denodo jdbc jar file and put it at my java prgoram and it works well , but when I tried to run the java program from terminal by generate jar file and run it , it failed to load vdp jdb...

Answers: 1

DENODO 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

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 jdbc denodo

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