Administration SOA Suite

Adding a new database to DbAdapter the Console (Web) SOA Suite 11g

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:

Imagem

Click Deployments

Imagem

Click DbAdapter

Imagem

Click Configuration

Imagem Uans Blog

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

Imagem Uans Blog

Below the connections we already have by default:

Imagem Uans Blog

Let’s now create a new one:

Click New

Imagem Uans Blog

Select javax.resource.cci.ConnectionFactory and click Next

Imagem Uans Blog

Enter the name eis/DB/OracleXe and Finish

Imagem Uans Blog

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 ..

Imagem Uans Blog

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

Imagem Uans Blog

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

Imagem Uans Blog

After clicking Save você verá as Mensagens abaixo:

Imagem Uans Blog

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

Click Home as follows:

Imagem Uans Blog

Click Data Sources

Imagem Uans Blog

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

Imagem Uans Blog

Now fill correctly as below and click Next

Name:  OracleXE

JNDI Name: jdbc/OracleXE

Imagem Uans Blog

Click Next again

Imagem Uans Blog

Click Next again

Imagem Uans Blog

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

Imagem Uans Blog

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

Imagem Uans Blog

Now check the box below AdminServer and Finish

Imagem Uans Blog

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

 

 

Criei este Blog destinado a desenvolvedores e interessados na Tecnologia Oracle SOA Suite, minha idéia é que no futuro ele sirva de referência para Analistas e Desenvolvedores desde aprendizes a especialistas. Já existem alguns Posts interessantes que abordam um pouco do meu dia a dia, no passar do tempo irei alimentar este Blog com o máximo de informações possíveis, por isso peço por gentileza aos interessados e afins que caso tenham alguma dúvida, sugestão ou crítica que me digam para que eu possa da melhor forma suprir as expectativas e na medida do possível sanar todas as duvidas que vierem a surgir ou até mesmo criar novos Posts abordando algum tópico que venha a ser relevante para todos os interessados. Obrigado Uans Carvalho

Leave a Reply

Your email address will not be published. Required fields are marked *