And you are using Camel 2.11.0 ?
On Wed, Jun 26, 2013 at 8:10 AM, indrayani <ind.k...@gmail.com> wrote:
> Hi ,
> I am using following route
>
> <route id="route1">
> <from uri="servlet:///application1"/>
> <transform>
> <method bean="databaseBean" method="generateInsertData"/>
> </transform>
> <to uri="sql:{{sql.insertOrder}}"/>
> <to uri="activemq:queue:inbox"/>
> </route>
>
> the DatabaseBean class contains following method :
>
> public Map generateInsertData(String headerId1)
> {
> Map<String, Object> answer = new HashMap<String, Object>();
> answer.put("reqId","111");
> answer.put("msg","tesing the database insertion");
> return answer;
> }
>
>
> and my sql property file contains following query :
>
> sql.insertOrder=insert into camel_table (req_id,msg) values (:#reqId, :#msg)
>
> the table is already created in oracle database.
>
> when the route gets called, i get following exception :
>
> No body available of type: java.io.InputStream but has value: {reqId=111,
> msg=tesing the database insertion} of type: java.util.HashMap on:
> JmsMessage[JmsMessageID: ID:xyz-b4be0c20ddf-4261-1372226226246-3:5:1:1:1].
> Caused by: No type converter available to convert from type:
> java.util.HashMap to the required type: java.io.InputStream with value
> {reqId=111, msg=tesing the database insertion}.
> Exchange[JmsMessage[JmsMessageID:
> ID:xyz-b4be0c20ddf-4261-1372226226246-3:5:1:1:1]]. Caused by:
> [org.apache.camel.NoTypeConversionAvailableException - No type converter
> available to convert from type: java.util.HashMap to the required type:
> java.io.InputStream with value {reqId=111, msg=tesing the database
> insertion}]
>
>
> ----------
> I followed the tutorial for camel sql and tried to implement the above code,
> but I am not understanding where I am going wrong.
> Searched for other posts , but still did not get any solution
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/getting-error-with-camel-sql-component-in-route-tp5734785.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
--
Claus Ibsen
-----------------
www.camelone.org: The open source integration conference.
Red Hat, Inc.
FuseSource is now part of Red Hat
Email: cib...@redhat.com
Web: http://fusesource.com
Twitter: davsclaus
Blog: http://davsclaus.com
Author of Camel in Action: http://www.manning.com/ibsen
