BI Publisher supports connecting to the JDBC data source through a connection pool.
Using a connection pool increases efficiency by maintaining a cache of physical connections that can be reused. When a client closes a connection, the connection gets placed back into the pool so that another client can use it. A connection pool improves performance and scalability by allowing multiple clients to share a small number of physical connections. You set up the connection pool in your application server and access it through Java Naming and Directory Interface (JNDI).
After you set up the connection pool in your application server, enter the required fields in this page so that BI Publisher can use the pool to establish connections. For information on setting up a connection pool in WebLogic Server, see Configuring JDBC Data Sources in Administering JDBC Data Sources for Oracle WebLogic Server.
To set up a database connection using a JNDI connection pool: