Wednesday, May 20, 2009

JDBC connection pooling ADF BC / Apache Tomcat

* Environment: Apache Tomcat 5.5.23
* ADF / BC 10.1.3.3

Issue:

A web-application *.war file is deployed twice into tomcat container. Every app has its own context-root and JDBC connections for the application modules set. Deployment is successful. But either if you run app1 or app2 as first application, the second application catches the JDBC connection of the the first application.

Solution:

Define the following property in $CATALINA_HOME/conf/catalina.properties

jbo.server.in_oc4j = true

This should cause ADF to partition the caches in Tomcat environment based on ContextClassLoader. Now every app uses its own specified connection and cache.

0 comments: