cell=AdminConfig.showAttribute(AdminConfig.list("Cell"), "name") node=AdminConfig.showAttribute(AdminConfig.list("Node"), "name") #Add JDBC jar path print "Adding JDBC jar path" AdminTask.setVariable('[-variableName OS400_TOOLBOX_JDBC_DRIVER_PATH -variableValue /home/wasadmin/db/lib -scope Cell='+cell+',Node='+node+']') AdminConfig.save() #JDBC Datasources print "Creating Datasource" print "Creating Datasource" #AdminJDBC.createDataSourceAtScope("Node="+node+",Server=server1", "DB2 AS400 JDBC Driver", "as400datasource", "jdbc/as400/btn_ds", "com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper", "BWIDAT", [['componentManagedAuthenticationAlias', 'BTNSOA'], ['containerManagedPersistence', 'true'], ['xaRecoveryAuthAlias', 'BTNSOA']], [['serverName', '172.18.30.104']]) #AdminJDBC.createDataSourceAtScope(node, "server1", "DB2 AS400 JDBC Driver", "as400datasource", [['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper'], ['jndiName','jdbc/as400/btn_ds'], ["mapping",[["componentManagedAuthenticationAlias","BTNSOA"], ["xaRecoveryAuthAlias","BTNSOA"], ["containerManagedPersistence", 'true']]] ]) AdminJDBC.createDataSource(node, "server1", "DB2 AS400 JDBC Driver", "as400datasource", [['authDataAlias', 'BTNSOA'], ['datasourceHelperClassname', 'com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper'], ['jndiName', 'jdbc/as400/btn_ds'], ['logMissingTransactionContext', 'false'], ['manageCachedHandles', 'false'], ['mapping', [['authDataAlias', 'BTNSOA'], ['mappingConfigAlias', 'BTNSOA']]], ['preTestConfig', [['preTestConnection', 'true'], ['retryInterval', 12343], ['retryLimit', 4]]], ['propertySet', [['resourceProperties', [ [ ['name', 'databaseName'], ['type', 'String'], ['value', 'BWIDAT'] ], [ ['name', 'serverName'], ['type', 'String'], ['value', '172.18.30.104'] ] ] ]] ], ['providerType', 'DB2 UDB for iSeries (Toolbox)'], ['statementCacheSize', 5], ['xaRecoveryAuthAlias', 'BTNSOA']]) AdminConfig.save() #print AdminConfig.required('J2EEResourceProperty') #newds = AdminConfig.getid('/Node:'+node+'/Server:server1/JDBCProvider:DB2 JDBC Driver/DataSource:as400datasource/') #print newds #propSet = AdminConfig.showAttribute(newds, 'propertySet') #props = AdminConfig.list('J2EEResourceProperty',propSet).splitlines() #propertyName = 'databaseName' #for prop in props: # name = AdminConfig.showAttribute(prop, 'name') # if propertyName == name: # AdminConfig.modify(prop, [['value', 'BWIDAT']]) #AdminConfig.save()