Receiver JDBC with Stored Procedure's response

[Former Member]

I have (Triggering point)Proxy <-> XI <-> JDBC (Synchronous call to SQL Stored Procedure) scenario but this interface has a huge volume. So, Synchronous call is timing out at HTTP.

I do not want to use BPM and wondering if there is any way without BPM that I can catch the Stored procedure's response and send that back to ERP again ?

So, my question is Can we catch the Stored Procedure's repsonse with an Asynchronous interface anyway ?

Cheers,

Amrish.

[moorthy · Accepted solution]

HI,

<i>So, my question is Can we catch the Stored Procedure's repsonse with an Asynchronous interface anyway ?</i>

>>>No, to get the response it should be synchronous in the same interface.

Did you check increasing the timeout values ..

Regards,

moorthy

[Former Member · Accepted solution]

Yeah , but don;t want to increase like 10 mins ... What if I do that ?

[MichalKrawczyk · Accepted solution]

hi,

you definetely shouldn't increase it like that:

sync calls are =< 30 sec

there are other ways to do that

(like export to xml file from stored procedure etc) that you can use

and changing the sync timeout is certainly not one of them

Regards,

michal

-

---

<a href="/people/michal.krawczyk2/blog/2005/06/28/xipi-faq-frequently-asked-questions"><b>XI / PI FAQ - Frequently Asked Questions</b></a>

[Former Member · Accepted solution]

Thanks guys ... points assigned !!!

[Former Member · Accepted solution]

Guys - How do I catch the response from Stored procedure in the form of OUTPUT parameter of the Stored Procedure. I mean, This stored procedure has INPUT and OUTPUT parameters. Wondering, If I pass values to the INPUT parameter, can I catch the response in OUTPUT parameter ?

Cheers,

Amrish.