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

[Andrea4683453]

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:

1. copied the driver under folder etc/lib (seems to be ok)
2. started Karaf
3. we added the datasource "ds-sqlserver" in the talend component tDBOutput, in the appropriate field.
4. we deployed the jar
5. installed the feature datasource for sqlserver: feature:install tesb-datasource-sqlserver
6. changed the generated file inserting our db connection credentials: etc/org.talend.esb.datasource.sqlserver.cfg (attached image "configurations.png")
7. 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.

[mgoedhart · Accepted solution]

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

[Andrea4683453]

Yes, we simply solved like this.

Thanks a lot.