Do not input private or sensitive data. View Qlik Privacy & Cookie Policy.
Skip to main content
Announcements
Qlik Connect 2025! Where innovative solutions turn your data visions into reality: REGISTER TODAY
cancel
Showing results for 
Search instead for 
Did you mean: 
heshkaru
Creator
Creator

How to set database connection timeout for shared db

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

Labels (2)
2 Replies
Anonymous
Not applicable

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

 

 

jlolling_kloeckner
Contributor
Contributor

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.