Context Variable from txt file

[Velu_R]

Hi Team,

I am trying to get Context (data connection) variable (Database input) from Txt file. This is the input of my txt file.

This is the query I am using to get table information "SELECT * FROM COMPANY". I have tried with Database. Table name also. But I am getting below error. "Exception in component tDBInput_1 (DataConnection_FromFile)

java.sql.SQLRecoverableException: IO Error: Invalid number format for port number"

Could you please suggest do I need to follow any other steps.

[manodwhb]

@Not defined Not defined​ , your file has double quotes for value field because of the you are facing issue.

check the below link

https://help.talend.com/reader/t77PffDe~1iumPvFKrl43Q/4drL9L5CVxrgHwvsAv3r9g

Thanks,

Manohar

[Velu_R]

Hi Manohar,

Thanks for the response. Now I have corrected values. But still receiving below error.

"Exception in component tDBInput_1 (DataConnection_FromFile)

java.sql.SQLRecoverableException: IO Error: The Network Adapter could not establish the connection

at oracle.jdbc.driver.T4CConnection.logon(T4CConnection.java:854)"

[manodwhb]

@Not defined Not defined​ , you need to check that from your system, using SQL Developer are you able to connect to that DB? You can create connection in metedata in repository.

Thanks,

Manohar