Q&A BY TAG 'JDBC'
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
PostgreSQL v 13.2 Database connector/JDBC drivers - When?
answered
30-04-2021 13:30:37 -0400
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...
Answers:
1
How to obtain the input parameters of the custom stored procedure in the overridden initalize() method?
answered
28-04-2021 07:57:50 -0400
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...
Answers:
1
Related to:
Executing VQL statements from a stored procedure
Java SpringBoot application - Could not obtain connection to query metadata : com.denodo.connect.hibernate.dialect.DenodoDialect does not support ddl operations
answered
01-02-2021 07:04:36 -0500
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:...
Answers:
1
Denodo 8.0 Access Denodo Express does not support ddl operations JDBC com.denodo.connect.hibernate.dialect.DenodoDialect ddl
Use a jdbc drive in custom handler.
answered
30-12-2020 17:43:47 -0500
In a custom handler, I am trying to conenct to a SQL Azure database using jdbc to log some schedule job run information (such as a start time). The custom handler failed with the folloiwng error: No suitable driver found for jdbc:sqlserver://{SQL Azur...
Answers:
1
How to connect denodo from airflow
answered
28-12-2020 06:50:53 -0500
I would like to connect to denodo views to read the created views from airflow. Pls advice
Answers:
1
Denodo Data bricks jar error
answered
10-12-2020 00:33:26 -0500
I am trying to load the CDATA driver jar to connect to data bricks cluster from denodo 8, I am following the instructions to load the driver in class path using the following instructions in the below link https://community.denodo.com/docs/html/browse...
Answers:
1
Unable to Query views with individual columns in select query
answered
03-12-2020 06:51:36 -0500
Hi Denodo team, I am trying to query a view with its individual columns in the select query but it is failing to fetch the result and throwing the below error. Finished with error: Error in select view conditions: Field not found 'view_name.column_name...
Answers:
1
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
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