Mediator Vs Oracle Service Bus (OSB) in Oracle SOA Suite

In this post i am going to clear the basic difference between Mediator and Oracle Service bus. There is always some confusion between these two for new comers. Both of these components can be used for mediation purpose.  Both mediator and Oracle Service bus can perform Interface and data mapping, filtering and routing etc but the scope of both these components are different. For Intra-composite mediation i.e connection of components within a give composite we use Mediator Component while for Inter-composite mediation we use Oracle...

Read More

IO Error: Connection reset by peer: socket write error, Connection Closed SQL Developer

From couple of days i was facing IO Error: Connection reset by peer: socket write error, Connection Closed  in my SQL Developer. I connected with Remote server DB. After wasting much of time i got the solution, Now i am sharing it, if it could save time of who is facing this issue. I hope it would resolve the issue.  The problem was due to Proxy, I was using Proxy for internet access but i did not used this proxy in SQL Developer. You should give proxy and must restart  your SQL Developer if you are using Proxy.  To...

Read More

Calling BPEL Process using Database Adapter, Automatically Invoking BPEL Process

In this post i will show how we can call BPEL Process using DB Adapter. This post is a second part of my Previous post http://technasir.blogspot.com/2013/10/polling-in-oracle-soa-database-adapter.html . I will continue from previous post. I suppose you have created DB Adapter as i did in my previous post. Your requirement could be different, but scenario could match. 1) After creating DB Adapter your composite will look like this which...

Read More

Polling in Oracle SOA Database Adapter

A very useful feature of Oracle data base adapter is polling. It tell us about any changes in particular table on which we want to poll. Using this feature we can do lot of things according to our logic and our requirement. I will split this post in two part 1) How to Configure DB Adapter for Polling 2) How to Invoke BPEL Process using DB Adapter, or Automatically Steps to configure polling in SOA DB Adapter 1) Drag and Drop a Database Adapter...

Read More

Create Sequence in SQL Oracle, Create Trigger on Insert and Update in Oracle

Sequence in Oracle SQL. Following is the basic code to create a sequence in Oracle SQL CREATE SEQUENCE sequence_name START WITH 1 INCREMENT BY 1 MAXVALUE 99999999 MINVALUE 1 NOCYCLE; Trigger on insert and update on any table  Following code can be used to create a trigger on any table, It will invoke and do what you want when any value will get inserted and update in table create or replace trigger trigger_name before insert OR update on table for each row begin write you logic here what should happen when trigger gets invoke. en...

Read More

Mater Detail Relationship In DB Adapter BPEL. 1 to M Relationship

In this post i will show how to create a Parent child relationship in Database Adapter. Create a new SOA Application in your JDeveloper with Empty Composite. Now follow these steps to configure a DB Adapter by using Parent child relationship 1) Drag and Drop a DB Adapter in External References and give its name. 2) Click next and create a DB Connection and set your JNDI name according to your Weblogic server configured JNDI name for this DB 3)...

Read More

Oracle SOA Suite 11g Installation, Maintenance, Purging, Performance tuning, troubleshooting and Administration

I found very useful guide from Oracle which covers Oracle Fusion Middleware, Specially About Oracle SOA Server. It covers everything that we should know about Oracle SOA suite. Following are some main points of this document.  1) Installation of Oracle SOA Suite and Schema's  2) Upgrade of Oracle SOA Suite   3) Administration of Oracle SOA Suite 4) Performance tuning of Oracle SOA Suite 5) Purging techniques in Oracle SOA, Fusion Middleware, Step by Step Purging guide 6) Troubleshooting of Oracle SOA Infrastructure  Document...

Read More

Oracle Database 12C and some of its features. Database 12c and Cloud Computing

Oracle Database 12c released with new and interesting features. Oracle is saying that it is a multitenant database for the cloud. Oracle continuously improving and enhancing its products and technologies to fulfill the customer requirements. Oracle provide a new architecture for its database for cloud called Oracle multitenant.     According to  Oracle President Mark Hurd                      “Just as virtualization lets you turn a physical          ...

Read More

Integration of Oracle EBS with Siebel CRM, Mediator in Oracle BPEL, Integration of Two DBs

In this post i will show how to use Mediator in BPEL Process and Transformation of attributes. This post is part of my previous posts series. You should also go through previous posts to fully understand the scenario. Here is the link of previous post                              Inserting data using DB Adapter  lets start on Mediator and Transformation in BPEL Process. 1)...

Read More

Inserting data using DB Adapter in BPEL SOA Suite

In this Post i am going to show how to insert data using DB Adapter in SOA Suite. This is a integration of Oracle Apps with Siebel CRM. First i will show you how to configure DB Adapter to insert data in it. I have two tables master and detail. I will show you only master table insertion wizard, however this can be done in combine as well. You can also create relationship between table in DB Adapter but i am not going into much detail. Please...

Read More

Store Procedure invocation using BPEL Process in SOA Suite

In this post i will show you how to call and get Data using DB Adapter that we have developed previous post. You can check it out here Store Procedure with Out Parameter. In this Post we will develop a BPEL Process to Invoke this stored Procedure. 1) Drag and Drop a BPEL Process in component section. Following snaps shows how to do it. In input parameter select input parameter from XSD that is generated by your DB Adapter.  2) For...

Read More