Eclipse Community Forums: Eclipse Process Manager (Stardust) » Call stored procedure using Camel End Point Application

Home » Archived » Eclipse Process Manager (Stardust) » Call stored procedure using Camel End Point Application(Call stored procedure using Camel End Point Application)

Show: Today's Messages :: Show Polls :: Message Navigator

Call stored procedure using Camel End Point Application [message #1738204]

Mon, 18 July 2016 06:43

Prerna AD

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!

Report message to a moderator

Re: Call stored procedure using Camel End Point Application [message #1738484 is a reply to message #1738204]

Wed, 20 July 2016 09:39

Ashish Khole

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

Report message to a moderator