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
At TekSlate, we offer resources that help you in learning various IT courses. We avail both writtenmaterial 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 - 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
Check out the top Oracle SOA Interview Questions now!
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 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:
- 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