[
https://issues.apache.org/jira/browse/CAMEL-14299?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel
]
Gurpal2000 updated CAMEL-14299:
-------------------------------
Description:
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
Error lines along the lines of
{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}
was:
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-data/?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
Error lines along the lines of
{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}
> Dynamic producer 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
>
> 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
> Error lines along the lines of
> {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)
