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

• Type: Bug
• Status: Resolved
• Priority: Minor
• Resolution: Fixed
• Affects Version/s: 3.0.0
• Fix Version/s: 3.1.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: Gurpal2000
• Created: 13/Dec/19 22:13
• Updated: 17/Jan/20 20:49
• Resolved: 24/Dec/19 06:28

Description

Spring Boot: 2.2.1

Camel: 3.0.0

Works using "to()"

 

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");

Does not work using ".toD()"

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");

This used to work fine under Camel 2.x

Example error lines:

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...

 

Issue Links

• is related to: CAMEL-14329 Adding component should not autowire singleton from registry in nested mode