Q&A BY TAG 'JDBC'
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
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
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
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
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 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
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
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
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
Simba connection error in : uncategorized Column Type
answered
15-10-2021 06:38:06 -0400
Hi, I am trying to fetch the data from a table on Azure Databricks (ADLS). Tables are delta tables. I am using Simba driver on Denodo and the connection is successful as suggested in denodo documentation. After successful connection. I try to do "Creat...
Answers:
1