Latest Activity

specifying the adapter for a jdbc datasource from VQL (as opposed to: from the admin tool)

When creating a jdbc datasource via VQL with a driver from lib/extensions/jdbc-drivers-external/... it seems that always the generic adapter is selected. However I want to control the adapter. Is that possible via VQL or in any other way programmatical...

JDBC

Why there are different ports assigned for JDBC (9999) and ODBC(9996)?

Generally there will be single port to which an application can connect from both jdbc as well as odbc. Why denodo is providing different ports for both?

PostgreSQL JDBC Denodo 7 ODBC Denodo 8 ODBC Denodo vdp jdbc driver

Connection JDBC Denodo AWS Free Trail to MYSQL Database dosent work

Hi, i am working with the Denodo Free Trail Version on AWS ( access to Web Design Studio ) and with the Denodo Express Version. The Tutorial https://community.denodo.com/tutorials/browse/basics/1install1denodo i start working with is doing good on ...

Denodo_MySQL JDBC tutorial free-trial

Unable to establish connection: Communications link failure The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.

I am trying to do the tutorial for starters. I work with the denodo free trail on aws and using the design studio https://community.denodo.com/tutorials/browse/basics/2fs5jdbc I installed all what i need to. the sql server is running and java, pyth...

JDBC

Executing multiple queries separated by semicolon through python

Hi, Is there any way of executing multiple queries separated by semicolon through jdbc connection via python? Thanks, Aashutosh

jdbc Python

IO Error: Invalid number format for port number

Welcome everyone I'm trying to connect to JDBC, but I'm running into a problem (IO error: Invalid number format for port number) i need help, Thanks

IO Error: Invalid number format for port number JDBC

Getting py4j.protocol.Py4JJavaError: An error occurred while calling o65.jdbc. : java.sql.SQLException: Unsupported type TIMESTAMP_WITH_TIMEZONE

I am making JDBC connection to Denodo database using pyspark. The table that i am connecting to contains "TIMESTAMP_WITH_TIMEZONE" datatype for 2 columns. Since spark provides builtin jdbc connection to a handful of dbs only of which denodo is not a pa...

JDBC Spark Spark-sql connection

JDBC driver not connecting to database

I have downloaded & installed denodo-vdp-jdbcdriver-8.0-update-20210209 in an Windows application to create a connection. I am able to successfully connect to the server but it does not appear to be connecting to the database. Full connection URL...

JDBC driver for Denodo 8 JDBC Denodo vdp jdbc driver

Getting Source Tables and Columns of a Datasource through Query

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

JDBC query Database JDBC DataSource

Cloudera CDP with Impalad 3.4.0 jdbc connector

We are currently using Denodo 7 (future plans to upgrade to 8) and are currently using the Impala 2.3 jdbc connector with Cloudera CDH 6.3. We will be upgrading our current Cloudera environment to Cloudera CDP 7.1.6 with Impala 3.4.0 and was curious if...

cloudera JDBC impala