This document contains documentation for the BI Platform (including the BI Server) version 2.1. Older documentation for version 1.x is here

Document Purpose

The bug reported in BISERVER-2735 resulted in various changes in platform components. Imposing row limits and timeouts on queries is sometimes important to avoid causing out of memory errors or processes that consume too many resources on the database server. The purpose of this document is to document the ways to control row limits, timeouts and the read-only setting in the JDBC connection object.

Affected Platform Areas

Affected Components

New component inputs

The components above now accept up to three new "known" optional inputs.

max_rows

All of the above components look for, and respect the new input max_rows. For SQLBaseComponent, and HQLBaseComponent, when max_rows comes in as an input through the normal