UansCarvalho

~ Blog for Oracle SOA Developers

UansCarvalho

Tag Archives: DBAdapter

Record XML Content in the Database for BPEL

07 Tuesday Jun 2016

Posted by Uans in BPEL

≈ Leave a comment

Tags

BPEL, DBAdapter, XML

In this article I will show how we can record an XML content using DbAdapter BPEL.

Below is a table Describe Command to display the details and field where I will perform the Insert XML

Continue reading →

Inserting data using the Database Adapter (BPEL DbAdapter) Oracle SOA Suite 11g

07 Tuesday Apr 2015

Posted by Uans in BPEL

≈ 2 Comments

Tags

11G, BPEL, Console, Database Adapter, DBAdapter, Deploy, Deployment, Developer, INSERT, JDeveloper, Oracle, SOA, Soa-Suite

In a previous post I showed how to perform a Select in the database using the DbAdapter component of BPEL, now hold a very similar process but performing an Insert In this example we will receive three parameters of our service for inserting the necessary information to register a new department in our table departments.

Continue reading →

Exposing a Service in Oracle Service Bus (OSB) – Published on OTN

02 Thursday Apr 2015

Posted by Uans in OSB, OTN

≈ 2 Comments

Tags

11G, ALSB, Aqualogic, BPEL, bus, Business, DBAdapter, EM, JDeveloper, Oracle, OSB, Proxy, Service Bus, SOA, Soa-Suite, workspace

To view this article by direct Oracle site see the link:

http://www.oracle.com/technetwork/pt/articles/soa/expondo-servico-oracle-service-bus-2507899-ptb.html

Or just follow the article as follows:

Oracle Service Bus or simply OSB, a very common error regarding OSB is to say that it “implements” SOA or the fact of using a OSB in its architecture already turns into a Service-Oriented Architecture. In fact, the OSB is responsible for much of the features that SOA fold, but not all.

Continue reading →

Selecting data using the Database Adapter (BPEL DbAdapter) Oracle SOA Suite 11g

08 Thursday Jan 2015

Posted by Uans in BPEL

≈ 6 Comments

Tags

11G, BPEL, DataBase, Database Adapter, DBAdapter, Deployment, EM, INSERT, JDeveloper, Oracle, SELECT, SOA, Soa-Suite, UPDATE, XML

Oracle Database Adapter enables Oracle SOA Suite to communicate with the database, including Oracle database servers, and any relational databases that follow the ANSI SQL standard and provide JDBC drivers, performing SELECT operations, UPDATE and INSERT using an adapter configuration wizard, where the inputs / outputs are XML, easily seen as input parameters and and results converted into XML.

In this article on the Database Adapter (DbAdapter) BPEL we select some data from a database table and show in the screen Enterprise Manager  (EM)

Continue reading →

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

04 Sunday Jan 2015

Posted by Uans in Administration SOA Suite

≈ Leave a comment

Tags

11G, AdminServer, BPEL, Console, DataBase, Database Adapter, DBAdapter, Domain, SOA, Soa-Suite

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 🙂 Continue reading →

Saving an attachment in the database with the BPEL

23 Tuesday Dec 2014

Posted by Uans in BPEL

≈ Leave a comment

Tags

Attachments, BPEL, DBAdapter, Deploy, EM, invoke, JDeveloper, MIME, Oracle, Payload, SOAPUI, Submit

A BPEL process can receive an attachment (Attachment) MIME along with a Payload. The attachment can be in any format (for example, DOC, PDF, JPEG, XML, text, and so forth).

Let this first time send a JPEG file type to BPEL and burn it to a database by using the tool ora:getAttachmentContent BPEL

Continue reading →

Uanderson Carvalho

Engenheiro de sistemas, especialista de integração entre sistemas, Pós-graduado em Administração de Banco de Dados Oracle. Certificado pela Oracle como: Oracle SOA Suite 11g Certified Implementation Specialist

Blog Recognized by

Search

  • Trabalhando com Attachment in OSB 11g
  • Expondo um Serviço Rest no OSB – Parte 2: Transformando Xml em Json Java
  • Exposing a Rest Service on OSB – Part 1: Creating a Rest API

Categories

  • Administration SOA Suite (7)
  • BPEL (28)
  • Events (3)
  • Installing SOA Suite 11g (10)
  • Installing SOA Suite 12c (6)
  • Java (2)
  • Linux (2)
  • OSB (15)
  • OTN (11)
  • ProfessionalsOracle (1)
  • TiSpecialists (1)

Tags

11G AdminServer ALSB Aqualogic BPEL bus bus Business Composer Concatenação Console DataBase Database Adapter DBAdapter Deploy Deployment Developer Domain DVM EM Fila FileAdapter Java Java Message Service JDeveloper JMS Linux loop MDS Mensagem Oracle OSB Proxy Script Server Service Bus SOA Soa-Suite SUDO Ubuntu WebLogic WSDL XE XE XML
March 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Sep    

New Posts

  • Trabalhando com Attachment in OSB 11g
  • Expondo um Serviço Rest no OSB – Parte 2: Transformando Xml em Json Java
  • Exposing a Rest Service on OSB – Part 1: Creating a Rest API
  • Instalalling Oracle SOA Suite 12c – Parte 7: Oracle JDeveloper
  • Installing Oracle SOA Suite 12c – Part 6: Configuring o Domain
  • Installing Oracle SOA Suite 12c – Part 5: SOA Developer Domain
  • Installing Oracle SOA Suite 12c – Part 4: Repository Creation Utility (RCU)
  • Installing Oracle SOA Suite 12c – Part 3: SOA Suite 12.2.1.2.0
  • Installing Oracle SOA Suite 12c – Part 2: Java SE Development Kit 8 – JDK
  • Installing Oracle SOA Suite 12c – Part 1: Oracle Database 11g XE

