topic Re: data Type "boolean " in Talend Studio

data Type "boolean "

Anonymous — Sat, 16 Nov 2024 04:59:09 GMT

Hello,

How to convert data type String with "true" to data type boolean with "1".

Thank you

Best regards

Re: data Type "boolean "

manodwhb — Tue, 13 Aug 2019 09:45:56 GMT

@hamza-sellami ,can you provide some example of source and target data?

below the way.

row1.data.equals("1") ? true : false

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 09:50:57 GMT

i have a an string in couloumn1 source with "true" as value. and in target i have a boolean type with bit(1).

so i want convert "true" to "1".

Best regards

Re: data Type "boolean "

manodwhb — Tue, 13 Aug 2019 09:56:17 GMT

@hamza-sellami ,check the below way .

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 09:59:27 GMT

i want 0 or 1 in Target

like this but not working

row2.licence_info_mutation_gratuite_confirmee .equals(true) ? "1" : "0"

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 10:02:06 GMT

and with your solution i have this message:

Re: data Type "boolean "

manodwhb — Tue, 13 Aug 2019 10:15:10 GMT

@hamza-sellami ,i believe your source data type is boolean,you no need to convert ,what is your target type?

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 14:30:13 GMT

@hamza-sellami

Assuming your source is Boolean data and target is integer, could you please try below code snippet?

row2.licence_info_mutation_gratuite_confirmee ? 1 : 0

It will pick 1 if the boolean value is true else it will be 0.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 14:32:56 GMT

Hello,

My target is boolean, and my source is string with 3 values (false, true or null).

Best regards

Re: data Type "boolean "

Anonymous — Tue, 13 Aug 2019 14:35:12 GMT

Hi,

What is your source data type? The error is showing that source data itself is having boolean data type.

Warm Regards,
Nikhil Thampi

Please appreciate our Talend community members by giving Kudos for sharing their time for your query. If your query is answered, please mark the topic as resolved

Re: data Type "boolean "

JR1 — Wed, 14 Aug 2019 19:13:19 GMT

The error "cannot convert Boolean to String does not suggest that the input is of type Boolean. This error simply occurs because you passed a boolean value into the String method "equals" when you do the following

row2.licence_info_mutation_gratuite_confirmee.equals(true) ? "1" : "0"

Please try the following (exactly as it is shown here):

row2.licence_info_mutation_gratuite_confirmee == null ? null : (row2.licence_info_mutation_gratuite_confirmee.equals("true") ? 1 : 0)

I am not sure what you mean with the target type is "boolean with bit(1)". If it is an Integer, the above should work. If it is a Boolean, the following should work:

row2.licence_info_mutation_gratuite_confirmee == null ? null : row2.licence_info_mutation_gratuite_confirmee.equals("true")

Re: data Type "boolean "

Anonymous — Sun, 18 Aug 2019 09:53:49 GMT

Hello,

my target is boolean and source is String.

when i use this method :

row2.licence_info_mutation_gratuite_confirmee == null ? null : (row2.licence_info_mutation_gratuite_confirmee.equals(true) ? true : false)

i have this error:

User variable name 'tDBOutputBulkExec_1_tMBE_licence_info_mutation_gratuite_confirmee' is illegal

Thanks

Re: data Type "boolean "

JR1 — Sun, 18 Aug 2019 12:10:01 GMT

If you input is a string and the target is boolean, the expression has to be

row2.licence_info_mutation_gratuite_confirmee == null ? null : row2.licence_info_mutation_gratuite_confirmee.equals("true")

Please note the double quotes around "true". Please replace "row2" with the name of your input flow.

As for your error: I do not know how your job (schemas and connections) is set up. In principle, I do not use underscores in column names (use camel case instead) and I try to avoid such long names for columns but I do not think this is the issue here. Nevertheless, I believe this has nothing to do with your original problem.

Re: data Type "boolean "

Anonymous — Mon, 19 Aug 2019 07:26:57 GMT

Hi,

I just tried your expression, still not working.

Re: data Type "boolean "

JR1 — Mon, 19 Aug 2019 07:42:14 GMT

Sorry, but if you do not provide more details about your job, no one will be able help you with this.

Re: data Type "boolean "

Anonymous — Mon, 19 Aug 2019 09:04:55 GMT

Hello,

my job is:

My tconvertType 2:

mon tmap is:

My error is:

Exception in component tDBOutputBulkExec_1_tMBE (ODS_Collecte_Preparation_licence_info_1)
java.sql.SQLSyntaxErrorException: User variable name 'tDBOutputBulkExec_1_tMBE_licence_info_mutation_gratuite_confirmee' is illegal
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:781)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.tDBInput_1Process(ODS_Collecte_Preparation_licence_info_1.java:6664)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.runJobInTOS(ODS_Collecte_Preparation_licence_info_1.java:9494)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.main(ODS_Collecte_Preparation_licence_info_1.java:9169)

thanks for your reply

Re: data Type "boolean "

JR1 — Mon, 19 Aug 2019 09:23:38 GMT

OK, so you are already converting your input string to a Boolean in the tConvertType component. Why are you bothering with further conversion in the tMap? You already have a boolean value in the input of the tMap and simply need to pass it along to the output:

row2.licence_info_mutation_gratuite_confirmee

Please try this again with this expression. I still believe, the error has nothing to do with your original problem and originates from the DB output component.

Re: data Type "boolean "

Anonymous — Mon, 19 Aug 2019 09:27:30 GMT

i have the same error:

Exception in component tDBOutputBulkExec_1_tMBE (ODS_Collecte_Preparation_licence_info_1)
java.sql.SQLSyntaxErrorException: User variable name 'tDBOutputBulkExec_1_tMBE_licence_info_mutation_gratuite_confirmee' is illegal
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:120)
	at com.mysql.cj.jdbc.exceptions.SQLError.createSQLException(SQLError.java:97)
	at com.mysql.cj.jdbc.exceptions.SQLExceptionsMapping.translateException(SQLExceptionsMapping.java:122)
	at com.mysql.cj.jdbc.StatementImpl.executeInternal(StatementImpl.java:781)
	at com.mysql.cj.jdbc.StatementImpl.execute(StatementImpl.java:666)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.tDBInput_1Process(ODS_Collecte_Preparation_licence_info_1.java:6659)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.runJobInTOS(ODS_Collecte_Preparation_licence_info_1.java:9489)
	at ffh.ods_collecte_preparation_licence_info_1_0_1.ODS_Collecte_Preparation_licence_info_1.main(ODS_Collecte_Preparation_licence_info_1.java:9164)
Mon Aug 19 10:24:58 CEST 2019 WARN:

thanks

Re: data Type "boolean "

JR1 — Mon, 19 Aug 2019 09:34:14 GMT

Again, this is most likely unrelated to your original problem and lies in your output component. From the little I can see, the component cannot create a SQL statement for MySQL. Maybe the column name is too long for MySQL - I am not a MySQL expert.