Configure custom properties of a Datasource in WebSphere 7 after creating it with Jython scripts

Greenhorn

Posts: 2

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

I am trying to configure the propertySet after creating the datasource with Jython script and after I save the properties will be out there twice. Once with the value that I set them to and once with the default value. I could run the code to remove all custom properties, but then I would have to go and set all 94 custom properties.

Is there a way to update the value of a custom property without putting 2 entries and removing all other custom properties?
I also have the option to copy the custom properties from another datasource that is already created, is that possible with Jython script?

AdminTask.createDatasource(provider , "[-name '"+dsName+"' -jndiName "+jdbcName+" 
-dataStoreHelperClassName com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper 
-containerManagedPersistence true 
-componentManagedAuthenticationAlias "+userComponent+" 
-configureResourceProperties [[serverName java.lang.String "+serverName+"] ] ]")

ds = AdminConfig.getid("/JDBCProvider:DB2 UDB for iSeries (Toolbox)/DataSource:"+dsName+"/")

#Remove All attributes before coping over new attributes
resetAttrs = []
resetAttrs.append(['propertySet', []])
AdminConfig.modify(ds, resetAttrs)

#Code to update datasouce custom properties
dbnameAttr = [["name", "databaseName"], ["value", dbname], ["type", "java.lang.String"]]
timeFormatAttr=[["name", "timeFormat"], ["value", "iso"], ["type", "java.lang.String"]] 
dateFormatAttr=[["name", "dateFormat"], ["value", "iso"], ["type", "java.lang.String"]] 
isolationAttr=[["name", "isolationLevelSwitchingSupport"], ["value", "true"], ["type", "java.lang.Boolean"]]
newPS=[]
newPS.append(dbnameAttr)
newPS.append(timeFormatAttr )
newPS.append(dateFormatAttr )
newPS.append(isolationAttr )
psAttr = ["propertySet", [["resourceProperties", newPS]]]
newAttrs= []
newAttrs.append(psAttr)
AdminConfig.modify(ds, newAttrs)
AdminConfig.save()

Deepak Pant

Ranch Hand

Posts: 446

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Have you tried removing following code from your script. Unless you added it after your initial tests failed.

)

Curtis Pendleton

Greenhorn

Posts: 2

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Deepak Pant,

If I remove those lines of code from the script, then it will have duplicate entries for the custom properties that I add after that.

If I leave those lines of code in the script, then it will only have the properties that I have overridden when the script is complete, but all other properties will be removed.

What I want in the end is to have all existing properties on the data source, but change the values of the ones I need to change without having duplicates.

Geert Pante

Greenhorn

Posts: 8

posted 13 years ago

Number of slices to send:

Optional 'thank-you' note:

Send

Curtis Pendleton wrote:I am trying to configure the propertySet after creating the datasource with Jython script and after I save the properties will be out there twice. Once with the value that I set them to and once with the default value. I could run the code to remove all custom properties, but then I would have to go and set all 94 custom properties.

Is there a way to update the value of a custom property without putting 2 entries and removing all other custom properties?
I also have the option to copy the custom properties from another datasource that is already created, is that possible with Jython script?

Hi there,

It took me quite a while to figure this one out, too. Hope you're not still waiting for an answer, but I'll post it anyway for other searchers.

The key is to use AdminConfig.getid('/.../J2EEResourcePropertySet:/') and AdminConfig.getid('/.../J2EEResourcePropertySet:/J2EEResourceProperty:propName/') to get the existing propertySet and/or property.