Skip to content

Instantly share code, notes, and snippets.

@pehunka
Last active December 12, 2019 09:22
Show Gist options
  • Save pehunka/5d0eb97b23168a65bdb7 to your computer and use it in GitHub Desktop.
Save pehunka/5d0eb97b23168a65bdb7 to your computer and use it in GitHub Desktop.
Wildfly 8.x #oracle #jdbc
## Register driver
ARCHIVE_NAME=ojdbc6.jar
REPOSITORY_DIR=pathToDriver
SERVER_DIR=pathToWildfly
INSTALL_DIR=$SERVER_DIR/modules/system/layers/base/com/oracle/ojdbc6/main
SERVER_USER=petr
SERVER_PASSW=petr
mkdir -p $INSTALL_DIR
cp $REPOSITORY_DIR/$ARCHIVE_NAME $INSTALL_DIR
sudo $SERVER_CLI --connect --user=$SERVER_USER --password=$SERVER_PASSW --command="module add --name=com.oracle.ojdbc6 --resources=$REPOSITORY_DIR/ojdbc6.jar --dependencies=javax.api,javax.transaction.api"
sudo $SERVER_CLI --connect --user=$SERVER_USER --password=$SERVER_PASSW --command="/subsystem=datasources/jdbc-driver=ojdbc6:add(driver-name=ojdbc6,driver-module-name=com.oracle.ojdbc6)"
## Create new DataSource
DS_NAME=myDS
DS_JNDI=java:jboss/datasources/$DS_NAME
DB_NAME=myDB
DB_URL="jdbc:oracle:thin:@127.0.0.1:1521:xe"
sudo $SERVER_CLI --connect --user=$SERVER_USER --password=$SERVER_PASSW --command="/subsystem=datasources/data-source=$DS_NAME:add(jndi-name=$DS_JNDI,driver-name=ojdbc6,connection-url=$DB_URL,user-name=$DB_USER,password=$DB_PASSW)"
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment