[jira] [Commented] (CAMEL-14299) camel-sql - Dynamic producer (toD) problem

["Gurpal2000 (Jira)" <ji...@apache.org>]

    [ https://issues.apache.org/jira/browse/CAMEL-14299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=17018304#comment-17018304 ] 

Gurpal2000 commented on CAMEL-14299:
------------------------------------

Fantastic thank you all.

> camel-sql - Dynamic producer (toD) problem
> ------------------------------------------
>
>                 Key: CAMEL-14299
>                 URL: https://issues.apache.org/jira/browse/CAMEL-14299
>             Project: Camel
>          Issue Type: Bug
>          Components: camel-sql
>    Affects Versions: 3.0.0
>            Reporter: Gurpal2000
>            Priority: Minor
>             Fix For: 3.1.0
>
>         Attachments: CAMEL-14299.log, log.txt
>
>
> Spring Boot: 2.2.1
> Camel: 3.0.0
> *Works* using "to()"
>  
> {code:java}
> from("file://d:/tmp/?fileName=test&noop=true")
> .setHeader("val1", constant(1))
> .setHeader("val2", constant("yo"))
> .to("sql:insert into gbtemp (col1, col2) values (:#val1, :#val2)?dataSource=#dataSource");
> {code}
> Does *not work* using ".toD()"
> {code:java}
> from("file://d:/tmp/?fileName=test&noop=true")
> .setHeader("val1", constant(1))
> .setHeader("val2", constant("yo"))
> .setHeader("insertSql", constant("insert into gbtemp (col1, col2) values (:#val1, :#val2)"))
> .toD("sql:${header.insertSql}?dataSource=#dataSource");
> {code}
> This used to work fine under Camel 2.x
> Example error lines:
> {code:java}
> Caused by: org.apache.camel.RuntimeCamelException: Cannot auto create component: sql
> Caused by: org.apache.camel.PropertyBindingException: Error binding properties on bean: org.apache.camel.component.sql.SqlComponent@a72b3b2
> org.apache.camel.ResolveEndpointFailedException: Failed to resolve endpoint: sql://insert...
> {code}
>  



--
This message was sent by Atlassian Jira
(v8.3.4#803005)