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 docker-compose.yml
   - en el apartado wildfly-ceibo:   volumenes: agregar
      volumes:
        - ./datos/wildfly-ceibo/modules/system/layers/base/com/oracle:/opt/jboss/wildfly/modules/system/layers/base/com/oracle
        - ./datos/wildfly-ceibo/deployments:/opt/jboss/wildfly/standalone/deployments
        - ./datos/wildfly-ceibo/config/standalone.xml:/opt/jboss/wildfly/standalone/configuration/standalone.xml

• Reiniciar Docker