BI Publisher in OBIEE suite -- Connection pool

Question

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

Gianni Ceresa · Answer

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.

User_SX88B · Answer

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

Gianni Ceresa · Answer

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.