Connection Pooling - Weblogic or ADF ?
882099Dec 22 2011 — edited Dec 22 2011Hi,
I was going through the properties of Application Module in Oracle ADF to find that App Module supports connection pooling as well as instance pooling.
Also when I edit the connection Type of AppModule to "JDBC Datasource" the connection Pooling option is gone.
I assume that this happened because most probably when the connection type is set to "JDBC Datasource" users will create the Data Source at weblogic (App Server level) and give the JNDI reference in AppModule. Now since the data source connection is established at weblogic level adf disables the option of connection pooling because there is no need of it as it will be handled at Weblogic level.
My question is whether my understanding is correct as to why the connection pool option is disabled when we use connection Type as "JDBC Datasource" in AppModule configurations and can we give JNDI reference to appmodules which are configured at Weblogic Level?
and
Should we handle connection pooling at ADF level or at the app server level say Weblogic?
Regards,
Rohit
Edited by: rohit6699 on Dec 22, 2011 1:06 AM