Jython - JDBC DS 设置

Question

我想将数据源的自定义属性中名为“SendStringParametersAsUnicode”的现有属性更新为 true。2- 我想在数据源的连接池中将最大连接数设置为 50dsid = AdminTask.createDatasource('provider_id, '[-name [Team Server Datasource] -jndiName jdbc/ilogDataSource -dataStoreHelperClassName com.ibm.websphere.rsadapter.DB2DataStoreHelper -componentManagedAuthenticationAlias RES_db2conn -containerManagedPersistence true -xaRecoveryAuthAlias RES_db2conn -configureResourceProperties [[databaseName java.lang.String ' + str(databaseName) + '] [driverType java.lang.Integer ' + str(driverType) + '] [serverName java.lang.String ' + str(serverName) + '] [portNumber java.lang.Integer ' + portNumber + ']]]')AdminConfig.create('MappingModule', dsid , '[[authDataAlias RES_db2conn [mappingConfigAlias ""]]')AdminConfig.save()print "Configuration changes saved."import timetime.sleep(10) # Delay for 10 seconds.AdminControl.testConnection(dsid)任何人都知道 jython 代码？最后更新 ：#provider_id=AdminConfig.getid('/Cell:E1DSCell/JDBCProvider:DB2 XA provider/')#jdbcProvider1 = AdminConfig.getid('/JDBCProvider:myJdbcProvider/')provider_id = AdminConfig.getid('/JDBCProvider:Microsoft SQL Server JDBC Driver/')# dataStoreHelperClassName com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper# componentManagedAuthenticationAlias TEMP-HRZEMM01Node01/PlatformDataSource # print "Creating DataSource"dsid = AdminTask.createDatasource(provider_id, '[-name [Team Server Datasource] -jndiName jdbc/ilogDataSource -dataStoreHelperClassName com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper -componentManagedAuthenticationAlias TEMP-HRZEMM01Node01/PlatformDataSource -containerManagedPersistence true -xaRecoveryAuthAlias TEMP-HRZEMM01Node01/PlatformDataSource -configureResourceProperties [[databaseName java.lang.String Compass] [portNumber java.lang.Integer 1433] [serverName java.lang.String SQLSVR1]]]')

Answer 1

尝试使用 wsadmin - jython 接口运行以下代码段：

ds_name = 'Team Server Datasource' #Name copied from your question, update if required

provider_id = #Use the same provider id used for creating the datasource (provider_id used in dsid = AdminTask.createDatasource('provider_id, '[-name [Team Server Datasource] ...)

#Get the list of datasources

dsList = AdminConfig.list('DataSource', provider_id).splitlines()

for ds in dsList:

    if (ds_name == AdminConfig.showAttribute(ds, "name")):

        #Modify Connection Pool

        AdminConfig.modify(AdminConfig.showAttribute(ds, 'connectionPool'), '[[maxConnections "50"]]')

        #Modify SendStringParametersAsUnicode property if it exists

        propSet = AdminConfig.list("J2EEResourcePropertySet", ds)

        for prop in AdminConfig.list("J2EEResourceProperty", propSet).splitlines():

            if (AdminConfig.showAttribute(prop, "name") == 'SendStringParametersAsUnicode'):

                AdminConfig.modify(prop, [["value", "true"]])

AdminConfig.save()