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 https://docs.snowflake.net/manuals/sql-reference/parameters.html#client-metadata-request-use-connection-ctx or nullCatalogMeansCurrent=true for MySQL (https://dev.mysql.com/doc/relnotes/connector-j/5.1/en/news-3-1-11.html) Please share if there are any JDBC Properties to achive same.
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/appendix/syntax_of_condition_functions/other_functions#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.
user
28-05-2019 10:42:05 -0400
Any suggestion on this please?
user
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](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/get_views) and [GET_VIEW_COLUMNS](https://community.denodo.com/docs/html/browse/7.0/vdp/vql/stored_procedures/predefined_stored_procedures/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