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