topic url_tELTOracleOutput cannot be assigned to a variable in Talend Studio

url_tELTOracleOutput cannot be assigned to a variable

Anonymous — Tue, 27 Aug 2019 15:13:51 GMT

I am trying to perform a basic ELT operation but I keep getting the error "Detail Message: url_tELTOracleOutput_1 cannot be resolved to a variable". Looking at the Java code, when the output tries to establish a connection it is trying to use a variable that has never been declared

java.sql.Connection conn_tELTOracleOutput_1 = java.sql.DriverManager
							.getConnection(url_tELTOracleOutput_1,
							atnParamsPrope_tELTOracleOutput_1);

Here's an image of my simple job. I've based it on the examples provided on the Talend help center.

All three components are setup to be connected to the same database. The database connection parameters have been put into a context that are loaded in at the start of the job using implicit context load.

Can anyone help me figure out why this variable isn't getting declared anywhere, or if there is a different way to us tELTOracleOutput?

Re: url_tELTOracleOutput cannot be assigned to a variable

Anonymous — Wed, 04 Sep 2019 10:29:57 GMT

Hello,

Have you defined the 'schema' or metadata of your input source? Which could cause Talend to generate faulty code. Your ELT component setting screenshots will be preferred.

Best regards

Sabrina

Re: url_tELTOracleOutput cannot be assigned to a variable

Anonymous — Mon, 09 Sep 2019 14:50:22 GMT

Hi Sabrina,

Thanks for the response.

It seems that problem was that I was using an Oracle OCI/Wallet connection. It worked when I switched the connection type to Oracle with Service Name.