Data Source

Configuring the Non-XA Data Source

To configure the non-XA data source and credentials:
1.       Go to Resources, JDBC, Data sources.
2.       For nonclustered server environments, select the same cell scope then click New.
3.       For clustered server environments, select the same cluster scope then click New.
4.       In the Data source name field, type a name for the non-XA data source, for example, ORM Non-XA Data source.
5.       In the JNDI name field, type orm/jdbc/ORMServerDS, and then click Next.
6.       Choose an existing JDBC provider and select the non-XA JDBC provider, for example, Oracle JDBC Driver, and then click Next.
7.       In the URL field, type the JDBC connection URL:
jdbc:oracle:thin:@<server>[:<port>]:<database_name>

For example:
jdbc:oracle:thin:@localhost:1521:orcl

8.       Select Oracle10g data store helper from the list, and then click Next.
9.       Click Finish.
10.   Click the name of the new non-XA data source to display details.
11.   In the Container-managed authentication alias list, select the database alias and then click Apply.
The reference to this option being deprecated can be ignored.
12.   On the same page, in the Additional Properties section, click Connection Pool Properties and set the Maximum connections to 30.
13.   Click OK.

Configuring the Transaction (XA) Data Source

To configure the XA data source:
1.       Go to Resources, JDBC, Data sources.
2.       For nonclustered server environments, select the same cell scope, then click New.
3.       For clustered server environments, select the same cluster scope, then click New.
4.       In the Data source name field, type a name for the XA data source, for example,
Datasource name- RFM XA Data source.
5.       In the JNDI name field, provide the JNDI name for the datasource, and then click Next.
6.       Choose an existing JDBC provider and select the XA JDBC provider, for example, Oracle JDBC Driver (XA), and then click Next.
7.       In the URL field, type the JDBC connection URL:
jdbc:oracle:thin:@<server>[:<port>]:<database_name>

For example:
jdbc:oracle:thin:@localhost:1521:orcl

8.       Select Oracle10g data store helper from the list, and then click Next.
Note: You must use Oracle11g data store helper for Oracle 11g database.
9.       Click Finish.
10.   Click the name of the XA data source to display details.
11.   In the Container-managed authentication alias list, select the database alias, and then click Apply.
The reference to this option being deprecated can be ignored.
12.   On the same page, in the Additional Properties section, click Connection Pool Properties and set the Maximum connections to 30.
13.   Click OK.
14.   Click Apply, and then click Save directly to master configuration.