add oracle datasource
# remove adminaudit_ds Data Source
if (outcome == success) of /subsystem=datasources/data-source=${ds_name}:read-resource
data-source disable --name=${ds_name}
data-source remove --name=${ds_name}
end-if
# Add Oracle DS ${ds_name}
data-source add \
--name=${ds_name} \
--jndi-name=${ds_jndi_name} \
--driver-name=oracle \
--driver-class=oracle.jdbc.OracleDriver \
--connection-url="${ds_connection_url}" \
--user-name=${ds_username} \
--password=${${ds_vault_block}} \
--transaction-isolation=TRANSACTION_READ_COMMITTED \
--pool-prefill=true \
--min-pool-size=${ds_min_pool} \
--max-pool-size=${ds_max_pool} \
--check-valid-connection-sql=select\ 1\ from\ dual \
--background-validation=true \
--background-validation-millis=15000 \
--validate-on-match=false \
--use-ccm=true \
--valid-connection-checker-class-name=org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker \
--stale-connection-checker-class-name=org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker \
--exception-sorter-class-name=org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter \
--enabled=${ds_enabled}
reload