[
https://issues.apache.org/jira/browse/CAMEL-14299?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=16998716#comment-16998716
]
Gurpal2000 edited comment on CAMEL-14299 at 12/18/19 1:31 AM:
--------------------------------------------------------------
Ah apologies, a missed the main class; should be good now.
Also - I switched the camel-sql to camel-sql-starter (I see it's part of
org.apache.camel.springboot) as per your advice. Removed/disabled web, etc.
No luck. Errors are the same.
was (Author: gurpal2000):
Ah apologies, a missed checkin. It should be good now. Will give the starter
jar a go soon.
> 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
>
> Attachments: 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)
