DB Adapter configuration-11g in Oracle SOA

Data source (jdbc.Ds):

console - expand server data source new v  generic data

source  [name / DS], [JNDI name / jdbc.DS]  next  next next

-[data base name / XE], [Host name / local host], [Database user name / system], [password /

welcome 1], [confirm password / welcome 1]  next

  test configuration  next Admin server

Osb_server1

Soa_server1

bam_server1 finish

Connection factory: (eis.DB.Ramesh1)

Deployments DB Adapter configuration  outbound connection pools new

 javax.resource.cci.cf  next  [JNDI name / eis.DB.Ramesh1]  finish

expand javax.resource.cci.connectionFactory --> eis.DB.Ramesh 1 click[property name /

XAData source name], [property value / jdbc.DS] enter  save

DeploymentsDB Adapter Update   next  finish  

DB Poll to DB Insert:

     

Create db poll table: employee3                              DB Poll:

ename, eid, eloc, edesign, esal, depid                   1) JNDI name eis.DB.break

Ram , 101, hyd,    SSE  , 200000,  1                          2) poll for new or changed

Sai   , 102, Bng,    TL    , 300000,  2                           3) polling frequency 10 sec

teja   , 103, Egl ,    SE    , 500000,  3                               '-create  

Create db polltable(2): Department 3

Depid,  Dname                                                                  [parent / employee3], [child / department3]

1     consultancy

2       sales                                                                         parent table

3       dept                                                                         private owned

Create DB insert: employee details                         employee3         department3

ename, eid, eloc, edesign, esal, Depid, dname   DEPID                    DEPID

commit;                                                                                                ok  

Note:  Append to existing file

 save the records into one file

 save the records one by one multiple files.

Ex1: o/p folder

eid, name, loc

101, ram, hyd

102, sai, Bang

Ex2: o/p folder

eid, ename, loc

 101, ram, hyd

 102, sai, bang

DB_Select:

 

Create Table: employee                                                               XSD:

eid, ename, eloc, esal                                                       i/p - id  int

101, sam, hyd, 1000                                                         o/p id -int

102, sai, bang, 2000                                                         name string

103, teja, wgl, 3000                                                          loc  string

commit;                                                                               sal string

Assign 1:                                                                              Assign 2:

i/p  eid                                                                            eidid

ename  name

eloc  loc

esal sal

Inclined to build a profession as Oracle SOA Developer? 
Then here is the blog post on Oracle SOA Training.

DB Select:

• 4 - 10 perform  select
• 8 - 10  parameter / ccno,

edit add parameter  ok              (or)

• 8 - 10 -parameter: select_ename

sql: SELECT ENAME, ELOC, ESAL, eid FROM EMPLOYEE WHERE (EMPID = #ccno)

• execute pure SQL

0 - 10SQL: SELECT * FROM EMPLOYEE WHERE (EMPID=#ccno)

File poll + DB select --> DB insert:

   

File poll:                                                        

emp id, ename, sal

101, Ram, 100000

102, Reddy, 200000

-> DB_insert table:                                        

emp id, ename, sal, design, loc

commit;      

DB_select table:

emp id, design, loc

101, SE, hyd

102, SSE, bang

commit;  

DB_insert:

4 of 9  perform     insert only

5 0f 9  sample table  

DB_select:

4 -8  select

8 - 10 [parameters / ccno]  editadd  parameter ok           (or)

select * from employee where (empid = ----)  

A1:

i/p          invoke i/p DB_select

empid  Tempid  

A2:

invoke o/p          db insert invoke i/p

emp id  empid

ename  ename

sal          sal

empid

design  design

loc       loc   

DB_Delete: 

a) Delete Delete all records

b) Execute pure SQL  delete selected records into the file.

   

XSD:

i/p                          invoke i/p

cname  - emp

Create DB_Delete table: customer

cname, cid, cloc

sai, 111, hyd

teja, 222, wgl

ram, 333, knr

DB_DELETE:

4 - 7  Execute pure SQL

5 - 7 SQL

delete from customer (table name) where cname(record) = #temp   

Transform:

cname ----> temp

 

DB Table: employee 111

101, hyd, ram

102, hyd2, sai

103, hyd3, teja

DB_Update:

4 -7 Execute pure SQL

5 -7 SQL

Update employee 111 set ename=?, eloc=?, where eno=# teno  

Assign1:

i/p  invoke i/p  

Assign2:

"success"    

Testing:                                                o/p

i/p                                                101   hyd   ram             {

101 bang don                           102   hyd2  sai

103   hyd3   teja                           changed

101   bang   don           }    

Logical DB_delete, insert, select, File_write:

     

db pollins:

create employee4 table:

eid, ename, eloc, flag

100, ram, hyd, N

101, sam, wgl, N

102, sai, knr, Y

db insert, db select:

create master table4:

id, name, loc

103, aaa, xxx

104, bbb, yyy

105, ccc, zzz

DB poll adapter:

4 - 13  poll for new or changed

8 - 13  Update a field in teh (POLL)

Table (Logical Delete)

9 - 13 [logical delete field/flag], [red value/Y], [Unread value/N]  

DB insert DB select:

4 - 10 perform

insert only

select

File write:

5 - 7  append to existing file

6 - 7  native format sample o/p file  

Invoke2: (double click)

operation

DB_insert_selectselect  

Transform1:

Receive invoke 1 i/p

Oracle SOA Interview Questions

Transform2:

invoke2 o/pinvoke 3 i/p  

String_concat:

   

i/p ramesh (First name)      reddy- (Last name)  

Required O/P: Ramesh Reddy first letter capital  

XSD:

i/p - first name string

last name string

Assign:

concat(upper_case(substring(firstname), 1 ,1)), substring(first name), 2, ' ', upper_case(substring(last name), 1, 1)), substring(last name), 2))

Note: Drag the expression to result (right handside)               

DB_select

9 - 10  Query & timeout 20 sec(max interval)

Get active unit of work

Ex:           get active unit of work --> account1[1000]  account2[1000]

• If the account transactions will get problem then the amount back to account1.

Bank      ROI         Month

ICICI       10%        24

HDFC     9%          18  

loan approval process

   

SP:

XSD:

I/p:  Bank name  string

Duration   int

O/p:  ROI   float

S.R:

XSD:

I/p:  Bank name   -> string

Duration  -> int

O/p:  Result   -> float

Transform 1:

Right side ROI

Right-click on ROI

Element = 10

Transform 2:

Right side ROI

Right-click on ROI

Element = 10

Transform  3:

i/p: invoke i/p variable

Transform 4:

o/p: invoke o/p

Switch

Case 1:

Label ->  ICICI

Condition:

Bank name =” ICICI”

Case 2:

Label ->  HDFC

Condition:

Bank name =” HDFC”

• Version Tool
• Winscp /file Zilla
• VPN
• Putty
• Deployment

Version Tool: VSS/ CVS/ Clear case /SVN

• These version tools are using for check-in/out
• History

Win SCP/File Zilla:

The win SCP/file Zilla using for moving files from server to local machine (or) local machine to server

VPN:

It’s using for connecting to the client

Putty:

All  the server accessing (remote system access  -> to access Linux (or)Unix)

Deployment:

Deploy the projects

For in-depth knowledge on Oracle SOA click on:

• Oracle service bus in SOA
• Oracle SOA Business rule engine
• Java messaging service in Oracle SOA 11g
• Oracle 11g installation step by step process
• How to work with FTP(File transfer protocol) in Oracle SOA