| 1234567891011121314151617181920212223242526272829 |
- import os
- # Mengambil userAlias dari variabel lingkungan
- userAlias = os.environ.get('USER_ALIAS', '10_10_10_36')
- # DS MWRECON
- newjdbc = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/JDBCProvider:DB2 Universal JDBC Driver Provider (XA)/')
- name = ['name', 'DS_MWRECON']
- jndi = ['jndiName', 'jdbc/db2/mwapp_mwrecon_ds']
- auth = ['authDataAlias', userAlias]
- helper = ['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper']
- dsAttrs = [name, jndi, auth, helper]
- newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
- print(newds)
- # properties
- properties = [
- {'name': 'driverType', 'value': '4'},
- {'name': 'databaseName', 'value': 'MWAPP'},
- {'name': 'serverName', 'value': 'db2-mwapp'},
- {'name': 'portNumber', 'value': '50000'},
- {'name': 'currentSchema', 'value': 'MWRECON'}
- ]
- propSet = AdminConfig.create('J2EEResourcePropertySet', newds, [])
- for prop in properties:
- AdminConfig.create('J2EEResourceProperty', propSet, [[k, v] for k, v in prop.items()])
- AdminConfig.save()
|