When we installed the SOA Suite 11g Package in our machine by default you have set up a database to access the database, but if you need to add a different basis, for another database, how should we proceed? Below I explain in detail how to do it 🙂

In order to use the JDeveloper Database component Adapter (DBAdapter) to hold an event in our database, but is necessary to have our DbAdapter also set in our Console (Web) that will be responsible for making the necessary connection to the base source data.

In your browser go to the address http://localhost:10000/console

Note: The port 10000 is the number that I chose to create my Domain.

Login:

Click Deployments

Click DbAdapter

Click Configuration

Click Outbound Connection Pools and then click the    beside javax.resource.cci.ConnectionFactory

Below the connections we already have by default:

Let’s now create a new one:

Click New

Select javax.resource.cci.ConnectionFactory and click Next

Enter the name eis/DB/OracleXe and Finish

Below that we’ve set our DbAdapter with entrance to the new database, if our Oracle XE.

The name eis/DB/ is a standard already adopted by the Oracle, see that he already puts this “prefix“ in other bases ..

Now click eis/DB/OracleXe you will see the screen below, see that in XADataSourceName line in the Property Value column is white.

Click inside this blank and place the value jdbc/OracleXE and click Save, then we must have the following screen:

After clicking Save você verá as Mensagens abaixo:

Everything OK, now let’s create the connection settings with our Base:

Click Home as follows:

Click Data Sources

On the Configuration tab click on New >> Generic Data Source

Now fill correctly as below and click Next

Name:  OracleXE

JNDI Name: jdbc/OracleXE

Click Next again

Click Next again

Below we put the connection properties related to our database, after that click Next

Note: In my case, I am putting my property from my Oracle XE database

Click Test Configuration and if you see the message Connection test succeeded his connection is OK  🙂

Now check the box below AdminServer and Finish

There, your new connection to your new database was set up successfully.

Restart your Domain so that your new settings take effect

You can now create such a new DbAdapter in JDeveloper pointing to this new basis.

 

Hugs and to the Next

/:-D