WebSphere Data Source Configuration

WebSphere Data Source Configuration

2. Login Http://localhost:9061/ibm/console/login.do (according to your own the configuration for this URL, which is the default URL).
4. On the left navigation, click on "Environment" menu, and then spread the Sum menu, click on the "WebSphere variables".
   
6. On the right page shows the variables list, click "Next" button to move to Next page and find "Oracle_jdbc_driver_path" va Riable.
   
   
8. Edit this path, set the "Value" as the path of the your Oracle driver jar file.
   
10. After set the value, click on "Apply" button, also click "Save" button to take effect.
    
12. Click the menu as below image shows, and click "New" button.
    
14. Step 1:create new JDBC provider. The values set as below image shows. And then click "Next".
    
16. Step 2, if the Oracle jar is not a same as images shows, you can change it later. This page is no needs to the change, click "Next".
    
18. Step 3, no change to click "Finish"
    
20. Save the configuration.
    
22. You can click on the name in the the configuration of the list to change.
    
24. If something is wrong, you can change it. eg.my jar name is not a "ojdbc6.jar", so change the class path as "Ojdbc14-10.2.0.3.jar", and click "Apply", "Save" button.
    
26. Create Data Source.
    
28. Step 1, "Date Source name" can free to input, "JNDI name" is "jdbc/datasource".
    
30. Step 2, select an existing JDBC provider.
    
32. Input URL "Jdbc:oracle:thin: @cndalwebdb04vl. Cn.fid-intl.com:1521:d1cia".
    (according you own configuration).
    
34. Setup security aliases. (Set up Oracle username and password). Set later. Do nothing and next.
    
36. Confirm page, click "Finish" button.
    
38. Save the data source configuration.
    
40. ADD "JAAS-J2C Authentication Data" (Oracle username and password).
    After the set "security setting".
    
42. Click the "New" button.
    
44. Alias is free to input, the User ID and Password use to connect Oracle DB.
    
46. Apply and save.
    
48. Link to Data Source Edit page, edit "Security settings" option.
    
50. Apply and save.
    
52. Test connection.
    
54. Connect successfully if shows below page. And the entire configuration for data source have done.
    

WebSphere Data Source Configuration