Purpose

Specifies a semicolon separated list of parameters that are used as default filter values (WHERE clauses) for SQL queries. This option is not mandatory. Also, you can specify any combination of these name-value pairs for these filters. The driver uses the defined filters (WHERE clauses) for SQL queries when needed. If a required condition is not present, the driver reports an error as No URI could satisfy the request on the table schema_name.table_name. Supply one of the following sets of criteria filter_name/*.

Valid Values

string

where:

string

is a set of parameters with default values that you want to apply to SQL queries. For example: 
DefaultQueryOptions=(orgName=org_name;userName=user_name;repoName=repo_name;
projectId=project_Id;columnId=column_Id;)
Note: A WHERE clause used in a SQL query overrides the DefaultQueryOptions passed in a connection URL.

Data Source Methods

public String getDefaultQueryOptions()

public void setDefaultQueryOptions(String)

Default Value

No default value

Data Type

String