Portal Scripting - To create JDBC Provider using Portal Scripting

****To create JDBC Provider****
-------------------------------

1. To set parent where we have to work
wsadmin>node = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/')

2. To print/output the node
wsadmin>print node

3. To Identify the required attributes for JDBC Provider
print AdminConfig.required('JDBCProvider')

4. Setting values for jdbc provider required attributes
n1 = ['name', 'CustomJDBC']
implCN = ['implementationClassName', 'com.mysql.jdbc.jdbc2.optional.MysqlConnectionPoolDataSource']
jdbcAttrs = [n1,  implCN]

5. To print this jdbcAttrs
print jdbcAttrs

6. Create a new JDBC provider using node as the parent
AdminConfig.create('JDBCProvider', node, jdbcAttrs)

7. Save the configuration changes
AdminConfig.save()

------The above procedure is used to create JDBC Provider through create(-,-,-) method---------

8. To set parent where we have to work
wsadmin>node = AdminConfig.getid('/Cell:TIT-JAVA-010Cell/Node:TIT-JAVA-010Node/Server:WebSphere_Portal/')

9. To list the templates provided in JDBC Provider
AdminConfig.listTemplates('JDBCProvider')

10. Specify the template that you want to use
t1 = AdminConfig.listTemplates('JDBCProvider', 'DB2 Universal JDBC Driver Provider(templates/system|jdbc-resource-provider-templates.xml#JDBCProvider_DB2_UNI_1)')

11. Create a new JDBC provider using node as the parent using template
AdminConfig.createUsingTemplate('JDBCProvider', node, [['name', 'customDB2JDBCProvider']], t1)

12. Save the configuration changes
AdminConfig.save()

------The above procedure is used to create JDBC Provider through createUsingTemplate(-,-,-,-) method---------