Convert Integer to String

[Anonymous]

I need to convert a primary key Interger to a String.
In the tMap I have written: (REF.REF_ID).toString() but the following error appears: "cannot invoke toString() on the primitive type int".
How can I convert it?
Thanks

[olektrolek]

try:
(new Integer(yourvalue)).toString()
hope this helps

[Anonymous]

Or you can use ""+REF.REF_ID

[Anonymous]

I see the "Perl" tag associated to this topic, but I don't think you're using a Perl project as Perl do this kind of conversion automatically. Can you confirm you're using Java?

[Anonymous]

Excuse me for the wrong information: my project is in java!
The solution (new Integer(REF.REF_ID)).toString() seems to work.
I had tried the: ""+REF.REF_ID without success!!
Thanks to every body.

[Anonymous]

I have replied to quick.
With the expression (new Integer(REF.REF_ID)).toString() the tMap expression builder don't make an error anymore. But the tMap component falls in error. The convertion of interger to string for a primary key is not possible.

[Anonymous]

Hi
Try this:
String.valueOf(REF.REF_ID)
Best regards
shong

[Anonymous]

hi Shong, I am facing similar issue (converting string to char). My input schema is string/char and output schema is char column from OracleSP. It says datatype/argument mismatch when I run the job. Pls suggest.

[ashok5]

Hi Pratik
you can use tconvertType component for converting column of one data type to other data type in talend
Regards
Ashok 

[janhess]

or you can Google it to find all the java conversions