camel-users mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From darwinanirudh <>
Subject Unable to insert body data into table using sql component
Date Thu, 04 May 2017 05:51:19 GMT
Dear All, 

I need to insert the body values into table so i used sql component.

Since the data in the body should be of map data type , i tried the
following and i am getting the exception:

Caused by: org.apache.camel.FailedToCreateRouteException: Failed to create
route webproxyTest at: >>> ConvertBodyTo[] <<< in route:
Route(webproxyTest)[[From[kafka:localhost:9092?topic=Mediate... because of

Caused by: java.lang.ClassNotFoundException:

			<to ref="callEventRestService" />
			<log message="after first display" />	
			<to uri="bean:Display?method=process" />
			<log message="inside catch 2" />	
			<to uri="bean:Display?method=process" />
			<convertBodyTo type=""/>
			<to uri="bean:Display?method=process" />

	<to uri="sql:{{sql.SusinsertQuery}}"/> 		
			<log message="after second display" />	
			<log message="aftersecond route" />	

Sql query:

sql.SusinsertQuery=insert into error_details values (:#aNum,:#aNum,:#aNum)

Body data is in the form bye.


View this message in context:
Sent from the Camel - Users mailing list archive at

View raw message