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
@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.
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.
