It would be helpful if we have a textbox as part of the connection definition screen that accepts free text to support key value pairs for correct driver/additional configurations.
Note: This is already available as part of the weblogic snowflake-Datasource definitions.
Current connection string Vs Expected connection string to establish connection from OAS DV to snowflake as follows:
Current connection string being used - jdbc:snowflake://XXXX.snowflakecomputing.com/?useProxy=true&proxyHost=XXXX&proxyPort=XXXX&db=XXXXX
Expected connection string- jdbc:snowflake://XXXX.snowflakecomputing.com/?useProxy=true&proxyHost=XXXX&proxyPort=XXXX&client_session_keep_alive=true&jdbc_query_result_format=json&db=XXXXX
================================
Weblogic snowflake datasource parameter declaration:
proxyHost=XXXX
useProxy=true
jdbc_query_result_format=json
client_session_keep_alive=true
database=XXXXX
proxyPort=8000
user=XXXXX
