topic integer assigning to string in Talend Studio

integer assigning to string

Ravi_Rajagopal — Mon, 10 Aug 2020 19:45:02 GMT

Hi I have an sql call to the database which retrieves an Integer variable. This is done through a component tdbinput, the data is retrieved from an oracle table. I am assigning the value of it to a global variable called vInvitationID. through tsetglobalvar. When I run the same, I am getting an error and the error says that "

java.lang.Integer cannot be cast to java.lang.String"

I haven't defined the variable vInvitationID as a String, hence I am confused as to where the definition happens. Kindly help

Re: integer assigning to string

manodwhb — Tue, 11 Aug 2020 07:28:47 GMT

@Ravichandran Rajagopal , you are trying to integer column to string column in tSetglobalvar component, please check if your are not able to find share the component settings.

Thanks,

Manohar

Re: integer assigning to string

Ravi_Rajagopal — Wed, 12 Aug 2020 13:29:49 GMT

Manohar thanks. Yesterday I got someone from Talend look at my job and he pointed me to the fact that I had two RunIF triggers go out of tsetglobalvar component where I was incorrectly referring to the global variable as string. Once I corrected the same to Integer the job progressed forward.