JDBC sender multiple table join statement

[Former Member]

Hi,

Scenario- JDBC to File.

Require to select the data from two table which is header/detail and need to send it to legacy.

I am able to test and run the join statement from SQL editor and it is working as expected but when I tried the same statement with JDBC sender adapter it is not working and giving below log in comm channel.

18/11/10 10:55:54 PM 0ad00777-5d97-45d6-3106-e8d2c6fdc91b Polling interval started. Length: 60.0 seconds

18/11/10 10:55:54 PM 0ad00777-5d97-45d6-3106-e8d2c6fdc91b Processing finished successfully

18/11/10 10:55:48 PM Processing started

The message id shown above does not exist in MONI.

any idea why join statement is not working

my oracle version is 10g

chirag

[philippeaddor]

OK, just 10 years later, here my answer comes :-))

The JDBC Channel always shows this log entry upon every poll to the DB, it doesn't mean that a message was actually processed! It means that nothing was found in the DB using your SQL query. If something was found, there would be a corresponding additional entry in the channel log.

Maybe it still helps somebody.

Br,

Philippe

[former_member472138]

It looks JDBC sender parameters to be checked thouroughly. Also check this out blogs.

/people/yining.mao/blog/2006/09/13/tips-and-tutorial-for-sender-jdbc-adapter

http://help.sap.com/saphelp_nw04/helpdata/en/14/80243b4a66ae0ce10000000a11402f/frameset.htm

Regards

Pothana

[Former Member]

Hi Chirag,

Your log shows message processed successfully, Try to recreate or reactive the your communication channel.

Thanks

Sateesh