postgresconnection

[Anonymous]

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

[TRF]

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

[Anonymous]

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

[Anonymous]

@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

[Anonymous · Accepted solution]

@TRF

i solved my problem..

Actually i didn't commit after making connection..

now its working perfect.