on 08-20-2009 4:44 AM
can I define multiple query statments in sender jdbc adapter?
because i wanna get multiple recordsets from database according to multiple querty statements.
like:
<recordset1>
<row>
<col1>
<col1/>
<col2>
<col2/>
<row/>
<recordset1/>
<recordset2>
<row>
<col1>
<col1/>
<col2>
<col2/>
<col3>
<col3/>
<col4>
<col4/>
<row/>
<recordset2/>
such as: order and order item scenario.
in general,how to implement the scenario?
i have to make use of BPM to resolve the problem?
ple give some hint and stuff about this. thanks a lot!!!
i checked so many stuffs for this.
it seems to be inpossible to fetch multiple resultsets from sender jdbc adapter at one polling..
but there are 3 way to resolve the issue.
1. with bpm.
2. with join query,but there will be reoundant data.
3. with mapping lookup during mapping. at first, to query order table, and then to query item table in mapping with mapping lookup.
can anybody still give me other solution?
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi...
You can write the stored procedure or package and specify it on the sender side jdbc commnuication channel.
Regards,
Leela
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Joy,
Stored Procedure will be the right approach for this !!
BPM not required !!
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Hi Joy ,
Check out this :
Hope you will find this discussion informative : http://forums.asp.net/p/1021356/1765680.aspx
Regards,
Hi Joy,
Without Stored procedure - Use joins for logically related tables !!!
check out this : https://www.sdn.sap.com/irj/scn/weblogs?blog=/pub/wlg/1725 [original link is broken] [original link is broken] [original link is broken]
Regards,
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
User | Count |
---|---|
88 | |
23 | |
11 | |
9 | |
8 | |
5 | |
5 | |
5 | |
5 | |
4 |
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.