Configuring a JDBC provider using wsadmin

Example: Configuring a JDBC provider using wsadmin

An example configuring a new JDBC provider follows:

• Identify the parent ID and assign it to the node variable.

  set node [$AdminConfig  getid  /Cell:mycell/Node:mynode/]

  This example uses the node configuration object as the parent. You can modify this example to use cell or server configuration object as the parent.

  An example of this output follows:

  mynode(cells/mycell/nodes/mynode:node.xml#Node_1)

• Identify the required attributes:

  $AdminConfig required JDBCProvider

  An example of this output follows:

  Attribute     Type name     String implementationClassName   String

• Set up the required attributes and assign it to the jdbcAttrs variable:

  set n1 [list name JDBC1] set implCN [list implementationClassName myclass] set  jdbcAttrs [list  $n1  $implCN]

  An example of this output follows:

  {name {JDBC1}} {implementationClassName {myclass}}

  You can modify the example to setup non-required attributes for JDBC provider.

• Create a new JDBC provider using node as the parent:

  $AdminConfig create JDBCProvider $node $jdbcAttrs

  An example of this output follows:

  JDBC1(cells/mycell/nodes/mynode:resources.xml#JDBCProvider_1)"

• Save the changes with the following command:

  $AdminConfig save