cancel
Showing results for 
Search instead for 
Did you mean: 

about sender jdbc adapter

Former Member
0 Kudos

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

Accepted Solutions (0)

Answers (4)

Answers (4)

Former Member
0 Kudos

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?

Former Member
0 Kudos

Hi...

You can write the stored procedure or package and specify it on the sender side jdbc commnuication channel.

Regards,

Leela

Former Member
0 Kudos

Joy,

Stored Procedure will be the right approach for this !!

BPM not required !!

Regards,

Former Member
0 Kudos

actually,

store procedure can not resolve the issue yet?

Former Member
Former Member
0 Kudos

that is not essential.

it is essential that jdbc sender adapter does not support multiple resultsets returned by query.

Former Member
0 Kudos

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,

agasthuri_doss
Active Contributor
0 Kudos

Hey,

Check this Thread

With out BPM you can acheive,

Cheers

Agasthuri