Q&A BY TAG 'JDBC'

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

Adding CONTEXT to JDBC Database URI
answered 17-09-2021 09:33:52 -0400

I am trying to add a timeout context to a JDBC connection. JDBC Parameters are referenced in the documentation (https://community.denodo.com/docs/html/browse/6.0/vdp/developer/access_through_jdbc/parameters_of_the_jdbc_connection_url/parameters_of_the_...

Answers: 4

context JDBC

Changing JDBC Connection Password with VQL
answered 17-09-2021 01:49:43 -0400

Hi, I need help constructing the correct VQL to change the password for a JDBC connection within VDP? I believe it is something like: ALTER DATASOURCE JDBC connectionname ENCRYPT_PASSWORD 'thisisthenewpassword';

Answers: 1

vql JDBC Password

How to Create Base View in Denodo to a NEO4J data-source?
answered 14-09-2021 12:18:14 -0400

Hi All, I know that a very similar question was asked before, but my problem is not connecting Denodo with Neo4j, I could connect the tools using the corresponding Driver, placing it in the folder "<DENODO_HOME> \ lib \ extensions \ jdbc-drivers...

Answers: 6

Neo4j Connection Create Base View JDBC

Error saving datasource: SourceTypes (arn, custom, df, gs, itp, jdbc, json, odbc, ws, xml, excel, saperp, sapbw, olap, essbase, sapbwbapi, salesforce) are limited to 0 but 1 are found
answered 08-09-2021 15:03:03 -0400

Hello denodo developers, while creating a jdbc data source I came across this error. I can test the connection successfully but when I want to save it this error pops up. I am using the SOL license.

Answers: 2

Data Source JDBC DENODO EVALUATION LICENSE Connecting to remote databases

Error while calling view from 3rd party application
answered 29-07-2021 19:54:09 -0400

Hello, I have created one view which is exposed to a 3rd party application using JDBC Driver. The 3rd party applcaiton is calling the view using credentials which are a part of AD. In last 24 hours sever times it has thrown an error com.denodo.vdb.v...

Answers: 1

JDBC

Spring throws: "java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver" on Data Source instantiation
answered 26-07-2021 07:10:30 -0400

Hi dears, I imported Denodo JAR using maven and I configured my app to access Denodo views with the following properties and driver class name: spring.datasource.denodo.url: jdbc:vdb://<ip>:<port>/<db> spring.datasource.denodo.usern...

Answers: 1

springdatajpa Driver JDBC

Can't access denod via JDBC
answered 07-07-2021 04:49:15 -0400

denodo-vdp-jdbcdriver.jar (from server) denodo-vdp-jdbcdriver-8.0-ga.jar denodo-vdp-jdbcdriver-8.0-update-20210209.jar denodo server version is <version displayName="8.0" major="8" minor="0"/> my local is jdk 8, python 3.6.8, jayBeBeApi 1.2.3 ...

Answers: 1

JDBC

No suitable driver exception when trying to connect using Jmeter
answered 30-06-2021 07:30:44 -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: 3

Jmeter JDBC AWS SQL

Getting Source Tables and Columns of a Datasource through Query
answered 07-06-2021 14:04:00 -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: 2

JDBC query Database JDBC DataSource

Connecting to SQL Server using Windows Authentication with an SA Account
answered 05-05-2021 17:28:44 -0400

I have credentials for a QA SQL Sever enviroment but it requires Windows Authentication and you have to sign in as the SA account in order to access the DB. Is there a way to force this using the JDBC string? Or - do I need to do some type of authent...

Answers: 1

JDBC SQL Server password authentication