• USA : +1 973 910 5725
  • INDIA: +91 905 291 3388
  • info@tekslate.com
  • Login

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:

 

 

 

 

Summary
Review Date
Reviewed Item
DB Adapter configuration-11g in Oracle SOA
Author Rating
5

“At TekSlate, we are trying to create high quality tutorials and articles, if you think any information is incorrect or want to add anything to the article, please feel free to get in touch with us at info@tekslate.com, we will update the article in 24 hours.”

0 Responses on DB Adapter configuration-11g in Oracle SOA"

    Leave a Message

    Your email address will not be published. Required fields are marked *

    Site Disclaimer, Copyright © 2016 - All Rights Reserved.

    Support


    Please leave a message and we'll get back to you soon.

    I agree to be contacted via e-mail.