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