Q&A BY TAG 'JDBC'
Python JDBC access to Denodo
answered
20-11-2019 06:50:00 -0500
Hi, I have been trying connect our Denodo Server via python, I have been trying from windows and now from MacOs Mojave. I have read other JAYDEBE API posts, which basically Denodo Support team didn't/couldn't help. My code is below user = #### pasw ...
Answers:
1
Denodo driver does not support datasource pooling
answered
16-10-2019 08:24:44 -0400
I am trying to connect to Denodo server using VDB JDBC driver. I want to access it through a WebSphere Application Server Application where I am trying to set a Pooled data source with following config: Implementation class: com.denodo.vdb.jdbcdriver....
Answers:
3
Scheduler DB connection
answered
23-08-2019 02:30:34 -0400
HI, I am trying to get all the jobs history information, so that I can analyze the scheduling times, failures and then reschedule them to minize the failures. Also, to perform other type of analysis. For that, I need to get list of all jobs(with hist...
Answers:
1
Issue with Qubole Presto JDBC connection from Denodo
answered
12-08-2019 17:33:29 -0400
HI Team, I am trying to establish JDBC connection from Denodo to Qubole Presto cluster but I am getting below error while establishing the connection. I downloaded and copied the QUbole JDBC driver to $DENODO_HOME/<path> where we usually keep ou...
Answers:
2
Denodo JDBC Connection Parameter to set Current Catalog
answered
10-06-2019 07:48:48 -0400
Hi Team, Do we have any JDBC Parameter to set Current Schema/Catalog when null is passed in the API Call? I'm looking for something like CLIENT_METADATA_REQUEST_USE_CONNECTION_CTX- Snowflake https://docs.snowflake.net/manuals/sql-reference/parameters....
Answers:
4
Update a JDBC wrapper view
answered
13-05-2019 19:40:50 -0400
I have a JDBC wrapper view created for inserting data into a table. Due to recent business requirement we now need to add one more column to the table .Can you please help us to understand how to update existing view so that we can now insert value for...
Answers:
1
DriverManager.getDriver() for denodo-vdp-jdbcdriver.jar gives com.denodo.vdb.jdbcdriver.VDBJDBCDriver instead of com.denodo.vdp.jdbc.Driver
answered
22-04-2019 18:30:11 -0400
As part of an application code, I'm trying to get the Driver Classname from the provided JDBC URL. In case of Denodo, for the JDBC URL "jdbc:vdb://localhost:port/dataasset", I'm getting "com.denodo.vdb.jdbcdriver.VDBJDBCDriver" as the Driver Class Name...
Answers:
1
Retrieve Cache Mode for a VIEW using JDBC
answered
08-04-2019 06:16:37 -0400
I am tring to retrieve "Cache Mode for a VIEW" (OFF, FULL, PARTIAL), But I didnt find a way to fetch it. I used "DESC VQL VIEW <viewName>", but it require write permission for the view. Please advice me to fetch "Cache Mode associated with a VIEW"
Answers:
2
Connection refused on Impala connection with JDBC, kerberos
answered
07-04-2019 23:34:39 -0400
We have Cloudera5.12.2 and we’d like to connect to Impala(impala-2.9.0+cdh5.12.2+0) with JDBC. We use kerberos and we checked that we can kinit with the user we intend to use. We just DL the latest denodo express. Java is version8. We have DL Clouder...
Answers:
6
Slf4j dependency conflict changing to "Insufficient resources to execute operation" when trying to connect Dremio as a JDBC datasource
answered
04-04-2019 07:04:38 -0400
Hi, I'm currently running Denodo Platform v7.0 on Windows. I'm attempting to connect Dremio as a JDBC datasource and running into errors when testing the connection. I have added the Dremio JDBC driver .jar file to a new directory in the {DENODO HOME...
Answers:
3