topic Re: How to set database connection timeout for shared db in Talend Studio

How to set database connection timeout for shared db

heshkaru — Thu, 23 Mar 2023 05:51:41 GMT

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

Re: How to set database connection timeout for shared db

Anonymous — Mon, 27 Mar 2023 11:47:05 GMT

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

Re: How to set database connection timeout for shared db

jlolling_kloeckner — Tue, 28 Mar 2023 18:57:05 GMT

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.