c="curl -v --user weblogic:welcome1 -H X-Requested-By:MyClient -H Accept:application/json -H Content-Type:application/json" localhost=localhost editurl="http://${localhost}:7001/management/weblogic/latest/edit" serviceName="demoatp_tp" user="admin" password="mypassword" dsname="myJDBCDataSource" server="myserver" tns_admin="/tmp/demoatp" # Either use the self-opening wallet wallet_location="$tns_admin" # or use the trustStore/keyStore, but not both trustStore="$tns_admin/truststore.jks" trustStorePassword="mykeystorepassword" keyStore="$tns_admin/keystore.jks" keyStorePassword="mykeystorepassword" $c -d "{}" \ -X POST "${editurl}/changeManager/startEdit" $c -d "{ 'name': '${dsname}', 'targets': [ { identity: [ 'servers', '${server}' ] } ], }" \ -X POST "${editurl}/JDBCSystemResources?saveChanges=false" $c -d "{ 'name': '${dsname}', 'datasourceType': 'GENERIC', }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource" $c -d "{ 'JNDINames': [ 'jndi.${dsname}' ] }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDataSourceParams" $c -d "{ 'password': '${password}', 'driverName': 'oracle.jdbc.OracleDriver', 'url': 'jdbc:oracle:thin:@${serviceName}', }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams" $c -d "{ name: 'user', value: '${user}' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" $c -d "{ name: 'oracle.jdbc.fanEnabled', value: 'false' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" $c -d "{ name: 'oracle.net.ssl_server_dn_match', value: 'true' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" $c -d "{ name: 'oracle.net.tns_admin', value: '${tns_admin}' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" $c -d "{ name: 'oracle.net.ssl_version', value: '1.2' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # Use either the self-opening wallet $c -d "{ name: 'oracle.net.wallet_location', value: '${wallet_location}' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # or uncomment and use the keyStore/trustStore, but not both #$c -d "{ # name: 'javax.net.ssl.keyStoreType', # value: 'JKS' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # #$c -d "{ # name: 'javax.net.ssl.trustStoreType', # value: 'JKS' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # #$c -d "{ # name: 'javax.net.ssl.trustStore', # value: '${trustStore}' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # ## encrypted password requires special processing in REST #$c -d "{ # name: 'javax.net.ssl.trustStorePassword', # value: 'throwAwayValue' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" #$c -d "{ # name: 'javax.net.ssl.trustStorePassword', # encryptedValue: '${trustStorePassword}', # value: null #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties/javax.net.ssl.trustStorePassword" # #$c -d "{ # name: 'javax.net.ssl.keyStore', # value: '${keyStore}' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" # ## encrypted password requires special processing in REST #$c -d "{ # name: 'javax.net.ssl.keyStorePassword', # value: 'throwAwayValue' #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties/javax.net.ssl.keyStorePassword" #$c -d "{ # name: 'javax.net.ssl.keyStorePassword', # encryptedValue: '${keyStorePassword}', # value: null #}" \ #-X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCDriverParams/properties/properties" $c -d "{ 'testTableName': 'SQL ISVALID' }" \ -X POST "${editurl}/JDBCSystemResources/${dsname}/JDBCResource/JDBCConnectionPoolParams" $c -d "{}" \ -X POST "${editurl}/changeManager/activate"