weblogic连接池重置（Connection reset）问题解决方案(8)

<?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 ">
  <name>GTEM_DS</name>
  <jdbc-driver-params>
    <url>jdbc:oracle:thin:@[URL]:[PORT]:[DB]</url>
    <driver-name>oracle.jdbc.OracleDriver</driver-name>
    <properties>
      <property>
        <name>user</name>
        <value>[USER]</value>
      </property>
    </properties>
    <password-encrypted>[ENCLIPTED VALUE]</password-encrypted>
  </jdbc-driver-params>
  <jdbc-connection-pool-params>
    <test-table-name>SQL SELECT 1 FROM DUAL</test-table-name>
  </jdbc-connection-pool-params>
  <jdbc-data-source-params>
    <jndi-name>GTEM_DS</jndi-name>
    <global-transactions-protocol>OnePhaseCommit</global-transactions-protocol>
  </jdbc-data-source-params>
</jdbc-data-source>

CAUSE

The issue is caused by the database not being able to respond to a large number of connections at the same time and hence throwing a connection reset.

SOLUTION

Please follow these steps to resolve the issue:

      1.From the WLS admin console, select the datasource.

      2.Under the connection pool tab, click on Advanced.

      3.Check the "Enable Test Connections On Reserve" option.

      4.Make "Login Delay" 1.

      5.Make "Connection Creation Retry Frequency" 2.

      6.Save the configuration.