File to JDBC synchronous without BPM?

[Former Member]

Hi Experts,

I want to connect a File Adapter to a JDBC, then receive a response and send it to another File Adapter. Is it possible to do that without BPM?

<b>Synchronous </b>: File Adapter->JDBC(Request)->JDBC(Response)--->File adapter

Regards

Gonzalo

[udo_martens · Accepted solution]

Hi Gonzalo,

no, the file adapter works only asynchronous. You need BPM.

Regards,

Udo

[henrique_pinto · Accepted solution]

The mere fact that File is async and JDBC is sync doesn't make it mandatory to use BPMs. Check this thread also by Bhavesh:

However, the use of JDBC in async/sync scenario without BPM has been said to be buggy (as referenced in the same thread). It seems that there was a note released and everything, you may wanna check that.

Regards,

Henrique.

[Former Member · Accepted solution]

Hi Henrique,

It was really helpful. Thanks.

Regards

Gonzalo

[Former Member]

Hi

You need to use BPM/Integration Process for the same.

Thanks

[prateek]

Without BPM it is not possible.

Instead, a workaround could be File - XI - File with JDBC lookup

Regards,

Prateek

[Former Member]

Hi Castillo,

I am not sure wheather it is possible without BPM or not...

But if u use BPM it will be simple....

Check the weblog by Bhavesh...

/people/bhavesh.kantilal/blog/2006/07/03/jdbc-receiver-adapter--synchronous-select-150-step-by-step

Also check the thread..

regrads

BILL

[udo_martens]

Hi BILL,

Bhavesh is using BPM in his blog...

The second link is not a thread, it is again Bhaveshs blog..

Regards,

Udo

[Former Member]

Hi Udo/Castillo,

My mistake....

Now i have given the proper thread...check...

yes i know Bhavesh is using BPM....thats why i have given...the blog...

Regards

BILL

[Former Member]

Thanks everybody, Do you think I can do this scenary omitting the last File adapter? That is sending my request via the first File Adapter and receiving the response, just for watching it in the moni, as a test scenary.

Regards

Gonzalo