Use BIRT Report Designer to configure reports to use connection pooling. The BIRT JDBC data source wizard requires configuring a direct-access connection as well as the JNDI URL. The reason for this requirement is that some JNDI service providers do not support client-side access. During design time, such JDBC drivers use the direct-access JDBC connection. The JDBC data-set query builder uses the direct JDBC connection to obtain its metadata.

In BIRT Report Designer, only the design functions directly related to a data-source design, such as Test Connection and Preview Results of a data set, attempt to use a JNDI name path. If the JNDI connection fails for any reason, the data source reverts to using the JDBC driver direct-access URL.

Similarly, at report run time, such as during report preview, the JDBC run-time driver attempts to look up its JNDI data source name service to get a pooled JDBC connection. If such look-up is not successful for any reason, the JDBC driver uses the direct-access URL to create a JDBC connection.