Portal Scripting - Sample Script for creating JDBC Provider using AdminConfig

# This are comment lines
# My Custom Jython Script for creating JDBC Provider through create/createUsingTemplate
# Here getid should be specified has parent(scope) where we are creating our JDBC Provider
# To Run script in wsadmin follow below command
# wsadmin.bat -lang jython -javaoption "-Djython.package.path=D:\IBM\WebSphere\AppServer\plugins\com.ibm.ws.wlm.jar" -username admin -password admin -f  # #customJDBCProvider.py


# Creating JDBC provider using create command

node = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/')
print node
print AdminConfig.required('JDBCProvider')
n2 = ['name', 'CustomJDBCProviderThroughScript']
implCN2 = ['implementationClassName', 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource']
jdbcAttrs = [n2,  implCN2]
print jdbcAttrs
AdminConfig.create('JDBCProvider', node, jdbcAttrs)
AdminConfig.save()



******************************************************************************************************************************************************************

# Creating JDBC provider using createUsingTemplate command


sc =  AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/')
t = AdminConfig.listTemplates('JDBCProvider', 'DB2 Universal JDBC Driver Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2_UNI_1)')
AdminConfig.createUsingTemplate('JDBCProvider', sc, [['name', 'customDB2JDBCProvider']], t)
AdminConfig.save()