JDBC Receiver Synchronous SELECT With Proxy

[Former Member]

Hi People,

We are trying a JDBC Receiver Synchronous select scenario, based on <a href="/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step Kantilal's Blog</a>. Our scenario is somewhat different in the sense that we are using synchronous message interface as outbound, using this for proxy generation and then calling the EXECUTE_SYNCHRONOUS method to pass the values to Integration Server and get the response back. We are writing the response obtained. but the problem is, SXMB_MONI is showing no entry in the response message structure, although the SELECT query should select at least one record. Can anybody please point out where the error is residing? Is it an error of the JDBC Synch. Select, or do we have to use BPM in this case, as pointed by Bhavesh in his blog?

Awaiting your views,

Regards,

Amitabha

[bhavesh_kantilal]

Hi,

No BPM is needed in your case as both the Outbound and inbound interfaces are synch.

A few checks,

1. Are both outbound and inbound interfaces SYnchronous Interfaces?

2. What is the status of the Receiver JDBC adapter in Comm Channel Monitoring?

Regards

Bhavesh

[VijayKonam]

Also,

In addition to Bhavesh's points, please check your interfaces are properly linked with the associated response messge types as well.

VJ

[Former Member]

Hi People,

Thanks for all those hints...but We have solved the problem...there was an error in Response Mapping...So the corresponding import structure in EXECUTE_SYNCHRONOUS was not getting populated.

Awarded points for making us aware of the possible pitfalls in this scenario.

Thanks and Regards,

Amitabha

[Former Member]

Whoops, Forgot to mark the thread answered! 😛