One Star

[resolved] How to set timeout with tPostgresqlConnection ?

Hi,
I use the TOS 5.2.2.
I want to set the connection and query timeout with the tPostgresqlConnection_1. I do not found any addtionnal parameter.
At least, I want to set it for the select queries.
Could you help me ?
Thanks by advance
Best regards,
Arnaud
1 ACCEPTED SOLUTION

Accepted Solutions
One Star

Re: [resolved] How to set timeout with tPostgresqlConnection ?

Hi Sabrina,
Thanks for your advice.
I have created a new issue (https://jira.talendforge.org/browse/TDI-28660).
Best regards,
Arnaud
7 REPLIES
Seventeen Stars

Re: [resolved] How to set timeout with tPostgresqlConnection ?

hi,
put those value in jdbc Url (of your connection)
http://jdbc.postgresql.org/documentation/head/connect.html
regards
laurent
One Star

Re: [resolved] How to set timeout with tPostgresqlConnection ?

Hi Laurent,
I use the tPostgresqlConnection.
So to do what is request by Postgres JDBC driver, I have to add those parameters in the database field parameter.
Is there a solution to do it with advanced setting ?

Best regards,
Arnaud
Moderator

Re: [resolved] How to set timeout with tPostgresqlConnection ?

Hi,
Unfortunately, so far we don't support additional parameter in Postgresql.
You can open a feature jira issue of DI project on Talend Bug Tracker.
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.
One Star

Re: [resolved] How to set timeout with tPostgresqlConnection ?

Hi Sabrina,
Thanks for your advice.
I have created a new issue (https://jira.talendforge.org/browse/TDI-28660).
Best regards,
Arnaud
Seventeen Stars

Re: [resolved] How to set timeout with tPostgresqlConnection ?

'mile excuses' ... Smiley Wink
I was thinking that it worked on postgres.
I know now !
regards
laurent
One Star

Re: [resolved] How to set timeout with tPostgresqlConnection ?

You're welcome.
It is not easy to know all the components differences.
I have my answer. I have open my first issue.
If I have any time, i will try to patch this component in my project.
Best regards,
Arnaud
Seventeen Stars

Re: [resolved] How to set timeout with tPostgresqlConnection ?

let us know about your patch ... Smiley Wink
regards
laurent