Issue using datasources in Talend ESB Runtime (TOS v7.3.1 20200219_1130)

edadou — Wed, 04 Dec 2024 11:23:11 GMT

Hi,

I'm facing an issue in a TESB route I'm working on, this route have to retrieve data from two databases (one oracle and one postgresql).

I've created the necessary datasources in the TESB Runtime they work (I also try to query them directly within karaf and it also works).

In another route (in TOS ESB v8.0.1), you could communicate with the datasource using a cMessagingEndpoint configured like this :

I tried to do the same in v7.3.1 but I have the following error :

12:20:09.548 ERROR [Blueprint Event Dispatcher: 1] Error occurred during starting CamelContext: interfaces.r_test_sql_0_1.R_TEST_SQL
org.apache.camel.FailedToCreateRouteException: Failed to create route R_TEST_SQL_cTimer_1 at: >>> To[sql:select now()?dataSource=jdbc/postgresqlds] <<< in route: Route(R_TEST_SQL_cTimer_1)[[From[timer:cTimer_1?delay=1000]]... because of Failed to resolve endpoint: sql://select%20now()?dataSource=jdbc%2Fpostgresqlds due to: No bean could be found in the registry for: jdbc/postgresqlds of type: javax.sql.DataSource
at org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:1352) ~[bundleFile:2.24.2]
at org.apache.camel.model.RouteDefinition.addRoutes(RouteDefinition.java:212) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.startRoute(DefaultCamelContext.java:1139) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.startRouteDefinitions(DefaultCamelContext.java:3736) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.doStartCamel(DefaultCamelContext.java:3439) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext$4.call(DefaultCamelContext.java:3247) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext$4.call(DefaultCamelContext.java:3243) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.doWithDefinedClassLoader(DefaultCamelContext.java:3266) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.doStart(DefaultCamelContext.java:3243) ~[bundleFile:2.24.2]
at org.apache.camel.support.ServiceSupport.start(ServiceSupport.java:72) ~[bundleFile:2.24.2]
at org.apache.camel.impl.DefaultCamelContext.start(DefaultCamelContext.java:3159) ~[bundleFile:2.24.2]
at org.apache.camel.blueprint.BlueprintCamelContext.start(BlueprintCamelContext.java:255) ~[bundleFile:2.24.2]
at org.apache.camel.blueprint.BlueprintCamelContext.maybeStart(BlueprintCamelContext.java:297) ~[bundleFile:2.24.2]
at org.apache.camel.blueprint.BlueprintCamelContext.blueprintEvent(BlueprintCamelContext.java:188) [bundleFile:2.24.2]
at org.apache.aries.blueprint.container.BlueprintEventDispatcher$3.call(BlueprintEventDispatcher.java:190) [bundleFile:1.10.2]
at org.apache.aries.blueprint.container.BlueprintEventDispatcher$3.call(BlueprintEventDispatcher.java:188) [bundleFile:1.10.2]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.Executors$RunnableAdapter.call(Executors.java:515) [?:?]
at java.util.concurrent.FutureTask.run(FutureTask.java:264) [?:?]
at java.util.concurrent.ScheduledThreadPoolExecutor$ScheduledFutureTask.run(ScheduledThreadPoolExecutor.java:304) [?:?]
at java.util.concurrent.ThreadPoolExecutor.runWorker(ThreadPoolExecutor.java:1128) [?:?]
at java.util.concurrent.ThreadPoolExecutor$Worker.run(ThreadPoolExecutor.java:628) [?:?]
at java.lang.Thread.run(Thread.java:829) [?:?]

Is there a configuration that I have to add to the route or other actions to make ?

Thanks

topic Issue using datasources in Talend ESB Runtime (TOS v7.3.1 20200219_1130) in Talend Studio

Issue using datasources in Talend ESB Runtime (TOS v7.3.1 20200219_1130)