Set up the XA Database Driver DataSources

About this task

The following steps should be repeated twice, substituting <DatasourceName> (without the angle brackets) with thecuramdb and thencuramsibdb.

Procedure

Select theOracle JDBC Driver (XA) now displayed on the list of existing providers. This will open the configuration screen again;
Select the Data sources link under Additional Properties;
Click New to add a new data source;
Set the fields as follows:
Data source name : <DatasourceName>

JNDI Name : jdbc/<DatasourceName>

Click Next;
Set the URL Value field to:
jdbc:oracle:thin:@//serverName:port/databaseServiceName, to connect to database using Oracle service name.

or

jdbc:oracle:thin:@serverName:port:databaseName, to connect to database using Oracle SID name.

Where,

serverName is the name of the server hosting the database;

port is the port number the database is listening on;

databaseName is the SID of the database; and

databaseServiceName is the service name of the database.

Set the Data store helper class name to be Oracle 11g data store helper;

Leave all other fields untouched unless a specific change is required and click Next;

Note: Oracle recommends using the URL format jdbc:oracle:thin:/@//serverName:port/databaseServiceName to connect to Oracle database using service name. But this URL format(extra '/' before the '@' in the URL) is not supported by the WebSphere Application Server admin console. So, the Oracle service name URL described above (without extra '/' before the '@' in the URL) should be used while configuring Oracle data source from admin console, to connect to Oracle database using service name.
Set the Authentication alias for XA recovery : <valid for database>
Set the Component-managed authentication alias drop down value to: <valid for database>;

where the <valid for database> alias used is the one set up in Creating the Data Source Login Alias;

Leave all other fields untouched unless a specific change is required and click Next;
Click Finish to confirm the changes and continue.