Q&A BY TAG 'JDBC'

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

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

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

Denodo 8.0 Connector PostgreSQL JDBC Remote Tables

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

Custom stored procedure JDBC

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

handler Job scheduler JDBC

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 JDBC Python

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

denodo8 databricks JDBC CDATA

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

JDBC query JDBC SQL

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

JDBC Connectivity nodejs SSL