DATASOURCE Error - Talend Runtime - SQL SERVER - java.lang.RuntimeException:No DataSource with alias: ds-sqlserver available!

Andrea4683453 — Fri, 15 Nov 2024 22:06:50 GMT

Hello everybody,

we are encountering an error while we run an api inside the Talend runtime (Karaf) v.8

java.lang.RuntimeException:No DataSource with alias: ds-sqlserver available!

Here what we did:

copied the driver under folder etc/lib (seems to be ok)
started Karaf
we added the datasource "ds-sqlserver" in the talend component tDBOutput, in the appropriate field.
we deployed the jar
installed the feature datasource for sqlserver: feature:install tesb-datasource-sqlserver
changed the generated file inserting our db connection credentials: etc/org.talend.esb.datasource.sqlserver.cfg (attached image "configurations.png")
if we execute the command: "service:list DataSource" we can see that the Datasource has been created and it is associated with our API (attached image "service list datasource.png")

Everything seems to be ok. "ds-sqlserver" datasource exists in Karaf, but the api job running in the container cannot "see" it.

Can anyone help us please?

Thank you very much for any kind of support.

Andrea.

Re: DATASOURCE Error - Talend Runtime - SQL SERVER - java.lang.RuntimeException:No DataSource with alias: ds-sqlserver available!

mgoedhart — Wed, 22 Mar 2023 15:00:31 GMT

And if you use the jndi service name in your job?: jdbc/sam

Andrea4683453 — Thu, 23 Mar 2023 15:56:35 GMT

Yes, we simply solved like this.

Thanks a lot.