Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
I have set up shared db connection for my ETL processes. We have 50+ ETL currently running at the moment. But we have encountered some hanging issue(process will not work for like 2hours) . Is there a way to setup a database connection timeout for above process.
Thank you
Heshan K
Hi
Which DB type? Usually, add the timeout parameter to 'Additional JDBC Parameters' field or run a query using tXXXRow to set the timeout value.
Regards
Shong
Shared DB connection is a connection which is exactly the same if you get it with the same name. Getting locks this way is pretty easy and you can be happy only to have locks and no other problems.
I strongly suggest to think about if it is a good idea to use exactly the same connection for multiple jobs. I think the transaction management will be a nightmare!
If you want to spare connection or reuse them use connections with the Datasource Alias. In normal Talend jobs outside a Talend Runtime you cannot setup a database connection pool but here you can use here custom components:
https://github.com/jlolling/talendcomp_tDatabaseConnectionPool
You can download the components from the Release section on the right side there.