The parameters for the ODBC driver are under HKEY_LOCAL_MACHINE/SOFTWARE/ODBC/ODBCINST.INI/Rational XML ODBC Driver registry item.
Name of the parameter | Explanation for the parameter | Default value of the parameter |
---|---|---|
LibPath | Path of JDBC driver library files. | |
MaxActiveStatements | Maximum number of active statements (SQL
queries) allowed in the system. When queries more than the specified number are received at the driver, the query request will be queued and the calling thread will be blocked, until there are other statements finish execution or until the waiting timeout. |
20 |
QueuingTimeout | Maximum waiting time (in milliseconds) for which a query request is put in the waiting queue. | 300000 (5 mins) |
DefaultPageSize | Page size when fetching data from the source. This value is passed to the JDBC driver and used for the queries where the page size is not explicitly specified through the "with pagesize=xxx" SQL command in the query. |
1000 |
jdbclogpath | Path of JDBC log files. The path contains the entire directory path including the name of the log file with .txt or .log as suffix. If the value of this parameter is empty, the default values are taken. |
|
Debug | Enable the log of ODBC driver. The value contains the entire directory path, including the name of the log file with .log as suffix, for example, C:/ri_odbc.log. Logging information is written to the file if the driver has read and write permissions to the file. |
Nothing is specified. |