Disable Reading Multiple Result Set Attempts

This article describes how to prevent Assure from attempting to read multiple result sets, either in general or for a particular driver. This is achieved through customization to the team's "CONFIG_OVERRIDE" directory ( hosting the "CMF_channels.properties" file )

For reference on utilizing the "CONFIG_OVERRIDE" folder, please refer to the following article :

Using CONFIG_OVERRIDE to modify product configuration

Within the "CMF_channels.properties, the following value should be added to turn this feature off for ALL drivers :

db.ATTEMPT_MULTI_RESULTSET=false

Alternatively, if the team would like to achieve this result for only ONE particular driver, the following value may be utilized :

db.ATTEMPT_MULTI_RESULTSET.<driver_name>=false

Substitute the "<driver_name>" value with the "getDriverName()" definition described below.

As an exercise, run a test within a lower environment where the team will turn on DEBUG logging for a specific category. Example :

com.unitechsys.component.capture.DbChannel

The above category will be an append within iitap ( located in the Assure administrative console, logging subsection ).

Once this is in place, perform a "test layout" against the database that is desired to implement this feature for. An ERROR does not need to be produced, this is just to trigger the driver to log information within the logs. Once complete, the IGX log should tell us what value will need to be in place for the aforementioned "<driver_name>" value within the "CMF_channels.properties" file.

After the test, set the logging category back up to INFO for the "DbChannel" value.

Example IGX log snippet :

2020-11-05 11:44:42,897 DEBUG (WebContainer : 27) [com.unitechsys.component.capture.DbChannel].[establishDatabaseProduct]: Database driver name for configuration = jConnect_(TM)for_JDBC(TM)

Based on the output, we would add the following value to the "CONFIG_OVERRIDE" / "CMF_channels.properties" file :

db.ATTEMPT_MULTI_RESULTSET.jConnect_(TM)for_JDBC(TM)=false