camel-issues mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sami Nurminen (JIRA)" <j...@apache.org>
Subject [jira] [Commented] (CAMEL-7543) camel-sql - Allow to specify the column type in the SQL query
Date Mon, 23 Nov 2015 19:43:11 GMT

    [ 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)

Mime
View raw message