How to Create Datasource in Websphere Application Server (ND)

Hello        

Today will discuss about Configuring a database connection between WebSphere Application Server V6.1 (Network Deployment) and Oracle Databse 10g.
 Below i have given only steps... I hope it will help you while creating datasource. This i have done at early stage of my carrier.. just posting you on demand some of my friends who are newbie on Websphere Application Server.

Step 1. Ensure that the odbc14.jar file is from Oracle 10g (10.2) or later. Older versions of this file will not work. If necessary, copy the needed version of the file to a folder on the WebSphere Application Server server (for example, D:\Oracle).
  
Step 2. Start the WebSphere Administrative Console.

Step 3. Log in using the user ID admin and the password admin (defined in the earlier section "Configuring security," above). 

Step 4. Set up the Oracle driver path.
         1. Click Environment in the navigation pane.
         2. Click WebSphere Variables.
         3. Click New.
         4. In the Name field, selectOracle_JDBC_DRIVER_PATH
         5. In the Value field, select the path to the Oracle library with the required version of the ojdbc14.jar file (for example, D:\Oracle.)
         6. Click Apply.
         7. Click OK.

Step 5. Set up J2C authentication.
         1. Click Security.
         2. Click Global Security.
         3. In the Authentication section of the Global Security window, click JAAS Configuration.
         4. Click J2C Authentication Data.
         5. Click New.
         6. In the Alias Entry field, type RAM_Con.
         7. In the User ID field, type an Oracle user ID with administration privileges. For Oracle, the user ID defined here must be the name given to the schema (for example, ramschema).
         8. In the Password field, type the password for the user ID.
         9. Click Apply.
        10. Click OK.

Step   6. Create a database connection
         1. Click Resources in the navigation pane.
         2. Click JDBC Providers.
         3. If you use a remote installation of DB2®, make sure the Node and Server entries are cleared and click Apply.
         4. If you work in a clustered environment, type the name of the cluster in the Cluster field and click Apply.

Step 7. If any other JDBC drivers have been defined for Rational Asset Manager (for example, JNDI Name = jdbc/RAM_Con), delete those drivers before completing the following steps.

Step 8. Create a JDBC Provider.
         1. Click New.
         2. For the database type, select Oracle.
         3. For the provider type, select Oracle JDBC Driver.
         4. For the implementation type, select Connection pool data source.
         5. Click Next.
         6. Click Apply.
         7. Click Data sources.
         8. Click New.

Step 9. Bind the database to a JNDI name.
         1. For the JNDI name, select jdbc/RAM_Con.
         2. For the Data store helper class name, select the level of Oracle installed (for example, Oracle 9i and prior data store helper).
         3. For the Component-managed authentication alias field, select the J2C authentication that you created earlier.
         4. For the URL field, type the path that the Oracle administrator provides. It will have the following form:      jdbc:oracle:thin:fully_qualified_machine_name:oracle_port_number:database_name.
         5. Click Apply.
         6. Click OK.
         7. Click Test Connection.

Step 10. Save the WebSphere Application Server configuration.
         1. Click Save at the top of the window.
         2. In the next window, click Save.

Step 11. Log out of the console.

Step 12. Restart the server.

Step 13. In a clustered environment, the Domain Manager (DM) must be restarted.

Please let me know any mistakes or any changes required,

I hope it will help you,, Enjoy working on Middleware...

Regards,
Ajinkya Vichare
ajinkya-vichare.blogspot.com