Talend community forum / Type conversion with global variable

chesofai · 2012-07-09 12:25:07

Hi all,

I am trying to get a value resulted from a SQL query in global variable, but i have the error below:

Exception in component tMysqlInput_1
java.lang.ClassCastException: java.lang.String cannot be cast to java.lang.Integer

Below the components i used:
- tmysqlSP: executing stored procedure to load a specific table
- tmysqlinput (errotab): getting the number of rows in tthe table using a query with count(*) and storing this value in a global variable(cpt).
- tmsgbox: displaying a specific message depending the IF link condition

It seems that by definition Talend considers a global variable as a String, I tried the (Integer) cast but it gave me the error above.

Best Regards

Uploaded Images

Last edited by chesofai (2012-07-09 12:27:57)

kzone · 2012-07-09 17:58:31

hi chesofai

did you try with tConvertType component !?

regards
laurent

chesofai · 2012-07-09 18:59:19

Hi Kzone,

No i didn't try it.
I am trying to workaround my issue by comparing Strings. But my new issue is that in my TMysqlinput, i have a query
like "select count(*) as value from errortable" and i want to get the value returned by the query in a global variable, but i don't know if it can work?
I created i variable called "cpt" having the value "value" (from sql query!), but it seems that the Global variable is not getting the value!!

How can i get the value of the SQL query ??

than you so much

kzone · 2012-07-09 23:04:31

i've changed the request by :

Code:

"SELECT count(*) as nbre
FROM `id24945`"

and it work fine !

retrieve the job (item) if you like on my github

regards
laurent

Uploaded Images

Last edited by kzone (2012-07-09 23:12:33)

chesofai · 2012-07-10 13:08:54

thank you Kzone,

I am using TOS 5.0.2, tried to import your talend job and it failed.
then downloaded TOS 5.1, tried to import again the talend job, but it didn't work.

could you help please? or send me the snashot for all the components especially , the tsetglobalvar and the IF !!

Regards

kzone · 2012-07-11 08:53:47

sorry for delay,

I'll post screenshot tonight !

laurent

kzone · 2012-07-11 22:03:36

I have import item in 5.1.1 and works fine
use the right button to do it ...

nerver mind see screenshoot

about if , what is the condition to display message?

laurent

Uploaded Images

chesofai · 2012-07-17 10:05:28

Hi Kzone,

Sorry for the delay in answering you, i was sick these days.
I did as you showed and it worked, using the IF condition comparing the strings:

!((String)(globalMap.get("cpt"))).equals("0") where "cpt" is the global variable resulting from the select query.

My aim was to compare the "cpt" to 0, but i am always having an error saying that cannot convert value, so i decied to
compare strings!

Do you have an idea to make the IF condition comparing the integer values instead of strings ??? ( i already tried to cast the condition using (Integer).

Regards

Announcement

Unanswered posts

#1 2012-07-09 12:25:07

Type conversion with global variable

#2 2012-07-09 17:58:31

Re: Type conversion with global variable

#3 2012-07-09 18:59:19

Re: Type conversion with global variable

#4 2012-07-09 23:04:31

Re: Type conversion with global variable

Code:

#5 2012-07-10 13:08:54

Re: Type conversion with global variable

#6 2012-07-11 08:53:47

Re: Type conversion with global variable

#7 2012-07-11 22:03:36

Re: Type conversion with global variable

#8 2012-07-17 10:05:28

Re: Type conversion with global variable

Board footer