cancel
Showing results for 
Search instead for 
Did you mean: 

Need help reg sender JDBC adapter

Former Member
0 Kudos

Hi,

I am having a requirement like, i need to fetch the data from two data base tables. and after fetching the data, i need to update those two tables.

For selecting the data from two tables, two select statements i need to write, how i can give two select statements in sender JDBC comm channel.

In sender JDBC channel, only one update query we can give...how i can update two tables?

Regards,

Venkata Ramana.

Accepted Solutions (1)

Accepted Solutions (1)

Former Member
0 Kudos

Hi,

Check if there is any common field and based on which you can write some query for fetching the needed data..

or try use the joins...and use the same statement at update tab also for updating the both tables data...

just use the same query as how it can be used at database level

HTH

Rajesh

Answers (3)

Answers (3)

Former Member
0 Kudos

Hi Venkata,

You can fetch the data from two tables using join query in sender JDBC communication channel.

But for this, there has to be at least 1 field common between two tables to evalueate the condition.

Also, while updating both the tables, you can create 1 such a structure comprising those fields from both the tables which needs to be updated, and using mapping program you can update them back to sender.

-Tanaya.

former_member187339
Active Contributor
0 Kudos

Hi Venkata,

>>i need to fetch the data from two data base tables. and after fetching the data, i need to update those two tables.For selecting the data from two tables, two select statements i need to write, how i can give two select statements in sender JDBC comm channel.

You cannot do this in sender jdbc adapter. It supports only one query at a time.. So either go for Stored Procedures or Some complex query like union or create a view out of this two tables and query the view..

>>In sender JDBC channel, only one update query we can give...how i can update two tables?

Again this cannot be done....go for BPM and complete your scenario...

Regards

Suraj

Former Member
0 Kudos

Hi Suraj,

Thanks for your reply.

For updating two tables, you said use BPM, how to use BPM..can you please give some more information on this.

Regards,

Venkata Ramana.

former_member187339
Active Contributor
0 Kudos

Hi Venkata,

Using BPM with Fork and receive steps.. something like this:

http://wiki.sdn.sap.com/wiki/display/BPX/BPMPatternMultiIfconditionExplained%28stepbyStep+Procedure%29

/people/milan.thaker/blog/2008/07/23/correlation-150-runtime-behavior-of-bpm

Regards

Suraj

venky_b
Participant
0 Kudos

Hello Venkat,

For your requirement, go for stored procedure and find the below thread.

hope this will help you

Thanks,

Venky