$JBOSS_HOME/bin/jboss-cli.sh --controller=localhost:19990 --connect --file=/u01/app/redhat/config/domains/dev_domain/configuration/create_datasource.cli --properties=/u01/app/redhat/config/domains/dev_domain/configuration/db-config.properties
contents of create_datasource.cli file:
set jdbcUrl=${jdbcUrl}
set username=${username}
set password=${password}
set driver=${driver}
set module=${module}
set resource=${resource}
set jndiname=${jndiname}
set name=${name}
set resource=${resource}
module add --name=$module --resources=$resource --dependencies=javax.api,javax.transaction.api
/subsystem=datasources/jdbc-driver=$driver:add(driver-name=$driver,driver-module-name=$module)
data-source add --jndi-name=$jndiname --name=$name --connection-url=$jdbcUrl --driver-name=$driver --user-name=$username --password=$password
contents of db_config.properties file:
jdbcUrl=jdbc:oracle:thin:@xxx.example.com:1521:DB11gR2
username=system
password=weblogic1
driver=oracle
module=com.oracle
resource=/media/sf_D_DRIVE/shared-files/JBOSS/ojdbc7.jar
name=OraclePool
jndiname=java:/OracleDS
No comments:
Post a Comment