Add the JDBC adapter

Add a JDBC Adapter external service to the mediation module and deploy the mediation module.

1. Right click MonitorAdapter and select New > External Service.
   
2. Select Adapters and click Next.
3. Select IBM WebSphere Adapter for JDBC and click Next.
4. Select WebSphere ESB Server v6.1 for the Target runtime and click Next.
5. Click Add, locate and select the db2jcc.jar and db2jcc_licence_cu .jar files in the DB2 installation directory and click Open to add the JDBC driver jar files and click Next.
   
6. Select Inbound and click Next.
7. Select DB2 UDB > V8.2 from the database list and type ADAPTER for the database, type the DB2 admin user name and password.
8. Click Next, then click Run Query to find the table lists. Select DB2ADMIN > Tables > CUSTOMER and click > to add CUSTOMER to the Selected objects list. Click Next.
   
9. Click Next.
10. In the Service Generation and Deployment Configuration window, enter the following values:
    1. For J2C Authentication Data Entry, type <NodeName>/JDBCAdapter/inbound, where <NodeName> is the node name of the WebSphere Application Server that will run the MonitorAdapter module. The node name for the Monitor Server on WebSphere ESB defaults to WBMonSrv_esb_Node.
    2. Enter the password for the DB2 Admin User name.
       
    3. Click Advanced and expand Advanced connection configuration and type jdbc/DB2XA as the Datasource JNDI name. You will create this datasource later.
       
11. Click Next and then click Finish.