This discussion is archived
2 Replies Latest reply: Sep 11, 2013 12:27 PM by 969955 RSS

JDBC Pool Max Capacity not resetting after change - 10.3.5 on RedHat 5.8

969955 Newbie
Currently Being Moderated

Hello:

 

We created an ADF Web Application which is deployed on WebLogic 10.3.5

 

.  After reaching 15 JDBC Connections the application fails with the following error:

 

oracle.jbo.DMLException: JBO-29114 ADFContext is not setup to process messages for this exception. Use the exception stack trace and error code to investigate the root cause of this exception. Root cause error code is JBO-26061.

 

The error code JBO-26061 points to the source of the problem being a limited number of JDBC connections. The default is 15 for Maximum Capacity for JDBC Connections. After increasing the Max Capacity to 60 and restarting WebLogic, our application still fails after 15 connections.  The pdev-jdbc.xml file is showing the correct updates to WebLogic

 

. See below:  But still WebLogic still allows only 15 JDBC connections.

 

Is there anything else that must be done to allow WebLogic to increase the JDBC connections?  What am I missing?

 

Thanks for the help.

 

 

 

 

 

 

<?xml version='1.0' encoding='UTF-8'?>

<jdbc-data-source xmlns="http://xmlns.oracle.com/weblogic/jdbc-data-source" xmlns:sec="http://xmlns.oracle.com/weblogic/security" xmlns:wls="http://xmlns.oracle.com/weblogic/security/wls" xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance" xsi:schemaLocation="http://xmlns.oracle.com/weblogic/jdbc-data-source http://xmlns.oracle.com/weblogic/jdbc-data-source/1.0/jdbc-data-source.xsd">

  <name>pdev</name>

  <jdbc-driver-params>

    <url>jdbc:oracle:thin:@mrdr.labs.xxx.local:1521:mxx3</url>

    <driver-name>oracle.jdbc.xa.client.OracleXADataSource</driver-name>

    <properties>

      <property>

        <name>user</name>

        <value>pt

 

</value>

      </property>

    </properties>

    <password-encrypted>{AES}YFupoK1B5g0at3wfdR

 

qMMfJ7oJrkIr2Zs=</password-encrypted>

  </jdbc-driver-params>

  <jdbc-connection-pool-params>

    <initial-capacity>30</initial-capacity>

    <max-capacity>60</max-capacity>

    <capacity-increment>2</capacity-increment>

    <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>

    <statement-cache-size>10</statement-cache-size>

    <statement-cache-type>LRU</statement-cache-type>

  </jdbc-connection-pool-params>

  <jdbc-data-source-params>

    <jndi-name>jdbc/pdevDS</jndi-name>

    <global-transactions-protocol>TwoPhaseCommit</global-transactions-protocol>

  </jdbc-data-source-params>

</jdbc-data-source>


Legend

  • Correct Answers - 10 points
  • Helpful Answers - 5 points