How to create DB DataSource and JNDI Name

Why to Create DataSource and JNDI Name:- JNDI name is the referenece to the repository or registry where the database connection detail and physical server address is present.

How to Create DataSource and JNDI Name:- To create a data source:

1. Navigate to http://servername:portnumber/console.

2. Use the required credentials to open the Home page.

3. Under Domain Structure, select Services then click Data Sources.

The Summary of JDBC Data Sources page is displayed.

4. Click New and then Generic Data Store. The Create a New JDBC Data Source page is displayed.

5. Enter the following values for the properties to be used to identify your new JDBC

data source: ■ Name: demoDatabase■ JNDI Name: jdbc/demoDatabase■ Database Type: Oracle   

            

6. Retain the default value for Database driver in next  page

7. Click Next. The Create a New JDBC Data Source Transaction Options page is

displayed.

8. Click Next. The Create a New JDBC Data Source Connection Properties page is

displayed. Enter the database  connection properties in the Connection Properties page, and then click

Next.

The Create a New JDBC Data Source Test Database Connection page is displayed.

9. Click Test Configuration to test the database availability and the connection

properties you provided. A message stating that the Connection test succeeded is

displayed at the top of the Create a New JDBC Data Source Test Database

Connection page.

10. Click Next. The Create a New JDBC Data Source Select Targets page is displayed.

11. Select a target, and then click Finish. You have created a data source.

The Summary of JDBC Data Sources page is displayed. This page summarizes the

All changes have been activated. No restarted required for the changes to take effect

Creating a Connection Pool:-

1. Under Domain Structure, click Deployments.The Summary of Deployments page is displayed.

2. Click the DbAdapter name from the Deployments list.

The Settings for DbAdapter  page is displayed.

3. Click Configuration tab, and then click Outbound Connection Pools tab.

The Outbound Connection Pool Configuration Table is displayed.

4. Click New.

5. Select javax.resource.cci.ConnectionFactory, and then click Next.

The Create a New Outbound Connection page is displayed.

6. In the JNDI Name: field, enter eis/DB/demoDatabase. Then click Finish.

The JNDI name specified in this step must match the value with database connection that need to create in jDeveloper.

7. Click on the newly created OutboundConnection.In the Properties field, enter the value for xADataSourceName as jdbc/demoDatabase which was created previously. press Enter in the

keyboard to save the changes.

8 Under Domain Structure, click Deployments.The Summary of Deployments is displayed.

9 Do either of the following steps:

a. Select the DbAdapter check box, and then click Update.The Update Application Assistant page is displayed.

b. Select Redeploy this application, and then click Finish.

Adding  a new value for the outbound connection pool, then no re-start required for the Managed server or the Admin server. However, editing is done on any property of an existing connection pool, then re-start of the server  is required