topic Re: cannot connect to postgresql Database in Talend Studio

cannot connect to postgresql Database

Anonymous — Wed, 11 Jun 2014 13:49:37 GMT

Dear Friends,
I tried to connect with localhost postgresql database but i got error as "connection failure".
i am using
Talend open studio Data integration- 5.4.1.r111943
Posgresql DB version - 9.1 x86 (localhost:5432)
I also attached screenshot.
Thanks in advance
with regards,
chandra

Re: cannot connect to postgresql Database

Anonymous — Wed, 11 Jun 2014 14:40:00 GMT

Hi,
Try,
Don't add Database,Schema details.

Thanks,
kumar

Re: cannot connect to postgresql Database

Anonymous — Wed, 11 Jun 2014 14:51:53 GMT

Hi Kumar,
Still i got the same error, after i left empty for Database and Schema details
with regards,
chandra

Re: cannot connect to postgresql Database

Anonymous — Wed, 11 Jun 2014 14:58:20 GMT

Hi,
I checked for me it's working fine.No issues
You are enter correct login and password.
Thanks,
kumar.talend

Re: cannot connect to postgresql Database

Anonymous — Wed, 11 Jun 2014 21:32:25 GMT

Please read the error message: "Connection attempt timed out" and therefore the host or the port is wrong nothing else could have an impact at this state.

Re: cannot connect to postgresql Database

Anonymous — Thu, 12 Jun 2014 02:27:32 GMT

Make sure you are accepting TCP/IP connections in your postgresl.conf and your pg_hba.conf. Are you able to connect remotely from another client like pgAdmin or SQuirrel? As mentioned, a timeout means there is no one home at that address/port.

Re: cannot connect to postgresql Database

Anonymous — Thu, 12 Jun 2014 04:38:15 GMT

Hi krishnasamy,
Could you connect to your postgresql Database successfully by client without using talend studio?
Best regards
Sabrina

Re: cannot connect to postgresql Database

Anonymous — Fri, 13 Jun 2014 15:45:10 GMT

Hi
Could you connect to your postgresql Database successfully by client without using talend studio?
Yes i can connect using PG admin and i can view the database.
my old talend scripts can connect to database and can insert the value.
But if i am Try to create new connection or test the new/ old connection then i get this error.
Thanks and regards
chandra

Re: cannot connect to postgresql Database

Anonymous — Mon, 16 Jun 2014 11:31:41 GMT

Hi,
Is there any "X" mark in your postgresql component(missing jar?)
Usually, there are jars required for connection. As soon as you drag the component on the workspace, it would ask to download the particular jar files.
Best regards
Sabrina

Re: cannot connect to postgresql Database

Anonymous — Mon, 16 Jun 2014 13:44:38 GMT

Hi Sabrina, so far we can say, the driver is loaded because we see an error message made from the driver.
It is definitely a problem caused by the connection parameters.
Sometimes Talend has the bad behaviour to quote context variables and one can overlook it very easely: I mean things like that:
"context.DB_Port"
instead of
context.DB_Port
This happens sometime while importing a job. I had sometime problems with the new password encryption feature which destroys the password also while importing a job.
Probably this is the problem.

Re: cannot connect to postgresql Database

Anonymous — Tue, 17 Jun 2014 08:44:13 GMT

Hi jlolling,
Thanks for sharing your experience with us. It is really helpful.
@krishnasamy is there any further process for your issue?
Best regards
Sabrina