topic Re: Context Variable from txt file in Talend Studio

Context Variable from txt file

Velu_R — Sat, 16 Nov 2024 01:05:22 GMT

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.

Re: Context Variable from txt file

manodwhb — Thu, 19 Nov 2020 07:32:31 GMT

@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

Re: Context Variable from txt file

Velu_R — Thu, 19 Nov 2020 07:41:41 GMT

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)"

Re: Context Variable from txt file

manodwhb — Thu, 19 Nov 2020 08:04:13 GMT

@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