[resolved] How to set timeout with tPostgresqlConnection ?

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous · Accepted solution]

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

[Anonymous]

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

[Anonymous]

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

[Anonymous]

let us know about your patch ...
regards
laurent