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

Gurpal2000 edited comment on CAMEL-14299 at 12/23/19 5:06 PM:
--------------------------------------------------------------

[~bedla] Thank you for your in depth analysis; a seasonal present :)

Question: why would Camel try to set the DS to HikariConfig? I thought one 
benefit of using Spring/Boot with Camel was so that those sort of things are 
already taken care of to some extent.

(Could it be related to: 
https://github.com/brettwooldridge/HikariCP/issues/1095)


was (Author: gurpal2000):
[~bedla] Thank you for your in depth analysis; a seasonal present :)

Question: why would Camel try to set the DS to HikariConfig? I thought one 
benefit of using Spring/Boot with Camel was so that those sort of things are 
already taken care of to some extent.

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

Reply via email to