Installation Guide › Installing an AIX Implementation › Install and Configure Workpoint Components on AIX/WebSphere › Configure J2C Authentication and JDBC Data Sources

Configure J2C Authentication and JDBC Data Sources

J2C authentication secures database access.

To configure J2C authentication and JDBC data sources

1. In the WebSphere administration console, click Security, Secure administration, Java Authentication and Authorization Service, J2C authentication data.
2. Create new database credentials for each of these databases:
   • Workpoint Database – alias: WPDSCreds
   • Workpoint Queues Database – alias: WPQueuesDBCred
3. Select Resources, JDBC, Data Sources. Create data sources with the following settings:
   • For the Workpoint data source:

     Name: WPDS

     JNDI Name: jdbc/WPDS

     Authentication Alias: .../WPDSCreds

     JDBC Provider: ServerProvider

   • For the Workpoint Bus Queue data source:

     Name: spBusQueueDS

     JDNI Name: jdbc/wpBusQueueDS

     Authentication Alias: .../WPQueuesDBCred

     JDBC Provider: ServerXAProvider

   Apply the following settings to all the data sources:

   • Scope: Workpoint cluster
   • Data store helper class:
     • For databases on Microsoft SQL Server:

       com.ibm.websphere.rsadapter.MicrosoftSQLServerDataStoreHelper

     • For databases on Oracle:

       Oracle 10g data store helper

   • CMP: Not selected
   • URL: (Oracle only) The URL of the database. This URL has the following format:

     jdbc:oracle:thin@Oracle_server:Port/Service_name
     

     Note: Oracle_server is the host name or IP address of the Oracle database server, Port is the port on the Oracle server, and Service_name identifies the target database.

4. Edit each of the data sources. Specify the following connection information:
   • Name: the database name you specified when you created the database.
   • Server Name: the server label or network address of the server hosting the database.
   • Port: The default port is 1433 for Microsoft SQL Server, and 1521 for Oracle.
5. Under Additional properties, Connection pool properties, set the value of the Maximum connections parameter for each data source as follows:
   • WPDS: 40
   • wpBusQueueDS: 20
6. Under Additional properties, WebSphere Application Server data source properties, set the Statement cache size to 50.
7. Click Test Connection to confirm that each data source connects to its database.
8. Restart the WebSphere Application Server or the Deployment Manager service as required in your WebSphere environment to implement the new data source definitions.