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 eid
id
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 Online.
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]
edit
add
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