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