topic Re: Maximum Length Of Context Variable Value in Talend Studio

Maximum Length Of Context Variable Value

Bapps — Thu, 03 May 2018 20:23:47 GMT

Hi,

What's the maximum length for context variable value to be defined in Talend Open Studio?

I am facing below error with my running fine query, only difference I could see is I've parameterized it and passed values from context variable, not hardcoded in Talend job during deployment.

"Java Exception|tNetezzaInput_1|org.netezza.error.NzSQLException:The action you have attempted has caused the back end to close the connection."

Please advise if somebody has faced this error before and resolution about same.

Thanks

Re: Maximum Length Of Context Variable Value

manodwhb — Fri, 04 May 2018 05:47:11 GMT

@Bapps,context variables length is depending on the datatype what you specified.

please check the below links to knwo the datatypes maxium lengths.

https://docs.oracle.com/javase/tutorial/java/nutsandbolts/datatypes.html

http://zetcode.com/lang/java/datatypes/

https://www.tutorialspoint.com/java/java_basic_datatypes.htm

Re: Maximum Length Of Context Variable Value

Bapps — Fri, 11 May 2018 06:08:20 GMT

Thanks Manohar.

But this doesn't solve my problem