mwapp_mwbp_ds.jython 1.0 KB

1234567891011121314151617181920212223242526272829
  1. import os
  2. # Mengambil userAlias dari variabel lingkungan
  3. userAlias = os.environ.get('USER_ALIAS', '10_10_10_36')
  4. # DS MWBP
  5. newjdbc = AdminConfig.getid('/Cell:DefaultCell01/Node:DefaultNode01/Server:server1/JDBCProvider:DB2 Universal JDBC Driver Provider (XA)/')
  6. name = ['name', 'DS_MWBP']
  7. jndi = ['jndiName', 'jdbc/db2/mwapp_mwbp_ds']
  8. auth = ['authDataAlias', userAlias]
  9. helper = ['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper']
  10. dsAttrs = [name, jndi, auth, helper]
  11. newds = AdminConfig.create('DataSource', newjdbc, dsAttrs)
  12. print(newds)
  13. # properties
  14. properties = [
  15. {'name': 'driverType', 'value': '4'},
  16. {'name': 'databaseName', 'value': 'MWAPP'},
  17. {'name': 'serverName', 'value': 'db2-mwapp'},
  18. {'name': 'portNumber', 'value': '50000'},
  19. {'name': 'currentSchema', 'value': 'MWBP'}
  20. ]
  21. propSet = AdminConfig.create('J2EEResourcePropertySet', newds, [])
  22. for prop in properties:
  23. AdminConfig.create('J2EEResourceProperty', propSet, [[k, v] for k, v in prop.items()])
  24. AdminConfig.save()