Jython Script - Create Datasource on Websphere

mywsadmin.py

#รัน Library Script
execfile('wsadminlib.py')

enableDebugMessages() #สำหรับเปิด Log

#==============================
#เริ่มด้วยการสร้าง JDBCProvider
#==============================
_parent = getServerId(_nodeName,'server1') #กำหนดว่าเราจะสร้าง JdbcProvider ใน Scope 'Server'
_name ='DB2 Using IBM JCC Driver (XA)'
#กำหนด Directory ของ DB2 Driver
_classpath ='${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc4.jar;${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cu.jar;${UNIVERSAL_JDBC_DRIVER_PATH}/db2jcc_license_cisuz.jar'
_nativepath = '${DB2_JCC_DRIVER_NATIVEPATH}'
_implementationClassName = 'com.ibm.db2.jcc.DB2XADataSource'
_description = 'Jdbc Provider for VS'
removeJdbcProvidersByName(_name) #ลบ JdbcProvider ตัวเก่าออกก่อน
_oJdbcProvider = createJdbcProvider(_parent,_name,_classpath,_nativepath,_implementationClassName,_description)
sop(A,'created jdbcprovider')

#==============================
#create JAAS (Java Authentication and Authorization Service)
#==============================
_JAASName = 'authen/MYDB1'
createJAAS(_JAASName,"dbusername","dbpassword")

#==============================
#สร้าง DataSource แบบธรรมดา
#จะได้ DataSource ใน Scope 'Server'
#==============================
_datasourceName = 'MyDataSource'
_datasourceDesc = 'DataSource for Application1'
_datasourceJNDIName = 'jdbc/MyDataSource'
_statementCacheSize = 100
_authAliasName = _JAASName
_datasourceHelperClassname = 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper'
createDataSource (_oJdbcProvider, _datasourceName, _datasourceDesc, _datasourceJNDIName, _statementCacheSize, _authAliasName, _datasourceHelperClassname )

#==============================
#สร้าง DataSource แบบอลังการสามารถระบุ IP ของ Database ได้
#จะได้ DataSource ใน Scope 'Server'
#==============================
_scope = 'server'
_clusterName=''
_serverName_scope='server1' #ชื่อ serverWAS
_jdbcProvider = _oJdbcProvider
_statementCacheSize = 200
_datasourceHelperClassname = 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper'
_dbType='DB2'
_nonTransDS=''
_cmpDatasource='false'
_xaRecoveryAuthAlias=None
_databaseName= 'MYDB1'
_serverName='127.0.0.1' #database ip address
_portNumber=50001 #database port
_driverType=4
_datasourceDesc = 'datasource for Application2'
#
_datasourceName ='AppDataSource'
_datasourceJNDIName = 'jdbc/AppDataSource'
_authAliasName = _JAASName
_oDSId = createDataSource_ext ( _scope, _clusterName, _nodeName, _serverName_scope, _jdbcProvider, _datasourceName, _datasourceDesc, _datasourceJNDIName, _statementCacheSize, _authAliasName, _datasourceHelperClassname, _dbType, _nonTransDS, _cmpDatasource, _xaRecoveryAuthAlias, _databaseName, _serverName, _portNumber, _driverType)

save()

666