Is the dataSource configured in your context?
Best,
Christian
Am 10.09.2015 13:56 schrieb "arnaud" <[email protected]>:
> Hello,
>
> Id'like to use a dynamic datasource with the camel-sql component but it's
> not woking as I expected:
> After a search on the forum, I have found a topic "Dynamic DataSource for
> SQL", I try to do something similar :
>
> from("direct:create")
> .setHeader("dataSource", constant("myDynamicDataSource"))
> .setHeader(SqlConstants.SQL_QUERY, simple("insert into customer(firstname,
> lastname) values(:?firstName, :?lastName)"))
> .setHeader("destination", new
> QueryBuilder()).recipientList(header("destination"));
>
> class QueryBuilder implements Expression {
>
> @Override
> public <T> T evaluate(Exchange exchange, Class<T> type) {
>
> StringBuilder query = new StringBuilder();
> query.append("sql:");
>
> query.append(exchange.getIn().getHeader(SqlConstants.SQL_QUERY));
> query.append("?dataSource=#");
> query.append(exchange.getIn().getHeader("dataSource"));
>
> return
> exchange.getContext().getTypeConverter().convertTo(type,
> query.toString());
> }
> }
>
> But I have this error message :
> Failed to resolve endpoint:
>
> sql://insert%20into%20customer(firstname,%20lastname)%20values(:?firstName%2C+%3A%3FlastName%29%3FdataSource=%23myDynamicDataSource
> due to: DataSource must be configured
>
> Any idea of the problem or another solution to implement a dynamic
> datasource?
>
> Thanks,
> Arnaud
>
>
>
>
> --
> View this message in context:
> http://camel.465427.n5.nabble.com/Dynamic-DataSource-tp5771402.html
> Sent from the Camel - Users mailing list archive at Nabble.com.
>
