Q&A BY TAG 'JDBC'

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

Why there are different ports assigned for JDBC (9999) and ODBC(9996)?
answered 05-08-2022 17:18:13 -0400

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?

Answers: 1

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

Connection JDBC Denodo AWS Free Trail to MYSQL Database dosent work
answered 20-06-2022 06:19:24 -0400

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

Answers: 1

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.
answered 15-06-2022 19:01:55 -0400

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

Answers: 1

JDBC

Executing multiple queries separated by semicolon through python
answered 08-06-2022 00:13:05 -0400

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

Answers: 1

jdbc Python

IO Error: Invalid number format for port number
answered 27-04-2022 05:13:33 -0400

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

Answers: 1

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
answered 07-02-2022 07:08:58 -0500

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

Answers: 1

JDBC Spark Spark-sql connection

JDBC driver not connecting to database
answered 27-01-2022 05:58:40 -0500

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

Answers: 1

JDBC driver for Denodo 8 JDBC Denodo vdp jdbc driver

Getting Source Tables and Columns of a Datasource through Query
answered 17-11-2021 01:37:07 -0500

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: 5

JDBC query Database JDBC DataSource

Cloudera CDP with Impalad 3.4.0 jdbc connector
answered 29-10-2021 06:58:18 -0400

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

Answers: 1

cloudera JDBC impala

How to connect to Amazon Athena from Denodo 8.0 using JDBC??
answered 20-10-2021 15:44:20 -0400

Hi, is there any documentation on how to perform when connecting to AWS Athena from Denodo 8.0 using JDBC. I know the ir documentation on how to connect bu with Denodo 7.0. Are the procedures the same? Thankyou

Answers: 1

Denodo 8.0 JDBC Athena