template_ds.txt 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", "${ds_name}", "${jndi_name}", "com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper", "${db_name}", [['componentManagedAuthenticationAlias', '${j2c}'], ['containerManagedPersistence', 'true'], ['xaRecoveryAuthAlias', '${j2c}']], [['serverName', '${server_name}'], ['driverType', 4], ['portNumber', ${port_number}]])
  8. AdminConfig.save()
  9. print AdminConfig.required('J2EEResourceProperty')
  10. newds = AdminConfig.getid('/Node:'+node+'/Server:server1/JDBCProvider:DB2 JDBC Driver/DataSource:${ds_name}/')
  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', '${schema_name}']])
  19. AdminConfig.save()