[CAMEL-16769] camel-sql: Being able to use dataSource from the exchange (not from registry)

• Type: Improvement
• Status: Resolved
• Priority: Major
• Resolution: Won't Fix
• Affects Version/s: 3.11.0
• Component/s: camel-sql
• Estimated Complexity: Unknown
• Assignee: Unassigned
• Reporter: roberto gasdia
• Created: 29/Jun/21 14:31
• Updated: 02/Jul/21 15:22
• Resolved: 02/Jul/21 15:22

Description

From what I can tell looking at the source code, It doesn't seem to be possible to instantiate a bean with scope Request (or maybe an instance assigned to an exchange property)  and then later have

 

.toD("sql:{my query}?dataSource=..the bean instance)

 

wich is mandatory in my use case, because we have a multitenant application where db connection parameters are passed in the request, so we need to be able to create a data source with different settings per each request.

Having to fetch the data source from the registry we cannot make sure that every request has its own DB properly configured.