Todos os Posts

  • December 2020 (1)
  • March 2020 (1)
  • February 2019 (1)
  • November 2016 (2)
  • October 2016 (5)
  • September 2016 (1)
  • June 2016 (1)
  • March 2016 (3)
  • February 2016 (2)
  • December 2015 (1)
  • November 2015 (1)
  • September 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (6)
  • May 2015 (5)
  • April 2015 (7)
  • March 2015 (8)
  • February 2015 (7)
  • January 2015 (7)
  • December 2014 (6)

Links

  • OTN – Oracle Technology Network
  • Oracle Blogs
  • Oracle Technical Articles
  • Oracle Docs
  • Oracle Downloads
  • Oracle Performance Tunning
  • Soa Community
  • TI Especialistas
  • VrsBrazil
  • Leo’s blog
  • Blog Waslley Souza
  • Victor Jabur’s Blog
  • Blog do DBA/Instrutor Fábio Prado
  • Cicero Ednilson Blog

" Não seja melhor do que as outras pessoas, seja melhor para as outras pessoas !!! "

Uanderson Carvalho

Engenheiro de sistemas, especialista de integração entre sistemas, Pós-graduado em Administração de Banco de Dados Oracle. Certificado pela Oracle como: Oracle SOA Suite 11g Certified Implementation Specialist

Blog Recognized by

Categories

  • Administration SOA Suite (7)
  • BPEL (28)
  • Events (3)
  • Installing SOA Suite 11g (10)
  • Installing SOA Suite 12c (6)
  • Java (2)
  • Linux (2)
  • OSB (15)
  • OTN (11)
  • ProfessionalsOracle (1)
  • TiSpecialists (1)

Tags

11G AdminServer ALSB Aqualogic BPEL bus bus Business Composer Concatenação Console DataBase Database Adapter DBAdapter Deploy Deployment Developer Domain DVM EM Fila FileAdapter Java Java Message Service JDeveloper JMS Linux loop MDS Mensagem Oracle OSB Proxy Script Server Service Bus SOA Soa-Suite SUDO Ubuntu WebLogic WSDL XE XE XML
March 2026
M T W T F S S
 1
2345678
9101112131415
16171819202122
23242526272829
3031  
« Sep    

New Posts

  • Trabalhando com Attachment in OSB 11g
  • Expondo um Serviço Rest no OSB – Parte 2: Transformando Xml em Json Java
  • Exposing a Rest Service on OSB – Part 1: Creating a Rest API
  • Instalalling Oracle SOA Suite 12c – Parte 7: Oracle JDeveloper
  • Installing Oracle SOA Suite 12c – Part 6: Configuring o Domain
  • Installing Oracle SOA Suite 12c – Part 5: SOA Developer Domain
  • Installing Oracle SOA Suite 12c – Part 4: Repository Creation Utility (RCU)
  • Installing Oracle SOA Suite 12c – Part 3: SOA Suite 12.2.1.2.0
  • Installing Oracle SOA Suite 12c – Part 2: Java SE Development Kit 8 – JDK
  • Installing Oracle SOA Suite 12c – Part 1: Oracle Database 11g XE

Todos os Posts

  • December 2020 (1)
  • March 2020 (1)
  • February 2019 (1)
  • November 2016 (2)
  • October 2016 (5)
  • September 2016 (1)
  • June 2016 (1)
  • March 2016 (3)
  • February 2016 (2)
  • December 2015 (1)
  • November 2015 (1)
  • September 2015 (2)
  • August 2015 (2)
  • July 2015 (4)
  • June 2015 (6)
  • May 2015 (5)
  • April 2015 (7)
  • March 2015 (8)
  • February 2015 (7)
  • January 2015 (7)
  • December 2014 (6)

Links

  • OTN – Oracle Technology Network
  • Oracle Blogs
  • Oracle Technical Articles
  • Oracle Docs
  • Oracle Downloads
  • Oracle Performance Tunning
  • Soa Community
  • TI Especialistas
  • VrsBrazil
  • Leo’s blog
  • Blog Waslley Souza
  • Victor Jabur’s Blog
  • Blog do DBA/Instrutor Fábio Prado
  • Cicero Ednilson Blog

" Não seja melhor do que as outras pessoas, seja melhor para as outras pessoas !!! "

Search

Recent Posts

  • Trabalhando com Attachment in OSB 11g
  • Expondo um Serviço Rest no OSB – Parte 2: Transformando Xml em Json Java
  • Exposing a Rest Service on OSB – Part 1: Creating a Rest API
  • Instalalling Oracle SOA Suite 12c – Parte 7: Oracle JDeveloper
  • Installing Oracle SOA Suite 12c – Part 6: Configuring o Domain

Engenheiro de sistemas, especialista de integração entre sistemas, Pós-graduado em Administração de Banco de Dados Oracle. Certificado pela Oracle como: Oracle SOA Suite 11g Certified Implementation Specialist

As opiniões expressas neste blog são de minha autoria e não refletem as opiniões da empresa que trabalho ou trabalhei. As informações contidas neste blog são escritas com base em experiências pessoais. Você é livre para usar a informação deste blog, mas eu não sou responsável, não me responsabilizo e não vou compensá-lo se acontecer alguma inconveniência ao fazer uso desta informação .