process

wireless application website:https://bluewireless.ibm.com/leap_request.jsp


Step 1: Create the J2C authentication alias for the database

Login the WAS console, click "Security" - > "GlobalSecurity" -> "Authentication" -> "JAAS Configuration" -> "J2C Authentication data";
Click "New", input "widNode/widNode/MTPDBAuthAlias " as the "Alias", the database user name and password in "User ID" and "Password" feilds, for example "db2admin" and "db2admin" are the user id and password of our local database;

Step 2: Create the DB2 JDBC Provider if there is no such one

Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
If there has the JDBC provider for DB2 (such as "DB2 JDBC2-compliant Provider " or "DB2 Universal JDBC Driver provider"), then do not need to create it again, skip this step and go to "Step 3"; Otherwise continue;
Click "New" button; select "DB2" as Database type, "DB2 Universal JDBC Driver provider" as Provider type, "com.ibm.db2.jcc.DB2ConnectionPoolDataSource" as Implementation type.
Click "Next", this page shows the path of the DB2 JDBC driver; The path is defined with the variable "DB2UNIVERSAL_JDBC_DRIVER_PATH";
Click "Finish", and then save the changes to the master configuration.
Click "Environment" -> "WebSpehre variables" in the left navigation bar; find the value of viarable "UNIVERSAL_JDBC_DRIVER_PATH"; make sure the value is the correct location that DB2 driver jar/zip files exist; for example "C:\IBM\SQLLIB\java"; //${WAS_INSTALL_ROOT}/universalDriver/lib

Step 3: Create the Data source

Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
Click the DB2 JDBC driver that you just created or has existed, then click the "Data sources" link;
Click "New" button, input "MTPDS" as the name, "jdbc/MTPDS" as the "JNDI name"; in the drop down list "Component-managed authentication alias", select "widNode/widNode/MTPDBAuthAlias"; in "Database name", input the name of the database: "MTPDB";
If the driver is of JDBC type: "4" ("DB2 Universal JDBC Driver provider"), you also need to input the server name and port number, like "9.123.237.82" and "50000";
Click "Save" to save the settings, and then save the changes to the master configuration.

Step 3: Test the data source

Click "Resources" -> "JDBC Providers" in the left navigation bar; the existing JDBC providers will be listed;
Click the DB2 JDBC driver that you just created or has existed, then click the "Data sources" link;
Select "MTPDS", and then click "Test connection" button. The result will be shown, if the test is failed, go back again to check if there is anything wrong.