#!/usr/bin/env bash

echo "change keycloak datasource"

JBOSS_HOME=$HOME/tools/rh-sso-7.2

CUR_DIR=$(dirname $0)

DRIVER_CLASS="oracle.jdbc.xa.client.OracleXADataSource"
DB_URL="jdbc:oracle:thin:@localhost:1521:XE"
DB_USERNAME="system"
DB_PASSWORD="oracle"


#module add --name=com.oracle --resources=/extensions/ojdbc7.jar --dependencies=javax.api,javax.resource.api

$JBOSS_HOME/bin/jboss-cli.sh <<EOF


embed-server --server-config=standalone.xml




/subsystem=datasources/jdbc-driver=oracle:add(driver-name=oracle,jdbc-compliant=true,driver-xa-datasource-class-name="$DRIVER_CLASS",driver-module-name="com.oracle")

echo "modify  datasources/KeycloakDS"

/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=driver-name,value="oracle")
/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=connection-url,value="$DB_URL")
/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=user-name,value="$DB_USERNAME")
/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=password,value="$DB_PASSWORD")
/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=statistics-enabled,value=true)

echo "set validate-on-match to true"

/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=validate-on-match,value=true)


echo "add valid-connection-checker-class-name"
/subsystem=datasources/data-source=KeycloakDS:write-attribute(name="valid-connection-checker-class-name" , value="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleValidConnectionChecker")

echo "add exception-sorter-class-name"

/subsystem=datasources/data-source=KeycloakDS:write-attribute(name="exception-sorter-class-name",value="org.jboss.jca.adapters.jdbc.extensions.oracle.OracleExceptionSorter")

echo "add stale-connection-checker class name "

/subsystem=datasources/data-source=KeycloakDS:write-attribute(name=stale-connection-checker-class-name,value=org.jboss.jca.adapters.jdbc.extensions.oracle.OracleStaleConnectionChecker)

EOF