| 1234567891011121314151617181920212223242526272829303132333435363738394041424344 |
- 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()
|
