Talend Connect
Virtual Summit
JOIN US!
And visit the Customer
& Community Lounge.
May 27-28, wherever you are.

stats and logs connection not getting closed

Highlighted
Four Stars

stats and logs connection not getting closed

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

 

Highlighted
Moderator

Re: stats and logs connection not getting closed

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

--
Don't forget to give kudos when a reply is helpful and click Accept the solution when you think you're good with it.
Highlighted
Four Stars

Re: stats and logs connection not getting closed

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.

2019 GARTNER MAGIC QUADRANT FOR DATA INTEGRATION TOOL

Talend named a Leader.

Get your copy

OPEN STUDIO FOR DATA INTEGRATION

Kickstart your first data integration and ETL projects.

Download now

Best Practices for Using Context Variables with Talend – Part 1

Learn how to do cool things with Context Variables

Blog

Migrate Data from one Database to another with one Job using the Dynamic Schema

Find out how to migrate from one database to another using the Dynamic schema

Blog

Best Practices for Using Context Variables with Talend – Part 4

Pick up some tips and tricks with Context Variables

Blog