WebLogic Admin Console hanging when trying to make a connection pool setting change

Problem:

I tried to make a few configuration changes to a connection pool setting via the Admin Console. When I tried activating the change, the console would hang and the change would not take effect.

For example, here is the navigation path to the page to make those data source configuration changes:

Home --> Summary of JDBC Data Sources --> SOALocalTxDataSource --> Connection Pool

Solution:

1. Shutdown the Admin Server.

2. Edit the configuration file directly. For example, the config file I wanted is located here:

/u01/app/oracle/middleware/user_projects/domains/soa_domain/config/jdbc/SOALocalTxDataSource-jdbc.xml

3. I added the appropriate configuration I wanted. For example, I added these 2 configuration settings:

<jdbc-connection-pool-params>

  <pinned-to-thread>true</pinned-to-thread>

  <statement-cache-size>50</statement-cache-size>

  .

  .

  .

</jdbc-connection-pool-params>

4. Restart the Admin Server.


Applicable Versions:

• Oracle WebLogic 11g (10.3.4)