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)

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

Mon, 18 July 2016 02:43

Eclipse User

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 05:39

Eclipse User

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 10:19

Eclipse User

Thank you Ashish!

Previous Topic:	Periodically Export Structured Data
Next Topic:	How to handle Exception in SQL invocation call application

Goto Forum:

-=] Back to Top [=-

Current Time: Sun Jun 22 02:31:52 EDT 2025

.:: Contact :: Home ::.

Breadcrumbs

Sign up to our Newsletter