mobileNavlogo
headerlogo

DB Adapter configuration-11g in Oracle SOA

Blog Author

Tekslate

Published Date

16th October, 2020

Ratings

Views

1074

  • Share this blog :

 

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:

  Db Poll to Insert    

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:

DB Select  

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

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

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:

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 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

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

  DB Delete  

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

DB Delete  

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:

  Logical DB    

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

Oracle SOA Interview Questions

Transform2:

invoke2 o/p2invoke 3 i/p  

String_concat:

 String concat  

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

  Loan Approval Process  

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”

  • 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:

       

About Author
Authorlogo
Name

TekSlate

Author Bio

TekSlate is the best online training provider in delivering world-class IT skills to individuals and corporates from all parts of the globe. We are proven experts in accumulating every need of an IT skills upgrade aspirant and have delivered excellent services. We aim to bring you all the essentials to learn and master new technologies in the market with our articles, blogs, and videos. Build your career success with us, enhancing most in-demand skills .

Related Blogs

Write For Us