Preparing Data Source

About this task
Start WebSphere® Application Server v6.1 and configure WebSphere for Cash Drawer Management Service.
  1. In Servers view of the Rational® Software Development platform, select the WebSphere Application Server v6.1 and click the the start icon to start server. Following is the screen capture of the start view:

    screen capture of the start view

  2. Right-click the WebSphere Application Server v6.1 and select Run administrative console.
  3. Configure JDBC Library Path.

    Select Environment > WebSphere Variables. Update the variableDB2UNIVERSAL_JDBC_DRIVER_PATH and DB2_JDBC_DRIVER_PATH with the DB2® lib path, for example “C:\Program Files\IBM\SQLLIB\java”. Following is the screen capture of updating variable:

    screen capture of updating variable

    Click OK to confirm the changes, and click Save to save the changes.

  4. Create JDBC Providers.
    1. Click Resources > JDBC Providers. All the database providers are listed here. Following is the screen capture of JDBC providers:

      screen capture of JDBC providers

    2. Click New to create a new JDBC Provider. In the new page, select DB2 as Database type; select DB2 Universal JDBC Driver Provider as Provider type; select XA data source as Implementation type; fill the Name with FX-DB2-XA-JDBCProvider. Following is a screen capture of creating a new JDBC Provider:

      screen capture of creating a new JDBC Provider

    3. Go to Step 3, click OK to save the changes.
  5. Create Data Source.
    1. Click Resources > JDBC Providers > FX-DB2-XA-JDBCProvider in this JDBC providers Configuration view. In the Additional Properties section, there is Data sources link. Following is the screen capture of configuration:

      screen capture of configuration

    2. Click the Data sources. All data sources are listed in this new page. Following is the screen capture of data sources:

      screen capture of data sources

    3. Click New to create a new data source. In the new page, fill the Data source name with FXDataSource, fill the JNDI name with jndi/FXDB. Following is the screen capture of data source information:

      screen capture of data source information

    4. Click Create a new J2C authentication alias to create J2C authentication. Following is the screen capture of creating a new J2C authentication alias:

      screen capture of creating a new J2C authentication alias

    5. Select new created FXAuthenticate as the J2C authentication data entries. Following is the screen capture of J2C authentication data entries:

      screen capture of J2C authentication data entries

    6. Fill the Database name, and Server name as “localhost” as in the example as follows:

      screen capture of specific properties for the data source

      Click Next > OK to save the changes.