[
https://issues.apache.org/jira/browse/CAMEL-7543?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=15022837#comment-15022837
]
Sami Nurminen commented on CAMEL-7543:
--------------------------------------
I tested this little bit:
If one creates table
create table projects (integer_value integer);
and sends body:
Arrays.asList("1")
to :
"sql:insert into projects (integer_value) values (:#${body[0]}) "
then Camel seems to do type conversion to numeric value.
Conversion most likely does best quess; could desired end type be included into
to Simple language, so that user could parse also BigInteger etc. values
"sql:insert into projects (integer_value) values (:#${BigInteger:body[0]}) "
which would be same as
<simple resultType="java.math.BigInteger">${body[0]}</simple>
> camel-sql - Allow to specify the column type in the SQL query
> -------------------------------------------------------------
>
> Key: CAMEL-7543
> URL: https://issues.apache.org/jira/browse/CAMEL-7543
> Project: Camel
> Issue Type: Improvement
> Components: camel-sql
> Affects Versions: 2.13.2
> Reporter: Claus Ibsen
> Fix For: Future
>
>
> See nabble
> http://camel.465427.n5.nabble.com/Problem-with-inserting-database-from-camel-context-xml-tp5752810.html
--
This message was sent by Atlassian JIRA
(v6.3.4#6332)
