Step-by-Step guide on creating a DB adapter in Oracle WebLogic Server

Step 1: Login to Oracle WebLogic Server Console

Open a web browser and navigate to the Oracle WebLogic Server Console URL.
Log in using your credentials.


Step 2: Accessing the Resource Adapter Configuration

Once logged in, navigate to the domain's home page in the WebLogic Server Console.
Click on the "Deployments" link under the "Domain Structure" section.
Search for the "eis/DB" entry and click on it.

Step 3: Configuring the DB Adapter

On the "eis/DB" page, click on the "Configuration" tab.
Click the "Outbound Connection Pools" link.

Step 4: Creating an Outbound Connection Pool

Click the "New" button to create a new outbound connection pool.
Fill in the required details, such as Name, JNDI Name, and Database Driver.
Configure the necessary properties, including database URL, username, password, and any additional connection properties.
Click "Save."

Step 5: Configuring Connection Factory

Click the "Connection Factories" link.
Click the "New" button to create a new connection factory.
Provide a name and JNDI name for the connection factory.
Select the previously created connection pool from the "Connection Pool" dropdown.
Click "Save."

Step 6: Configuring Database Adapter

Navigate back to the "Deployments" page.
Click on the "eis/DB" link.
Click the "Configuration" tab.
Click the "Outbound Resource Adapter Properties" link.

Step 7: Configuring Database Properties

In the "Configuration: eis/DB" page, click the "Connection" tab.
Configure the properties such as DataSource, JNDI Name, and Transaction Support.
Select the connection factory created in Step 5.
Click "Save."

Step 8: Activating Changes

On the "Configuration: eis/DB" page, click the "Activate Changes" button to apply the configuration changes.

If you like please follow and comment