Installation Guide for Oracle Self-Service E-Billing > Configuring Oracle WebLogic > Process of Configuring the Billing and Payment Application on an Oracle WebLogic Cluster >

Configuring JDBC Resources for the Billing and Payment Application on an Oracle WebLogic Cluster

You must configure the following JDBC resources for applications deployed with Oracle WebLogic, using the Oracle WebLogic Administration Console:

• Data sources
• Connection pools

This task is a step in Process of Configuring the Billing and Payment Application on an Oracle WebLogic Cluster.

Configuring the Data Sources for the Billing and Payment Application on an Oracle WebLogic Cluster

You must create the following data sources for the Billing and Payment application:

• edxAdminDataSource
• edxXMADataSource
• reportDataSource

To create the data sources for the Billing and Payment application

1. Start the newly created Billing and Payment domain, and open the Oracle WebLogic Administration Console in a browser. The default URL is:

   http://localhost:7001/console/

   where:

   • localhost is the host name of the server where you installed the Billing and Payment application. The host name can be the Domain Name System (DNS) name or the IP address, such as 10.240.12.157.
   • 7001 is the port number where you installed the Billing and Payment application.
2. Log on to the Oracle WebLogic Administration Console, using the user name and password defined when the domain was created.
3. Click the Data Sources link under JDBC in the services section.
4. Click New to create a new data source.
5. Enter the data source name and the JNDI name.
6. For each data source, select the Database Type as Oracle, and enter other settings as shown in the following table. Be sure to select the correct version of the driver for your database version, including patches. Click Next.

   Data Source Name	JNDI Name	Database and Driver	Settings	Database Details
   edxAdminDataSource	edx.databasePool	Oracle Driver (Thin)	Emulate Two-Phase Commit	OLTP/Hostname: ListenPort:SID
   edxXMADataSource	edx.xma.databasePool	Oracle Driver (Thin XA)	None	OLTP/Hostname: ListenPort:SID
   reportDataSource	edx.report.databasePool	Oracle Driver (Thin XA)	None	OLAP/Hostname: ListenPort:SID

7. Leave the default transaction options unchanged, then click Next.
8. For Connection Properties, provide the correct values.

   Connection Property	Value
   Database Name	Your Oracle Database Alias Name
   Host Name	Your Oracle Database server host name
   Port	DB server listening port
   Database User Name	Your Oracle Database User Name
   Password	Your Oracle Database Password

9. Click Next, then click Test Configuration to test whether the database connection is configured correctly.
10. Click Next. Click Finish.
11. Open each datasource and click Target. For each datasource, follow these steps:
    1. Click Summary of JDBC DataSource
    2. Select the datasource.
    3. Select the Target tab.
    4. Click the cluster name, and click Save.
12. Click Activate Changes to save the changes.
13. Repeat from Step 4 to create each remaining data source.

Configuring the Connection Pools for the Billing and Payment Application on an Oracle WebLogic Cluster

You must configure a connection pool for each data source.

To configure the connection pools for the Billing and Payment application

1. Go to the Summary of JDBC Data Sources.
2. Click any data source name link.
3. On the Connection Pool tab, enter the values for the connection pool settings for each JDBC data source you created.

   Property	Value
   Initial Capacity	5
   Maximum Capacity	20
   Capacity Increment	5
   Statement Cache Type	FIXED
   Statement Cache Size	300
   Test Connections on Reserve	Checked
   Test Frequency	120
   Test Table Name	DUAL
   Shrink Frequency	15
   Login Delay	1