DB Adapter configuration-11g in Oracle SOA

Data source (jdbc.Ds):

console -2 expand server 2data source2 new v 2 generic data

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

-2[data base name / XE], [Host name / local host], [Database user name / system], [password / welcome 1], [confirm password / welcome 1] 2 next 2

test configuration 2 next2 Admin server

Osb_server1

Soa_server1

bam_server1 2finish

Connection factory: (eis.DB.Ramesh1)

Deployments2 DB Adapter2 configuration 2 outbound connection pools2 new 2 javax.resource.cci.cf 2 next 2 [JNDI name / eis.DB.Ramesh1] 2 finish

expand javax.resource.cci.connectionFactory --> eis.DB.Ramesh 12 click2[property name / XAData source name], [property value / jdbc.DS] enter 2 save

Deployments2DB Adapter2 Update 2  next 2 finish

 

DB Poll to DB Insert: 

20

 

 

Create db poll table: employee3                              DB Poll:

ename, eid, eloc, edesign, esal, depid                   1) JNDI name2 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                               '-2create

 

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;                                                                                               2 ok

 

Note:  Append to existing file

2 save the records into one file

2 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

2eid, ename, loc

2 101, ram, hyd

2 102, sai, bang

 

DB_Select:

21

 

Create Table: employee                                                               XSD:

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

101, sam, hyd, 1000                                                         o/p2 id -2int

102, sai, bang, 2000                                                      name2 string

103, teja, wgl, 3000                                                          loc 2 string

commit;                                                                               sal 2string

Assign 1:                                                                              Assign 2:

i/p 2 eid                                                                            eid2id

ename 2 name

eloc 2 loc

esal2 sal

At TekSlate, we offer resources that help you in learning various IT courses. We avail both written

material and demo video tutorials. To gain in-depth knowledge and be on par with practical

experience, then explore Oracle SOA Training Videos.

DB Select:

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

edit 2add 2parameter 2 ok              (or)

  • 8 - 10 -2parameter: select_ename

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

  • execute pure SQL

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

 

 

File poll + DB select --> DB insert:

22

 

 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 2 perform     insert only

5 0f 9 2 sample table

 

DB_select:

4 -8 2 select

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

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

 

A1:

i/p          invoke i/p DB_select

empid 2 Tempid

 

A2:

invoke o/p          db insert invoke i/p

emp id 2 empid

ename 2 ename

sal         2 sal

empid

design 2 design

loc      2 loc

  

DB_Delete: --- a) Delete 2Delete all records

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

 

23

 

XSD:

i/p                          invoke i/p

cname  -2 emp

Create DB_Delete table: customer

cname, cid, cloc

sai, 111, hyd

teja, 222, wgl

ram, 333, knr

DB_DELETE:

4 - 7 2 Execute pure SQL

5 - 7 2SQL

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

  

Transform:

cname ----> temp

24

 

DB Table: employee 111

101, hyd, ram

102, hyd2, sai

103, hyd3, teja

DB_Update:

4 -7 2Execute pure SQL

5 -7 2SQL

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

 

Assign1:

i/p 2 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:

 

25

 

 

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 2 poll for new or changed

8 - 13 2 Update a field in teh (POLL)

Table (Logical Delete)

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

 

DB insert DB select:

4 - 10 2perform

insert only

select

File write:

5 - 7 2 append to existing file

6 - 7 2 native format sample o/p file

 

Invoke2: (double click)

operation

DB_insert_selectselect

 

Transform1:

Receive2 invoke 1 i/p

Check out the top Oracle SOA Interview Questions now!

Transform2:

invoke2 o/p2invoke 3 i/p

 

String_concat:

26

 

i/p2 ramesh (First name)      reddy-2 (Last name)

 

Required O/P: Ramesh Reddy2 first letter capital

 

XSD:

i/p -2 first name 2string

last name 2string

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 2 Query & timeout 20 sec(max interval)

Get active unit of work

Ex:           get active unit of work --> account1[1000] 2 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

 

27

 

SP:

XSD:

I/p:  Bank name 2 string

Duration  2 int

O/p:  ROI  2 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”

  1. Version Tool
  2. Winscp /file Zilla
  3. VPN
  4. Putty
  5. Deployment

Version Tool: VSS/ CVS/ Clear case /SVN

  • These version tool 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 an Indepth knowledge on Oracle SOA click on: