Discourse SQL Driver Attributes |
The SQL driver for Discourse has many attributes that can be finetuned to improve handling in scenarios with unreliable network connections to the API server of Discourse or high volumes of data. Also, many drivers have driver-specific attributes to finetune actual behaviour or handle data not matching specifications.
The Discourse driver attributes are assigned a default value which seldom requires change. However, changes can be applied when needed on four levels, which are reflected in the table below by separate checkmarks:
•Connection string: the connection string from the settings*.xml file and applied during log on.
•Set SQL statement: a set SQL-statement to be executed once connection has been established.
•Log on: value to be specified interactively by user during log on in a user interface.
itgen_doc_expl078_dot The reference manuals contain instructions how to relocate the settings*.xml files. Settings*.xml files are typically located in the </text><text styleclass="Code Example In Regel" translate="true">%USERPROFILE%\invantive</text><text styleclass="Normal" translate="true"> folder in most deployment scenarios. The reference manuals contain instructions how to relocate the settings*.xml files. Each data container of a database in the connection string can have a </text><text styleclass="Code Example In Regel" translate="true">connectionString</text><text styleclass="Normal" translate="true"> element specifying the name and values of attributes. Both name and value must be properly escaped according to XML-semantics. Actual application of the value is solely done during log on. A new connection must be established to change the value of a driver attribute using a connection string.
The set SQL statement can be executed after log on. The syntax is: </text><text styleclass="Code Example In Regel" translate="true">set NAME VALUE</text><text styleclass="Normal" translate="true">, or for a distributed database: </text><text styleclass="Code Example In Regel" translate="true">set NAME@ALIAS VALUE</text><text styleclass="Normal" translate="true">. In some scenarios you may need to enclose the driver attribute name in square brackets to escape it from parsing, for instance when a reserved SQL keyword is part of the name. The new value takes effect straight after execution of the set-statement. The set-statement can be executed as often as needed during a session.
Driver attributes that can be interactively set to a value are typically presented in the log on window. Depending on the platform and design decisions of the user interface designer, some or all of the available driver attributes can have been made available.
The Discourse driver can be configured using the following attributes:
itgen_doc_code |
itgen_doc_description |
itgen_doc_origin |
itgen_doc_default_value |
itgen_doc_set_connection_string |
itgen_doc_set_set_sql |
itgen_doc_set_drivers |
itgen_doc_set_log_on |
---|
20-12-2022 08:27 Version 22.1.101-BETA+3681