Paramétrer un pool jdbc AS400 avec Weblogic 10.3.x

Avant tout il faut télécharger le package gratuit JTOPEN sur jtopen.org
puis extraire les fichiers et rajouter dans votre post_classpath de weblogic le fichier jt400.jar.

Ensuite depuis la console weblogic, il faut configurer un pool en cliquant sur services puis datasource et positionner les paramètres comme suit:

Ce qui correspond au fichier XML présent dans votre domaine Weblogic dans ce répertoire:

D:\productORACLE\v11.2\user_projects\domains\base_domain1\config\jdbc\AS400-3026-jdbc.xml


<?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>AS400</name>
<jdbc-driver-params>
<url>jdbc:as400://HAL.fr.oracle.com;naming=sql;errors=full</url>
<driver-name>com.ibm.as400.access.AS400JDBCDriver</driver-name>
<properties>
<property>
<name>user</name>
<value>sunopsis</value>
</property>
<property>
<name>password</name>
<value>sunopsis</value>
</property>
</properties>
<password-encrypted>{AES}AN7AQZmu8bnbmwhDE16DjLGg186BJNc5ZyaNncMyT10=</password-encrypted>
</jdbc-driver-params>
<jdbc-connection-pool-params>
<initial-capacity>1</initial-capacity>
<max-capacity>15</max-capacity>
<capacity-increment>1</capacity-increment>
<shrink-frequency-seconds>900</shrink-frequency-seconds>
<highest-num-waiters>2147483647</highest-num-waiters>
<connection-creation-retry-frequency-seconds>0</connection-creation-retry-frequency-seconds>
<connection-reserve-timeout-seconds>10</connection-reserve-timeout-seconds>
<test-frequency-seconds>120</test-frequency-seconds>
<test-connections-on-reserve>false</test-connections-on-reserve>
<ignore-in-use-connections-enabled>true</ignore-in-use-connections-enabled>
<inactive-connection-timeout-seconds>0</inactive-connection-timeout-seconds>
<test-table-name>sbraun.RAOCL</test-table-name>
<login-delay-seconds>0</login-delay-seconds>
<statement-cache-size>10</statement-cache-size>
<statement-cache-type>LRU</statement-cache-type>
<remove-infected-connections>true</remove-infected-connections>
<seconds-to-trust-an-idle-pool-connection>10</seconds-to-trust-an-idle-pool-connection>
<statement-timeout>-1</statement-timeout>
<pinned-to-thread>false</pinned-to-thread>
</jdbc-connection-pool-params>
<jdbc-data-source-params>
<jndi-name>jdbc/AS400</jndi-name>
<row-prefetch>false</row-prefetch>
<stream-chunk-size>256</stream-chunk-size>
<global-transactions-protocol>None</global-transactions-protocol>
</jdbc-data-source-params>
</jdbc-data-source>