Installation Guide for Oracle Self-Service E-Billing > Configuring Oracle WebLogic > Process of Configuring Oracle WebLogic for the Billing and Payment Application >
Configuring JDBC Resources for the Billing and Payment Application
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 Oracle WebLogic for the Billing and Payment Application. Configuring the Data Sources for the Billing and Payment Application
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
- Start the newly created Billing and Payment domain, and open the Oracle WebLogic Administration Console in a browser. The default URL is
http:// Server_Name : Server_Port /console
where:
- Server_Name is the name of the server with the Billing and Payment domain.
- Server_Port is the port number of the Billing and Payment domain server.
- Log on to the Oracle WebLogic Administration Console using the user name and password defined when the domain was created.
- Click Lock and Edit to allow you to make configuration changes.
- Click the Data Sources link under JDBC in the services section.
- Click New to create a new data source.
- Enter the data source name and the JNDI name.
- 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.
|
|
|
|
edxAdminDataSource |
edx.databasePool |
Oracle/Driver (Thin XA) |
OLTP/Hostname:ListenPort:SID |
edxXMADataSource |
edx.xma.databasePool |
Oracle/Driver (Thin XA) |
OLTP/Hostname:ListenPort:SID |
reportDataSource |
edx.report.databasePool |
Oracle/Driver (Thin XA) |
OLAP/Hostname:ListenPort:SID |
- Leave the default transaction options unchanged, then click Next.
- For Connection Properties, provide the correct values.
|
|
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 |
- Click Next, then click Test Configuration to test whether the database connection is configured correctly.
- Click Next, then target the data source to the server where you want to deploy the application. The default is AdminServer. Click Finish.
- Click Activate Changes to commit the changes.
- Repeat from Step 5 to create each remaining data source.
Configuring the Connection Pools for the Billing and Payment Application
You must configure a connection pool for each data source. To configure the connection pools for the Billing and Payment application
- Go to the Summary of JDBC Data Sources.
- Click any data source name link.
- On the Connection Pool tab, enter the values for the connection pool settings for each JDBC data source you created.
|
|
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 |
|