connect("weblogic","welcome1")
edit()

serviceName="demoatp_tp"
user="admin"
password="mypassword"
dsname="myJDBCDataSource"
server="myserver"
tns_admin="/tmp/demoatp"
# Either use the self-opening wallet
wallet_location="/tmp/demoatp"
# or use the trustStore/keyStore, but not both
trustStore="/tmp/demoatp/truststore.jks"
trustStorePassword="mykeystorepassword"
keyStore="/tmp/demoatp/keystore.jks"
keyStorePassword="mykeystorepassword"

cd("Servers/"+server)
target=cmo
cd("../..")

startEdit()
jdbcSR = create(dsname,"JDBCSystemResource")
theJDBCResource = jdbcSR.getJDBCResource()
theJDBCResource.setName(dsname)

connectionPoolParams = theJDBCResource.getJDBCConnectionPoolParams()
connectionPoolParams.setConnectionReserveTimeoutSeconds(25)
connectionPoolParams.setMaxCapacity(100)
connectionPoolParams.setTestTableName("SQL ISVALID")

dsParams = theJDBCResource.getJDBCDataSourceParams()
dsParams.addJNDIName("jndi."+dsname)

driverParams = theJDBCResource.getJDBCDriverParams()
driverParams.setUrl("jdbc:oracle:thin:@"+serviceName)
driverParams.setDriverName("oracle.jdbc.OracleDriver")

driverParams.setPassword(password)
driverProperties = driverParams.getProperties()

proper = driverProperties.createProperty("user")
proper.setValue(user)
proper = driverProperties.createProperty("oracle.jdbc.fanEnabled")
proper.setValue("false")
proper = driverProperties.createProperty("oracle.net.ssl_server_dn_match")
proper.setValue("true")
proper = driverProperties.createProperty("oracle.net.tns_admin")
proper.setValue(tns_admin)
proper = driverProperties.createProperty("oracle.net.ssl_version")
proper.setValue("1.2")
# Use either the self-opening wallet
proper = driverProperties.createProperty("oracle.net.wallet_location")
proper.setValue(wallet_location)
# or uncomment and use the keyStore/trustStore, but not both
#proper = driverProperties.createProperty("javax.net.ssl.keyStoreType")
#proper.setValue("JKS")
#proper = driverProperties.createProperty("javax.net.ssl.trustStoreType")
#proper.setValue("JKS")
#proper = driverProperties.createProperty("javax.net.ssl.trustStore")
#proper.setValue(trustStore)
#proper = driverProperties.createProperty("javax.net.ssl.trustStorePassword")
#proper.setEncryptedValue(trustStorePassword)
#proper = driverProperties.createProperty("javax.net.ssl.keyStore")
#proper.setValue(keyStore)
#proper = driverProperties.createProperty("javax.net.ssl.keyStorePassword")
#proper.setEncryptedValue(keyStorePassword)

jdbcSR.addTarget(target)

save()
activate(block="true")