Skip to main content


Eclipse Community Forums
Forum Search:

Search      Help    Register    Login    Home
Home » Archived » Eclipse Process Manager (Stardust) » Call stored procedure using Camel End Point Application(Call stored procedure using Camel End Point Application)
Call stored procedure using Camel End Point Application [message #1738204] Mon, 18 July 2016 06:43 Go to next message
Prerna AD is currently offline Prerna ADFriend
Messages: 5
Registered: July 2016
Junior Member
Hi,

I am trying to call a stored procedure using the Camel End Point Application.

The code looks as follows:

<to uri="sql-stored:getAllProjects(OUT INTEGER total )?dataSource=myDataSource"/>

wherein;
->myDataSource is defined in the additional bean section,
->getAllProjects is a stored procedure that gets the count of all the projects with one OUT Parameter.

I am getting the following error while deploying the model:

Exception creating route for application CallStoredProcedure Cause org.apache.camel.FailedToCreateRouteException: Failed to create route Producer-716594595 at: >>> Transacted[ref:required] <<< in route: Route(Producer-716594595)[[From[direct://default_Model115_Ca... because of Failed to resolve endpoint: sql-stored://getAllProjects(OUT%20INTEGER%20total%20)?dataSource=myDataSource due to: No component found with scheme: sql-stored

Any inputs will be helpful.

Thanks!
Re: Call stored procedure using Camel End Point Application [message #1738484 is a reply to message #1738204] Wed, 20 July 2016 09:39 Go to previous messageGo to next message
Ashish Khole is currently offline Ashish KholeFriend
Messages: 28
Registered: April 2015
Junior Member
Hello Prerna,

Apache camel's SQL Stored Procedure Component "sql-stored" is supported as of Camel 2.17. Stardust is currently integrated with Camel 2.14 version. So executing the above route would definitely fail.

To achieve the same try using the "stored-procedure-application-overlay" application instead of "Generic-camel-endpoint-application". Following is the help documentation for the same:
http://help.eclipse.org/mars/topic/org.eclipse.stardust.docs.analyst/html/handbooks/modelling_analyst/applications/sp-application-overlay.htm?resultof=%22%73%74%6f%72%65%64%22%20%22%73%74%6f%72%65%22%20%22%70%72%6f%63%65%64%75%72%65%22%20%22%70%72%6f%63%65%64%75%72%22%20

Thanks & Regards
Ashish
Re: Call stored procedure using Camel End Point Application [message #1739311 is a reply to message #1738484] Fri, 29 July 2016 14:19 Go to previous message
Prerna AD is currently offline Prerna ADFriend
Messages: 5
Registered: July 2016
Junior Member
Thank you Ashish!
Previous Topic:Periodically Export Structured Data
Next Topic:How to handle Exception in SQL invocation call application
Goto Forum:
  


Current Time: Sat Nov 17 11:10:10 GMT 2018

Powered by FUDForum. Page generated in 0.02146 seconds
.:: Contact :: Home ::.

Powered by: FUDforum 3.0.2.
Copyright ©2001-2010 FUDforum Bulletin Board Software

Back to the top