Oracle Analytics Forum

Home› Oracle Analytics and AI› Oracle Analytics and AI Forums› Oracle Analytics Forums› Oracle Analytics Forum

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

BI Publisher in OBIEE suite -- Connection pool

Received Response
1
Views
3
Comments
User_SX88B
User_SX88B Rank 3 - Community Apprentice
edited Aug 13, 2024 6:13PM in Oracle Analytics Forum

Hi Gurus

i have couple question when we install BI Publisher along with OBIEE 11g,

question 1 : OBIEE analysis and Dashboards use RPD connection pool but what connection pool does BIP use when we create new JDBC datasource in BI Administrator?

question 2: in RPD Connection pool we enter the maximum connections, timeout and other details, so when we create a JDBC data sources for BIP reports how are the maximum connections, timeout and runaway sessions handled?

jesi

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    answer 1: no connection pool .... If you create a connection in the Publisher admin page it doesn't use any connection pool but connect by JDBC based on the provided info

    answer 2: look at answer 1, there is no connection at all between Publisher JDBC sources and RPD connection pools.

  • User_SX88B
    User_SX88B Rank 3 - Community Apprentice

    so there is no place in BIP to handle maximum connections, runaway sessions and timeouts?

  • Gianni Ceresa
    Gianni Ceresa Mod

    Not sure publisher has the same logic as a connection pool (sharing the connection between the various users), so wouldn't be surprised if Publisher open a new connection every time it needs one and close it when the data are retrieved.

    And there are some server settings so there probably are some settings that can be set for that.