[ https://issues.apache.org/jira/browse/CAMEL-14299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Gurpal2000 updated CAMEL-14299: ------------------------------- Priority: Major (was: Minor) > 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: Major > Fix For: 3.0.1, 3.1.0 > > > 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)