使用wlst.sh创建一般数据源

环境信息：

weblogic

创建连接单机oracle数据库的一般数据源

详细代码说明 ：

#########################################
#  Create General DS  for oracle DB    ##
#########################################

# Basic config 
admin_url = t3://localhost:7001
admin_username = weblogic
admin_password = weblogic
db_username = app
db_password = app
db_url = jdbc:oracle:thin:@localhost:1521/orcl
db_init_capacity = 1
db_max_capacity=50
# datasource_name = testDS3
jndi = jdbc/testDS
target = AdminServer

# connect to serverconfig
connect(admin_username, admin_password, admin_url)
# dsName=datasource_name
# print "dsName: "  + dsName
# jndi= jndi


edit()
cd(/)
startEdit()

# create action
# Manual config datasouce name : arg1
jdbc = create(testDS , JDBCSystemResource)
jdbcResource = jdbc.getJDBCResource()
jdbcResource.setName(testDS)

# config jdbc paras
datasourceParams=jdbcResource.getJDBCDataSourceParams()
datasourceParams.setJNDINames(jndi)

# jdbc driver
driverParams=jdbcResource.getJDBCDriverParams()
driverParams.setPassword(db_password)
driverParams.setDriverName(oracle.jdbc.OracleDriver)
driverParams.setUrl(db_url)
driverConfig=driverParams.getProperties()
driverUser=driverConfig.createProperty(user)
driverUser.setValue(db_username)

# set connection info 
connectionParams=jdbcResource.getJDBCConnectionPoolParams()
connectionParams.setInitialCapacity(int(db_init_capacity))
connectionParams.setMaxCapacity(int(db_max_capacity))
connectionParams.setTestConnectionsOnReserve(true)
connectionParams.setTestTableName(SQL SELECT 1 FROM DUAL)


# set target for datasource 
jdbc.addTarget(getMBean(Servers/+target))

save()
activate(block="true")

disconnect(true)
exit()

执行：

wlst.sh create_datasource.py

参考信息：