Configuracon Datasource Wildfly

• Configuración del archivos standalone.xml
•  acceder a la siguiente direccion /opt/web_cabal/datos/wildfly-ceibo/config y editar el archivo standalone.xml
•  Dentro del tag <datasources> </datasources> agregar  

               <datasource jta="true" jndi-name="java:jboss/datasources/bapyDS" pool-name="bapy" enabled="true" use-ccm="false">
                    <connection-url>jdbc:oracle:thin:@10.5.2.30:1521:BAPY</connection-url>
                    <driver>oracle6</driver>
                    <pool>
                        <min-pool-size>20</min-pool-size>
                        <max-pool-size>100</max-pool-size>
                        <use-strict-min>false</use-strict-min>
                        <flush-strategy>FailingConnectionOnly</flush-strategy>
                    </pool>
                    <security>
                        <user-name>creditopy</user-name>
                        <password>desarrollo</password>
                    </security>
                    <validation>
                        <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                        <use-fast-fail>false</use-fast-fail>
                        <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
                        <!-- <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/> -->
                    </validation>
                    <timeout>
                        <set-tx-query-timeout>true</set-tx-query-timeout>
                        <blocking-timeout-millis>5000</blocking-timeout-millis>
                        <idle-timeout-minutes>5</idle-timeout-minutes>
                    </timeout>
                    <statement>
                        <track-statements>false</track-statements>
                        <prepared-statement-cache-size>0</prepared-statement-cache-size>
                    </statement>
                </datasource>
                <datasource jta="true" jndi-name="java:jboss/datasources/olpyDS" pool-name="olpy" enabled="true" use-ccm="false">
                    <connection-url>jdbc:oracle:thin:@10.5.2.36:1521:OLPY</connection-url>
                    <driver>oracle6</driver>
                    <pool>
                        <min-pool-size>20</min-pool-size>
                        <max-pool-size>100</max-pool-size>
                        <use-strict-min>false</use-strict-min>
                        <flush-strategy>FailingConnectionOnly</flush-strategy>
                    </pool>
                    <security>
                        <user-name>creditopy</user-name>
                        <password>desarrollo</password>
                    </security>
                    <validation>
                        <check-valid-connection-sql>select * from dual</check-valid-connection-sql>
                        <validate-on-match>false</validate-on-match>
                        <background-validation>false</background-validation>
                        <use-fast-fail>false</use-fast-fail>
                         <exception-sorter class-name="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter"/>
                        <!-- <exception-sorter class-name="org.jboss.resource.adapter.jdbc.vendor.OracleExceptionSorter"/> -->
                    </validation>
                    <timeout>
                        <set-tx-query-timeout>true</set-tx-query-timeout>
                        <blocking-timeout-millis>5000</blocking-timeout-millis>
                        <idle-timeout-minutes>5</idle-timeout-minutes>
                    </timeout>
                    <statement>
                        <track-statements>false</track-statements>
                        <prepared-statement-cache-size>0</prepared-statement-cache-size>
                    </statement>
                </datasource>

• Dentro del tag <divers> </divers> agregar

                  <driver name="oracle6" module="com.oracle:oracle6">
                         <driver-class>oracle.jdbc.driver.OracleDriver</driver-class>
                  </driver>

• Dentro del path /opt/web_cabal/datos/wildfly-ceibo/modules/system/layers/base/com/Oracle crear la siguiente carpeta oracle6 y agregar los archivos: (archivos adjuntos)

                    module.xml

                    ojdbc6.jar

oracle6.rar

• Editar el archivo Dockerfile
  1. Comentar las siguientes lineas

       RUN mkdir -p /opt/jboss/wildfly/modules/system/layers/base/com/oracle

       COPY ./modules/system/layers/base/com/oracle /opt/jboss/wildfly/modules/system/layers/base/com/orac

               2. Agregar las siguientes 

       RUN mkdir -p /opt/jboss/wildfly/modules/system/layers/base/com/oracle/main
       RUN mkdir -p /opt/jboss/wildfly/modules/system/layers/base/com/oracle/oracle      

       COPY ./modules/system/layers/base/com/oracle/main/ /opt/jboss/wildfly/modules/system/layers/base/com/oracle/main/ 
       COPY ./modules/system/layers/base/com/oracle/oracle6/ /opt/jboss/wildfly/modules/system/layers/base/com/oracle/oracle6/

• Reiniciar Docker