You can translate the question and the replies:

Denodo JDBC Connection Parameter to set Current Catalog

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 or nullCatalogMeansCurrent=true for MySQL ( Please share if there are any JDBC Properties to achive same.
27-05-2019 12:55:27 -0400

4 Answers

Hi, I am able to return details about the sessions opened by clients to the Virtual DataPort server by using the GETSESSION() functions. For your scenario, you can use GETSESSION(<db_name>). For more details, you can refer to [GETSESSION]( section of Virtual DataPort Developer Guide. Hope this Helps!
Denodo Team
28-05-2019 08:26:39 -0400
Thank you for your response. But my requirement is slightly different. I am trying to use getTables(), getColumns() JDBC Calls. When I pass null to Catalog/Schema, I would like to get tables/Columns from the Database Connected and not from all Databases. Currently, I get tables/columns from all Databases in VDP.
28-05-2019 10:42:05 -0400
Any suggestion on this please?
06-06-2019 10:26:04 -0400
Hi, When I had connected to Denodo Platform from an external client, I am able to get a list of views (tables) of a database (created in Denodo Platform) by using “GET_VIEWS()” Predefined Stored Procedure and “GET_VIEW_COLUMNS()” Predefined Stored Procedure to get information about the fields (columns) of the view. For more details, you can refer to [GET_VIEWS]( and [GET_VIEW_COLUMNS]( Predefined Stored Procedure sections of Virtual DataPort Guide. Hope this helps!
Denodo Team
10-06-2019 07:48:48 -0400
You must sign in to add an answer. If you do not have an account, you can register here