help needed in HTTP to JDBC synchronous

[Former Member]

Hi,

I am doing a interface which involves the HTTP and Database (JDBC), i need to send some two fields as request and based on the certain condition of these two fields i need to get some 4 fields as response.

Can any one please help me out in this regard so that i can atleast frame an idea and start doing the interface?

Thanks,

PSV.

[Former Member · Accepted solution]

Hi PSV,

-->There are no stored procedures, it is just a simple Select Statement.

That's why i said blog is sufficient to solve your problem...

Regards,

[Former Member · Accepted solution]

Hi Santosh,

Can we write the Select query in the JDBC receiver side?

Thanks,

PSV

[Former Member]

Offcourse PSV,

That is what Bhavesh has mentioned in the blog on the basis of select query only the the records will be sent as a response..

Regards,

[Former Member]

before you start designing your scenario can you please tell us how you will be getting the response from DataBase?is there any stored procedure you are invoking or its a simple SQL statement ?

Thanx

Aamir

[Former Member]

Hi Aamir,

There are no stored procedures, it is just a simple Select Statement.

Thanks.

[Former Member]

Hi PSV,

BPM Not Required.., just go through the blog and see how you can use JDBC Receiver adapter for Synchronous select...

Information provided in the blog is sufficient to solve your problem.

Regards,

[deviprasad_pothireddy]

This weblog answers your questions

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

Regards,

Deviprasad

[Former Member]

Hi Deviprasad,

The blog also contains the usage of BPM, do you intend to say that i need to use it?