Configuring the WebSphere application Server data source

Source: Internet
Author: User
Tags uicontrol websphere application server

Configuring the WebSphere application Server data source

Version WebSphere Application Server 7.0.0.x WebSphere Application Server 8.0.0.x

Installed applications use data sources as resources to obtain connection to relational databases. To create these connections between an application and a relational database, WebSphere application Server uses the driver Implementation classes that's encapsulated by the JDBC provider, which is a object that represents Vendor-specific JDB C driver classes to WebSphere application Server. For access to a relational databases, applications with the JDBC drivers and data sources that you configure for WebSphere Application Server.

Procedure
  1. Start the WebSphere Application Server Administrative Console.

  2. Click Security, Global security.

  3. On the Configuration panel, expand Java Authentication and Authorization Service and click j2c authentication Data.

  4. Click New and enter the Alias, User ID and Password.

  5. Click Ok.

  6. On the WebSphere application Server Administrative Console, expand Resources. Expand jdbc then click jdbc Providers.

  7. In the Scope section, choose the Node level from the Drop-down list.

  8. Click New to create a new JDBC driver.

  9. Select, in this order, the Database type, Provider type, implementation type and Name. The Name automatically fills based on the implementation type of you choose.

  10. Click Next and configure the database class path. Click Next.

  11. On the Summary page, click Finish.

  12. Click Save to save your selections. The JDBC Providers page then appears.

  13. On the WebSphere application Server Administrative Console, click Data sources.

  14. Click New to create a new data source. Enter the Data source name and the JNDI name, and choose the authentication alias from the Drop-down list in Component-man Aged authentication alias. The JNDI name should match the DataSourceName value set in wimconfig.xml. By default, it is jdbc/wimds.

    Note: For Apache Derby v10.2 embedded databases, leave the Component-managed authentication alias field set to NONE.

  15. Click Next.

  16. Enter the Database name and deselect the checkbox, use this data source in container managed persistence (CMP). Click Next.

  17. On the Summary page, click Finish.

  18. The Data sources page displays. Click Save, and then select the check box for the authentication alias previously created. Click Test Connection. The message should indicate the connection is successful. Ignore any warnings, and then click Next.

  19. Click Environment > WebSphere Variables.

  20. In the Scope section, select cells from the Drop-down list.

  21. Click New to create a variable.

  22. In the Name field, enter VMM_JDBC_CLASSPATH .

  23. In the Value field, enter the complete path to the JDBC driver library files separated by a colon (:) fo R UNIX or Linux or a semicolon (;) for Windows. For example, the path to Linux or UNIX is as follows: /opt/ibm/sqllib/java/db2jcc.jar:/opt/ibm/sqllib/java/db2jcc_lic Ense_cu.jar.

  24. Click OK. Additionally, copy the specified JDBC driver library files in the ${was_home}/lib directory of each installed Web Sphere Application Server node.

  25. Save the configurations, and restart WebSphere application Server.


Configuring the WebSphere application Server data source

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.