Use wsadmin to configure a JDBC provider

To configure a JDBC provider with wsadmin, follow these steps:

On the CL command line, run the STRQSH (Start Qshell) command.

Run the cd command to change to the directory that contains the wsadmin tool:

cd /QIBM/ProdData/WebASE51/ASE/bin

Start wsadmin.

At the wsadmin prompt, run this command to identify the parent ID and assign it to the node variable:

set node [$AdminConfig  getid  /Cell:myCell/Node:myNode/Server:myAppSvr/]

where myCell is the name of the cell that contains your application server, myNode is the name of the node that contains your application server, and myAppSvr is the name of your application server.

Run this command to identify the required attributes:

$AdminConfig required JDBCProvider

The command displays this output:

Attribute                 Type name                      String implementationClassName   String

Run these commands to set the required attributes and assign them to the jdbcAttrs variable:

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

You can modify the example to set optional attributes for JDBC provider. For a list of all of the attributes of a JDBC provider, run this command:

$AdminConfig attributes JDBCProvider

Run this command to create the new JDBC provider:

$AdminConfig create JDBCProvider $server $jdbcAttrs

Run this command to save your changes:

$AdminConfig save