Creating the JDBC provider (DB2)

The next step in the process is to create the JDBC provider.

1. Log in to the WebSphere® Application Server Integrated Solutions Console, if you are not still logged in.
2. Click Resources > JDBC Providers.
3. Click New.
4. Enter the following values in the Configuration tab:
   • Database type: DB2
   • Provider type: DB2 Universal JDBC Driver Provider
   • Implementation type: Connection pool data source
   • Name: JDBC provider name (for example, mcsJDBC). If you use a name other than mcsJDBC, use that name in place of mcsJDBC later in this procedure.
   • Description: Descriptive text (for example, JDBC provider for Multi-Channel Server database).
5. Click Next.
6. Enter the directory location for the database driver JAR files. Click Next.
7. Check the summary. Click Finish.
8. Click Save.
9. Create the data source for the JDBC provider you just created.
   1. Select the JDBC provider you just created (for example, mcsJDBC).
   2. Click Additional Properties > Data Sources. Click New.
   3. Enter the following values in the Configuration tab:
      • Name: Data source name (for example, mcsDS). If you use a name other than mcsDS, use that name in place of mcsDS later in this procedure.
      • JNDI Name: JNDI name (for example, jdbc/mcsDS). The name must start with jdbc/. If you use a JNDI name other than jdbc/mcsDS, use that name in place of jdbc/mcsDS later in this procedure.
10. Click Next.
11. Enter the database properties for the new data source.
    • Driver type: Type of the DB2 driver (for example, 4)
    • Database name: Name of the MCS database (for example, mcs)
    • Server name: Host name of the database server (for example, wpmls10.in.xyz.com)
    • Port number: Port number of the database (for example, 50000)
12. Click Next.
13. Select the previously created J2C entry from the Component-managed Authentication Alias drop-down list (for example, mcsDBauth). Click Next.
14. Check the summary. Click Finish.
15. Define the resultSetHoldability property for the data source you just created.
    1. Select the data source your just created (for example, mcsDS).
    2. Click Additional Properties > Custom Properties.
    3. Change the value of resultSetHoldability to 1.
    4. Click OK.
16. Click Save to save the configuration.
17. Restart the server1 application server using the following commands:
    

    wp_profile_root/bin/stopServer.sh server1 -username WAS_admin -password WAS_admin_password_value

    wp_profile_root/bin/startServer.sh server1

    

    wp_profile_root\bin\stopServer server1 -username WAS_admin -password WAS_admin_password_value

    wp_profile_root\bin\startServer server1

18. Log in to the WebSphere Application Server Integrated Solutions Console.
19. Click Resources > JDBC Providers > mcsJDBC > Data Sources.
20. Select the mcsDS check box and click Test Connection.
    Note: If the test connection fails and you modify the configuration, you must restart the server1 application server before testing the connection again.