get_DS.sh

 


###
### get_DataSource.sh
###
###
### Calls get_DS.jacl
###
### Generates JACL source code for configuring JDBC Provider
###
### Take the output and plug it into get_DS.jacl
###
### Usage:
###    get_DataSource.sh cellname nodename servername
###

USAGE=" 
Usage: $0 -u username -p password -c cell -n node -s server 
"


while getopts "u:p::c:n:s:l" opt; do
  case $opt in
    u ) xuser=$OPTARG ;;
    p ) xpasswd=$OPTARG ;;
    c ) xcell=$OPTARG ;;
    n ) xnode=$OPTARG ;;
    s ) xserver=$OPTARG ;;
    * ) echo $USAGE
         exit 1 ;;
  esac
done


if [ "$xserver" = "" ]
then
    echo $USAGE
    exit 1
fi

if [ "$xuser" = "" ]
then
    echo $USAGE
    exit 1
fi

if [ "$xpasswd" = "" ]
then
    echo $USAGE
    exit 1
fi

if [ "$xcell" = "" ]
then
    echo $USAGE
    exit 1
fi

if [ "$xnode" = "" ]
then
    echo $USAGE
    exit 1
fi


echo "###   "
echo "### set_DataSources.jacl   "
echo "###   "
echo "###   "
echo "###   "
echo "###   "
echo "###   "
echo "   "
echo "proc set_DataSource {cname nname sname} {   "
echo "   "
echo "   "
echo "###   "
echo "### set up globals   "
echo "###   "
echo "   "
echo "global AdminConfig   "
echo "global AdminControl   "
echo "global AdminApp   "
echo "   "
echo "set JDBCProviders [\$AdminConfig getid /Cell:\$cname/Node:\$nname/Server:\$sname/JDBCProvider:/]   "
echo " "
echo "if {[llength \$JDBCProviders] == 0} {   "
echo "    puts \"No JDBC Providers...returning \"   "
echo "    return    "
echo "}   "
echo " "
echo " foreach JDBCProvider \$JDBCProviders {"


wsadmin.sh -username $xuser -password $xpasswd -f get_DS.jacl $xcell $xnode $xserver   | \
grep -v WASX7209I   | \
sed "s,}$,} \\\\,"  | \
sed "s,{},\"\","   | \
grep -v "^{provider"  | \
grep -v "^{relationalResourceAdapter "  

#sed "s/{description/\\
#{description/g" tmp.out  | \
#sed "/^$/d"  | \
#grep -v "^{description" | \
#sed "s,{$,{ \\\\,g" 
#sed "/^\$AdminConfig create DataSource \$JDBCProvider { {classpath/,/^{xa true} }/d"  




echo "}   "



echo "   "
echo "\$AdminConfig save   "
echo "   "
echo "}   "
echo "   "
echo "   "
echo "   "
echo "###   "
echo "### Main   "
echo "###   "
echo "   "
echo "   "
echo "if { !(\$argc == 3) } {   "
echo "   puts \"\"   "
echo "   puts \"Usage:  \"   "
echo "   puts \" \"   "
echo "   puts \"wsadmin.sh -username system -password password -f set_DataSources.jacl cellname nodename servername\" "
echo "   puts \"\"   "
echo "   puts \"For example:  \"   "
echo "   puts \" \"   "
echo "   puts \"wsadmin.sh -username was -password acme@ -f  set_DataSources.jacl hostnameNetwork hostname ops_1_1\" "
echo "} else {    "
echo "   set xcell        [lindex \$argv 0]     "
echo "   set xnode        [lindex \$argv 1]     "
echo "   set xserver      [lindex \$argv 2]     "
echo "   set_DataSource \$xcell \$xnode \$xserver    "
echo "}   "