Problems with DB connections when deploying ESB jar to ESBSE runtime

[Anonymous]

Hello World,

I have an reproducable problem when setting up the ESB runtime (Karaf) environment into which I want to deploy my Talend ESB jobs.

OS: Windows 10 (_all_ mentioned components are installed / running on this local machine)

Talend Version: Talend Open Studio ESB 7.2.1.20190620_1446

DB Version: MS SQL Server v14.0.1000.169

I have got a Talend Job which updates the status of a certain process. It receives (via REST) the ProcessID and the designated target status and returnes a response. All the data lives in the MS SQL Server (living on localhost). Having it run within the Talend ESB Studio, everything works absolutely fine (throwing requests at it via Postman). The job is configured that it stores the statistics and logmessages in the talend stats tables.

Trying to now deploy it on Karaf, I am getting errors.

As per the documentation I have installed the JDBC driver in karaf (multiple ones), installed the datasource sqlserver in karaf, changed the datasource alias in the Talend job to ds-sqlserver and deployed the job in Karaf.

Deploying the job as it is (build type "OSGi Bundle for ESB") in karaf, the log keeps telling me, that it is waiting for dependencies:

Blueprint bundle mczweinull.wstest/0.1.0 is waiting for dependencies [(&(osgi.jndi.service.name=ds-sqlserver)(objectClass=javax.sql.DataSource))]

Removing the job-specific DB connection and only having the job log its statistics in the MS SQL Server DB (for which I dont know where to specifiy the data source alias "ds-sqlserver"???) , the log shows execptions:

PLEASE NOTE - when deploying the job without any DB connection, it is installed in Karaf without any issues!! Only when DB connections for either the stats or the app data are included, I am running into problems.

Questions:

(1) what am I missing?

(2) how would I be able to create / manage two different DB connections (as the Talend Stats will be stored in a different DB instance and not in the one that stores the application specific data)

(3) how would I be able to specify / manage the execution contexts when making the REST endpoints available in Karaf?

Thanks for the time reading through this post 🙂 Any help is greatly appreciated!!

[Anonymous]

Hello,

Do you have a very specific reason to stay on JTDS?

It is also recommended to use the MS SQL Server JDBC now as JTDS is not well supported anymore.

Let us know if it works well.

Best regards

Sabrina