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?
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?
Talend named a Leader.
Kickstart your first data integration and ETL projects.
Learn how to do cool things with Context Variables
Find out how to migrate from one database to another using the Dynamic schema
Pick up some tips and tricks with Context Variables