topic Re: String to int conversion in Talend Studio

String to int conversion

_AnonymousUser — Sat, 16 Nov 2024 14:04:34 GMT

Hello,
I am trying to convert a String into an int. I am using the expression:
Integer.parseInt(Name.SECURITY_LEVEL)
What I get when I test the expression is:
Exception in component tRowGenerator_1
and
Multiple markers at this line
- Syntax error on token ")", AssignmentOperator expected after
this token
- The left-hand side of an assignment must be a variable
I don't understand. Doesn't this expression return an int?
Thanks for any help,
Jim Long

Re: String to int conversion

Anonymous — Thu, 12 Feb 2009 21:28:36 GMT

Hi Jim,
where did you entered that code? In a tMap?
Bye
Volker

Re: String to int conversion

_AnonymousUser — Thu, 12 Feb 2009 23:02:22 GMT

Hello Volker,
Yes, this is in a tMap. Name.SECURITY_LEVEL is a number String (i.e. "1", "3", "9"). The new schema has an integer for this field. The transformation is simple, yet I am mystified by the error message I am getting.
Thanks,
Jim

Re: String to int conversion

_AnonymousUser — Thu, 12 Feb 2009 23:21:05 GMT

Hello Volker,
I opened my project again and looked at the tMap. I am getting a new error message now. My expression is:
Integer.parseInt(Name.SECURITY_LEVEL)
The message I am getting is:
This method must return a result of type int.
parseInt is a public static int.
Thanks,
Jim Long

Re: String to int conversion

Anonymous — Thu, 12 Feb 2009 23:31:33 GMT

Hi,
I can see you have this error "Exception in component tRowGenerator_1" so the error might be even before the tMap component.
You're right, this method returns an Integer. The tmap should look like this.

Re: String to int conversion

_AnonymousUser — Fri, 13 Feb 2009 00:36:02 GMT

Hello Volker,
....hmmm.
This is the transformation I have entered. I will pull the data out into a tLogRow to see what is coming out of the ODBC data source. I will let you know what I discover.
Thanks,
Jim Long

Re: String to int conversion

_AnonymousUser — Fri, 13 Feb 2009 03:57:35 GMT

Hello Volker,
I pulled the data into into a tLogRow and I am getting the same result. However, even through the expression builder reports an error, the function seems to convert the String to an Integer just fine.
Let me know if you learn anything else.
Thanks,
Jim Long

Re: String to int conversion

Anonymous — Fri, 13 Feb 2009 05:36:32 GMT

Hi Jim,
a) you code looks correct.
b) the example of nhaumont too. So if you use it the same way it should work.
If the error still exists, please give us the following two information:
- The generated code around the error. You'll have a line number where the error occurs, switch to the code view and copy some line berore and after this line number.
- Give us a screen shot of the actual component where it happens. Search the code upwards to next comment to see the component name
Bye
Volker Brehm

Re: String to int conversion

Anonymous — Fri, 13 Feb 2009 10:00:46 GMT

Hello,
as nhaumont suggested, your error is not in the tMap but in the tRowGenerator_1.
Can you post a screenshot of it.
regards,
benjamin

Re: String to int conversion

Anonymous — Fri, 13 Feb 2009 13:57:22 GMT

Hi benjamin, hi nhaumont,
I think the message "Exception in component tRowGenerator_1" is related to the created class in the code (not the component). So it should happen in every component and to take a look into the code is the only way to be sure.
Bye
Volker

Re: String to int conversion

Anonymous — Thu, 30 Aug 2012 15:57:04 GMT

Hello,
Was any solution to this problem ever found? I am experiencing the same problem... any advice appreciated. Based on the responses above, I am attaching an image of the tMap and the file with tRowGenerator_1 code.
Thanks,
Jeremy
EDIT: it did not let me attach the code, so pasting it in here. file Expression_builder_RowGenerator2.java:

// ============================================================================
//
// Copyright (c) 2005-2010, Talend Inc.
//
// This source code has been automatically generated by_Talend Open Studio for Data Integration
// / JobDesigner (CodeGenerator version 5.0.2.r78327)
// You can find more information about Talend products at www.talend.com.
// You may distribute this code under the terms of the GNU LGPL license
// . <

To see the whole post, download it here
OriginalPost.pdf