WebSphere Application Server Version 6.1 Feature Pack for Web Services
             Operating Systems: AIX, HP-UX, i5/OS, Linux, Solaris, Windows, z/OS

             Personalize the table of contents and search results

Creating a data source for the UDDI registry

You create a data source so that the UDDI registry can use it to access the UDDI database.

Before you begin

You must have already created the database for the UDDI registry. These instructions assume that, if you are installing into a cluster, a single database will be used by all members of the cluster.
[AIX HP-UX Linux Solaris Windows] Note: If you are connecting to a remote DB2 database on the z/OS operating system, you must have a DB2 Connect license installed. See the DB2 documentation for more information.

About this task

Perform this task as part of setting up and deploying a new UDDI registry. The UDDI registry uses the data source to access the UDDI database.

Procedure

  1. Create a J2C Authentication Data Entry. This is not required for embedded Cloudscape, but is required for network Cloudscape.
    1. Click Security > Secure administration, applications, and infrastructure > [Authentication] Java Authentication and Authorization Service > J2C authentication data.
    2. Click New to create a new J2C authentication data entry.
    3. Complete the following details:
      Alias
      A suitable short name, for example, UDDIAlias.
      Userid

      [AIX HP-UX Linux Solaris Windows] [i5/OS] The database user ID (for example, db2admin for DB2, or IBMUDDI for Oracle), which is used to read and write to the UDDI registry database. For network Cloudscape, the user ID can be any value.

      [AIX HP-UX Linux Solaris Windows] If you are using a remote DB2 database on the z/OS operating system, the user ID must be one that is valid on the remote system.

      [z/OS] The database user ID (for example, db2admin for DB2), which is used to read and write to the UDDI registry database. For network Cloudscape, the user ID can be any value.

      Password
      The password associated with the user ID specified earlier. For network Cloudscape, the password can be any value.
      Description
      A description for the chosen user ID.

      Click Apply, then save the changes to the master configuration.

  2. Create a JDBC Provider, if a suitable one does not already exist, using the following table to determine the provider type and implementation type for your chosen database:
    Database Provider type Implementation type
    DB2

    DB2 Universal JDBC Driver Provider

    Connection Pool data source
    DB2 DB2 UDB for iSeries (Native) Connection Pool data source
    DB2 DB2 Universal JDBC Driver Provider Connection Pool data source
    Oracle Oracle JDBC Driver Connection Pool data source
    Embedded Cloudscape Derby JDBC Driver Connection Pool data source
    Network Cloudscape Derby Network Server JDBC Driver provider Connection Pool data source
    Microsoft SQL Server DataDirect Connect JDBC Driver Connection Pool data source
    Note: If you are setting up a UDDI node in a cluster, select cluster as the scope of the JDBC provider.
    For details on how to create a JDBC provider, see Creating and configuring a JDBC provider using the administrative console.
  3. Create the data source for the UDDI registry by following these steps:
    1. Click Resources > JDBC > JDBC Providers.
    2. Select the scope of the JDBC provider that you selected or created earlier, that is, the level at which the JDBC provider is defined. For example, for a JDBC provider that is defined at the level of server1, select the following:
      Node=Node01, Server=server1 
      All the JDBC providers that are defined at the selected scope are displayed.
    3. Select the JDBC provider that you created earlier.
    4. Under Additional Properties, select Data sources. Do not select the Data sources (WebSphere Application Server V4) option.
    5. Click New to create a new data source.
    6. In the Create a data source wizard, enter the following data:
      Name
      A suitable name, such as UDDI Datasource.
      JNDI name
      Set this value to datasources/uddids. This is a mandatory field.

      You must not have any other data sources that use this JNDI name. If you have another data source that uses this JNDI name, you must either remove it or change its JNDI name. For example, if you created a default UDDI node previously using a Cloudscape database, before you continue, use the uddiRemove.jacl script with the default option to remove the data source and the UDDI application instance.

      Component-managed authentication alias
      • For DB2, Oracle, or network Cloudscape, select the alias that you created in step 2. It is prefixed by the node name, for example MyNode/UDDIAlias.
      • For embedded Cloudscape, leave this option as (none).
    7. Click Next.
    8. On the database specific properties page of the wizard, enter the following data:
      • For DB2:
        Database name [AIX HP-UX Linux Solaris Windows]
        For example:
        UDDI30
        Notes:
        • If you are using a remote database on a distributed system, the database name is the alias that you created to reference the database. See Creating a DB2 distributed database.
        • If you are using a remote DB2 database on the z/OS operating system, the database name is the local LOCATION value. To find this value, enter the operator command -DIS DDF at the console, or ask your DB2 administrator for the information. This value is case sensitive.
        Database name [i5/OS]
        For example:
        *LOCAL
        Database name [z/OS]
        This is the local LOCATION value. To find this value, enter the following operator command at the console, or ask your DB2 administrator for the information:
        -DIS DDF
        This value is case sensitive.

        For a remote database, the database name is the alias that you created to reference the database. See Creating a DB2 distributed database.

        Driver type [AIX HP-UX Linux Solaris Windows]
        This value applies only if you are using a remote DB2 database on the z/OS operating system. Set this value to 4.
        Driver type [z/OS]
        Set this value to 4.
        Server name [AIX HP-UX Linux Solaris Windows]
        This value applies only if you are using a remote DB2 database on the z/OS operating system. Set this value to the IP address of the remote machine that is hosting the database. Use the -DIS DDF operator command to find this information, or ask your DB2 administrator for the information.
        Server name [z/OS]
        Set this value to the IP address of the machine that is hosting the database. Use the -DIS DDF operator command to find this information, or ask your DB2 administrator for the information.
        Port number [AIX HP-UX Linux Solaris Windows]
        This value applies only if you are using a remote DB2 database on the z/OS operating system. Set this value to the port that the DB2 database is listening on. Use the -DIS DDF operator command to find this information (or ask your DB2 administrator for the information).
        Port number [z/OS]
        Set this value to the port that the DB2 database is listening on. Use the -DIS DDF operator command to find this information (or ask your DB2 administrator for the information).
      • [AIX HP-UX Linux Solaris Windows] [i5/OS] For Oracle - URL - for example:
         jdbc:oracle:oci8:@<Oracle database name>

        [AIX HP-UX Linux Solaris Windows] [z/OS] This example applies to local and remote Oracle databases.

      • [AIX HP-UX Linux Solaris Windows] [z/OS] For Cloudscape (embedded or network) - Database name - for example:
        app_server_root/profiles/profile_name/databases/com.ibm.uddi/UDDI30
        For network Cloudscape, also make sure that the Server name and Port number values match the network server.

        Leave all other fields unchanged.

      • [i5/OS] For Cloudscape (embedded or network) - Database name - for example:
        profile_root/databases/com.ibm.uddi/UDDI30
        For network Cloudscape, also make sure that the Server name and Port number values match the network server.
      Use this Data Source in container-managed persistence (CMP)
      Ensure that the check box is cleared.
    9. Click Next, then check the summary and click Finish.
    10. Click the data source to display its properties, and add the following information:
      Description
      A description of the data source.
      Category
      Set this value to uddi.
      Data store helper class name
      This value is provided automatically:
      Database Data store helper class name
      DB2 com.ibm.websphere.rsadapter.DB2DataStoreHelper, or com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper if you are using a remote DB2 database on the z/OS operating system
      DB2 com.ibm.websphere.rsadapter.DB2AS400DataStoreHelper
      DB2 com.ibm.websphere.rsadapter.DB2UniversalDataStoreHelper
      Oracle 9i com.ibm.websphere.rsadapter.OracleDataStoreHelper
      Oracle 10g com.ibm.websphere.rsadapter.Oracle10gDataStoreHelper
      Embedded Cloudscape com.ibm.websphere.rsadapter.DerbyDataStoreHelper
      Network Cloudscape com.ibm.websphere.rsadapter.DerbyNetworkServerDataStoreHelper
      Microsoft SQL Server com.ibm.websphere.rsadapter.ConnectJDBCDataStoreHelper

      com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper

      Mapping-configuration alias
      Set this option to DefaultPrincipalMapping.
    11. [AIX HP-UX Linux Solaris Windows] [z/OS] Click Apply and save the changes to the master configuration.
    12. [i5/OS] Click Apply.
    13. [i5/OS] Select Additional Properties > Custom Properties > libraries .
    14. [i5/OS] Enter IBMUDI30,IBMUDS30 in the Value field and click OK.
    15. [i5/OS] Save the changes to the master configuration.
  4. Test the connection to your UDDI database by selecting the check box next to the data source and clicking Test connection. A message similar to "Test Connection for datasource UDDI Datasource on server server1 at node MyNode was successful" is displayed. If you do not see this message, investigate the problem with the help of the error message.

What to do next

Continue with setting up and deploying your UDDI registry node.



In this information ...


IBM Redbooks, demos, education, and more


Use IBM Suggests to retrieve related content from ibm.com and beyond, identified for your convenience.

This feature requires Internet access.

IBM Suggests
Task topic    

Terms of Use | Feedback

Last updated: Nov 25, 2008 2:35:59 AM CST
http://publib.boulder.ibm.com/infocenter/wasinfo/v6r1/index.jsp?topic=/com.ibm.websphere.wsfep.multiplatform.doc/info/ae/ae/twsu_dsource.html