Synapse ESB and Database Stored procedure

[Sunil.2.Tiwari]

Hello everybody,
Requirement is to call DB stored procedure from Synapse ESB.
Does Synapse ESB have inbuilt mediator to call DB stored procedure?
I used synapse ESB mediator for read and write from DB (Insert/Select).


Thanks & Regards

Sunil Kumar Tiwari | Tech Mahindra Ltd.

(Office: 009120 6641 7136  Mobile: [phone])

Email: sunil.tiwari2@...



============================================================================================================================

 
Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================

[Asankha C. Perera]

Hi Sunil
> Requirement is to call DB stored procedure from Synapse ESB.
> Does Synapse ESB have inbuilt mediator to call DB stored procedure?
> I used synapse ESB mediator for read and write from DB (Insert/Select).
>  
One could easily write one using the code for dblookup/dbreport to
support this use case, so I think this is a nice feature to be included
- could you raise an enhancement JIRA request?

cheers
asankha

--
Asankha C. Perera
AdroitLogic, http://adroitlogic.org

http://esbmagic.blogspot.com

[Sunil.2.Tiwari]

Hi Asankha,
>One could easily write one using the code for dblookup/dbreport to
>support this use case, so I think this is a nice feature to be included
>- could you raise an enhancement JIRA request?

I will an enhancement JIRA request.
Thanks,
________________________________________
From: Asankha Perera [asankha.apache@...] On Behalf Of Asankha C. Perera [asankha@...]
Sent: Tuesday, August 18, 2009 9:32 PM
To: user@...
Subject: Re: Synapse ESB and Database Stored procedure

Hi Sunil
> Requirement is to call DB stored procedure from Synapse ESB.
> Does Synapse ESB have inbuilt mediator to call DB stored procedure?
> I used synapse ESB mediator for read and write from DB (Insert/Select).
>
One could easily write one using the code for dblookup/dbreport to
support this use case, so I think this is a nice feature to be included
- could you raise an enhancement JIRA request?

cheers
asankha

--
Asankha C. Perera
AdroitLogic, http://adroitlogic.org

http://esbmagic.blogspot.com


Thanks & Regards
Sunil Kumar Tiwari | Tech Mahindra Ltd.
(Office: 009120 6641 7136  Mobile: [phone])
Email: sunil.tiwari2@...
============================================================================================================================

 
Disclaimer:

This message and the information contained herein is proprietary and confidential and subject to the Tech Mahindra policy statement, you may review the policy at <a href="http://www.techmahindra.com/Disclaimer.html">http://www.techmahindra.com/Disclaimer.html</a> externally and <a href="http://tim.techmahindra.com/Disclaimer.html">http://tim.techmahindra.com/Disclaimer.html</a> internally within Tech Mahindra.

============================================================================================================================