DS_MWTEMP_MWTEMP_REKON.py 1.3 KB

1234567891011121314151617181920212223
  1. cell=AdminConfig.showAttribute(AdminConfig.list("Cell"), "name")
  2. node=AdminConfig.showAttribute(AdminConfig.list("Node"), "name")
  3. print "Adding JDBC jar path"
  4. AdminTask.setVariable('[-variableName DB2UNIVERSAL_JDBC_DRIVER_PATH -variableValue /home/wasadmin/db/lib -scope Cell='+cell+',Node='+node+']')
  5. AdminConfig.save()
  6. print "Creating Datasource"
  7. AdminJDBC.createDataSourceAtScope("Node="+node+",Server=server1", "DB2 JDBC Driver", "MWTEMP_MWTEMP_REKON", "jdbc/db2/mwtemp_rekon_ds", "com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper", "MWTEMP", [['componentManagedAuthenticationAlias', 'db2prod'], ['containerManagedPersistence', 'true'], ['xaRecoveryAuthAlias', 'db2prod']], [['serverName', '172.18.1.101'], ['driverType', 4], ['portNumber', 50000]])
  8. AdminConfig.save()
  9. print AdminConfig.required('J2EEResourceProperty')
  10. newds = AdminConfig.getid('/Node:'+node+'/Server:server1/JDBCProvider:DB2 JDBC Driver/DataSource:MWTEMP_MWTEMP_REKON/')
  11. print newds
  12. propSet = AdminConfig.showAttribute(newds, 'propertySet')
  13. props = AdminConfig.list('J2EEResourceProperty',propSet).splitlines()
  14. propertyName = 'currentSchema'
  15. for prop in props:
  16. name = AdminConfig.showAttribute(prop, 'name')
  17. if propertyName == name:
  18. AdminConfig.modify(prop, [['value', 'MWTEMP']])
  19. AdminConfig.save()