topic Re: stats and logs connection not getting closed in Talend Studio

stats and logs connection not getting closed

CalinM — Wed, 03 Oct 2018 17:10:49 GMT

Hi,

I'm using Talend Open Studio 5.4 with jobs deployed as Axis web services. My jobs have Stats logging to database enabled, using the project wide stats connection. We use Oracle as the database.

The problem we have is that the stats and logs connection is never closed. Sometimes something happens to the network, the connection gets closed by the database, we run the job, the connection is closed, the job fails.

The generated code should either close the connection at the end of the job or it should check the connection before using it, but it doesn't. I tried closing the connection in a tJava at the end of the job, but then everything fails.

Can anyone think of a workaround for this?

Thanks,

Calin

Re: stats and logs connection not getting closed

Anonymous — Tue, 16 Oct 2018 07:44:15 GMT

Hello Calin,

Are you defining stats and logs in project setting? Is it OK with you when you set up stats-and-logs for your active job?

Does this issue repro on talend open studio 7.0?

Best regards

Sabrina

Re: stats and logs connection not getting closed

CalinM — Tue, 16 Oct 2018 08:03:43 GMT

talend open studio 7.0 does not export axis war files, so it cannot repro
or not repro.

Yes, I am defining them in the project setting. No, it is not OK when I am
defining them for the active job, the connection is never closed.