Latest Activity

code

Changing JDBC Connection Password with VQL

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';

vql JDBC Password

code

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

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.

Data Source JDBC Connecting to remote databases DENODO EVALUATION LICENSE

code

Error while calling view from 3rd party application

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...

JDBC

code

Spring throws: "java.lang.IllegalStateException: Cannot load driver class: com.denodo.vdp.jdbc.Driver" on Data Source instantiation

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...

springdatajpa JDBC Driver

code

Can't access denod via JDBC

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 ...

JDBC

code

No suitable driver exception when trying to connect using Jmeter

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...

JDBC Jmeter AWS SQL

code

Connecting to SQL Server using Windows Authentication with an SA Account

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...

JDBC SQL Server password authentication

code

PostgreSQL v 13.2 Database connector/JDBC drivers - When?

Hi there, I know it is very early on to be asking this question, but does anyone know by when the JDBC drivers for v13.2 of PostgreSQL will be available, or if they are already available, where to get them? At the moment the highest version in the se...

Denodo 8.0 Connector PostgreSQL JDBC Remote Tables

code

How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?

We want to execute some refresh vql command and get back the response through jdbc connection. Is it possible to obtain the input parameters in the initalize() method like we do in the doCall() And how do we extract and return the response of said vql...

Related to: Executing VQL statements from a stored procedure

Custom stored procedure JDBC

code

Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations

Hello, Am using Spring Boot 2.3.4 and spring-boot-starter-data-jpa in order to connect to denodo 8.0 My application.yml is as follows spring: jpa: open-in-view: false show-sql: true generate-ddl: false hibernate.ddl-auto: none properties: hibernate:...

Denodo 8.0 Access Denodo Express does not support ddl operations JDBC com.denodo.connect.hibernate.dialect.DenodoDialect ddl