weblogic配置Oracle数据源
1、编写脚本和配置文件
创建配置文件server.properties
domain.name=7001_Domain
admin.url=t3://localhost:7001
admin.userName=weblogic
admin.password=weblogicPassword
datasource.name=jdbc/DS_Name
datasource.database.name=demo
datasource.targets_server=AdminServer
datasource.targets_cluster=cluster_server_1,cluster_server_2
datasource.filename=jdbc_DS_Name.xml
datasource.jndiname=DS_Name
datasource.driver.class=oracle.jdbc.OracleDriver
datasource.url=jdbc:oracle:thin:@192.168.1.1:1521/DB_NAME
datasource.username=DB_Username
datasource.password=DB_Password
datasource.test.query=SQL SELECT * FROM DUAL
创建python脚本createDataSource.py
from java.io import FileInputStream
propInputStream = FileInputStream("server.properties")
configProps = Properties()
configProps.load(propInputStream)
domainName=configProps.get("domain.name")
adminURL=configProps.get("admin.url")
adminUserName=configProps.get("admin.userName")
adminPassword=configProps.get("admin.password")
dsName=configProps.get("datasource.name")
dsFileName=configProps.get("datasource.filename")
dsDatabaseName=configProps.get("datasource.database.name")
dsJNDIName=configProps.get("datasource.jndiname")
dsDriverName=configProps.get("datasource.driver.class")
dsURL=configProps.get("datasource.url")
dsUserName=configProps.get("datasource.username")
dsPassword=configProps.get("datasource.password")
dsTestQuery=configProps.get("datasource.test.query")
try:
connect(adminUserName, adminPassword, adminURL)
edit()
startEdit()
cd('/')
cmo.createJDBCSystemResource(dsName)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName)
cmo.setName(dsName)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName )
set('JNDINames',jarray.array([String(dsName)], String))
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName )
cmo.setUrl(dsURL)
cmo.setDriverName( dsDriverName )
cmo.setPassword(dsPassword)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCConnectionPoolParams/' + dsName )
cmo.setTestTableName(dsTestQuery)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )
cmo.createProperty('user')
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/user')
cmo.setValue(dsUserName)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName )
cmo.createProperty('databaseName')
#cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDriverParams/' + dsName + '/Properties/' + dsName + '/Properties/databaseName')
#cmo.setValue(dsDatabaseName)
cd('/JDBCSystemResources/' + dsName + '/JDBCResource/' + dsName + '/JDBCDataSourceParams/' + dsName )
cmo.setGlobalTransactionsProtocol('OnePhaseCommit')
cd('/SystemResources/' + dsName )
targets=PyList()
datasource_targets_server=configProps.get("datasource.targets_server").split(",")
datasource_targets_cluster=configProps.get("datasource.targets_cluster").split(",")
for datasourceTarget in datasource_targets_server:
targetStr='com.bea:Name='+datasourceTarget+',Type=Server'
targets.append(ObjectName(targetStr))
for datasourceTarget in datasource_targets_cluster:
targetStr='com.bea:Name='+datasourceTarget+',Type=Cluster'
targets.append(ObjectName(targetStr))
set('Targets',jarray.array(targets,ObjectName))
save()
activate()
except Exception, e:
print 'ERROR:'
print e
print 'Operation was canceled.'
undo('true','y')
cancelEdit('y')
exit()
2、运行weblogic环境脚本
运行weblogic中的setWLSEnv.sh来设置CLASSPATH和PATH环境变量
$ . $WEBLOGIC_BASE/wlserver/server/bin/setWLSEnv.sh
3、运行脚本使weblogic配置Oracle数据源
$ java weblogic.WLST createDataSource.py
weblogic部署lib和war应用
1、运行weblogic环境脚本
运行weblogic中的setWLSEnv.sh来设置CLASSPATH和PATH环境变量
$ . $WEBLOGIC_BASE/wlserver/server/bin/setWLSEnv.sh
2、部署lib或app
部署app
$ java weblogic.Deployer -deploy \
-adminurl localhost:7001 \
-username weblogic -password my_secret \
-targets myserver \
-name myapp.war -source /usr/local/myapp.war
部署library
$ java weblogic.Deployer -deploy -library \
-adminurl localhost:7001 \
-username weblogic -password my_secret \
-targets myserver \
-source /user/local/my_shared_lib.war
撤销部署lib或app,name换成app或library的名字
$ java weblogic.Deployer -undeploy \
-adminurl localhost:7001 \
-username weblogic -password my_secret \
-targets myserver \
-name myapp_or_lib.war