topic Re: postgresconnection in Talend Studio

postgresconnection

Anonymous — Wed, 19 Sep 2018 18:35:26 GMT

Hello All..

I am designing a job in which i am making a connection postgresconnection connector in prejob and after that i am using existing connection in postgresoutput connector but that is not inserting the record in table. But if i give all configuration info (host,password,user,database) in postgresoutput instead of postgresconnection its working fine.

but i dont want to make connection at each record .is it not posssible to make connection once in postgresconnection connector and use existing connection in postgresoutput connector

Re: postgresconnection

TRF — Wed, 19 Sep 2018 18:54:19 GMT

Can you share your job design?
Are you sure the connection after tPreJob is successfully opened?

Re: postgresconnection

Anonymous — Sun, 23 Sep 2018 07:39:22 GMT

thanks for reply....i am facing the same problem in mysql also..i am getting this

[statistics] connecting to socket on port 3430
[statistics] connected
com.mysql.jdbc.JDBC4Connection@48eff760
[statistics] disconnected

To print the status of connection i am using this code line---System.out.println((java.sql.Connection)globalMap.get("conn_tMysqlConnection_1"));

it is showing connected status i think ..plz tell me what wrong i am doing

Re: postgresconnection

Anonymous — Sun, 23 Sep 2018 16:52:08 GMT

@TRF

thanks for reply....i am facing the same problem in mysql also..i am getting this

[statistics] connecting to socket on port 3430
[statistics] connected
com.mysql.jdbc.JDBC4Connection@48eff760
[statistics] disconnected

To print the status of connection i am using this code line---System.out.println((java.sql.Connection)globalMap.get("conn_tMysqlConnection_1"));

it is showing connected status i think ..plz tell me what wrong i am doing..

plz reply soon

Re: postgresconnection

Anonymous — Sun, 23 Sep 2018 17:11:25 GMT

@TRF

i solved my problem..

Actually i didn't commit after making connection..

now its working perfect.