Configuring JDBC Data Sources

Perform the following steps to configure JDBC Data Sources:

Create a New JDBC Data Source.
In WebLogic Adminstration Console, go to mydomain > Services > Data Sources.
Select New > Generic Data Source.
Enter the values as shown in the following table:
Field Name
Values
Comments
Name
JDBC Data Source-0
Name of the JDBC data source
JNDI Name
ModelHouseCT

Database Type
Oracle
Click Next.
Select values for the fields as mentioned in the following table:
Field Name
Values
Comments
Database Driver
*Oracle's Driver (Thin) for Service Connections; Versions: Any
Click Next and select the Emulate Two-Phase Commit radio button.
Click Next to configure the Connection Properties.

Enter the values as mentioned in the following table:

Field Name	Sample Values	Comments
Database Name	Database / SID name: SIR08875	Database name in which the DB schema for CT is created.
Host Name	IP Address / Host name: 10.10.16.211	The value is the Hostname / IP address of the Database server.
Port	Port Number: 1521	The port number allocated for the Database communication for the IP / host name.
Database User Name	DB Schema Name: CT_MODEL_HOUSE	Database schema name that is created for CT.
Password DB	Schema password: ****************	Database schema password for CT.
Confirm Password	DB Schema password: ****************	Database schema password for CT.

Click Next.
Click Test configuration to test the database availability and the connection properties that you have provided.

Once the test is successful, the following message will appear:
Click Next to select the Target server.
Select the required target server. Here, AdminServer is chosen as an example.
After verifying the changes, click Finish.