topic Re: Talend is not generating "getBytes" for data type "byte[]" in Talend Studio

Talend is not generating "getBytes" for data type "byte[]"

billxu — Fri, 15 Nov 2024 21:49:13 GMT

Hello,

Could any body please help on this?

Situation:

Using Talend to fetch data from AS400
There're some columns having wrong character set settings in AS400
Fetching these columns by getString will get unreadable characters or meet a conversion fail error

What I am doing:

Edited schema to change the type of these columns from String to byte[]
Added auto conversion for converting byte[] to String (by calling a custom routine)
Expecting a getBytes call will be added when assigning value of these columns.

I expect that there will be a block of code like " rs_tDBInput_1.getBytes " generated by Talend.

But Talend only generates an "if" block with an empty "else" block.

Please refer the attached screenshot.

So are there any steps I missed when doing such schema customizing?

Or how to solve this kind of code generating problem?

Best regards

Bill

Re: Talend is not generating "getBytes" for data type "byte[]"

Anonymous — Mon, 15 May 2023 03:16:41 GMT

I suggest you to open a jira issue on our bugtracker for R&D team to investigate it and discuss directly with developers.

Regards

Shong

Re: Talend is not generating "getBytes" for data type "byte[]"

billxu — Fri, 09 Jun 2023 08:16:48 GMT

Hello Shong,

Sorry for late reply.

I have created jira issue on your bugtracker.

It seems that your dev team are working on improving non-free versions only.

Hope this has already been fixed in non-free versions, and if it is possible you may consider apply fixes to free versions as well.

Anyway, I am using tJavaRow to fix this bug in my jobs. It's now not bothering me any more.

Thank you!

Best regards,

Bill

Re: Talend is not generating "getBytes" for data type "byte[]"

Anonymous — Fri, 09 Jun 2023 10:19:13 GMT

Hi @Bill Xu Thanks for your response, although a bit late. Our developers have responded to you with a request for more information.

Re: Talend is not generating "getBytes" for data type "byte[]"

billxu — Mon, 12 Jun 2023 02:42:26 GMT

Hi Shong,

Not able to find my reported issue in Jira....

Not shown in "My Open Issue" or "Reported by Me"...

Searched it for about 30mins in all issues, still not found...😥

Re: Talend is not generating "getBytes" for data type "byte[]"

Anonymous — Mon, 12 Jun 2023 03:06:25 GMT

@Bill Xu here is the jira issue, can you confirm you can't see it?

https://jira.talendforge.org/browse/TDI-49926

This issue has been set to 'Talend internal (Only Talend employees will be able to see the issue)'.

Re: Talend is not generating "getBytes" for data type "byte[]"

billxu — Mon, 12 Jun 2023 03:12:10 GMT

Tried to access it using issue no., but failed with "You can't view this issue"...😓

Re: Talend is not generating "getBytes" for data type "byte[]"

Anonymous — Mon, 12 Jun 2023 04:06:33 GMT

I am not familiar with JIRA permission issues, let me check with my colleagues internally.

Re: Talend is not generating "getBytes" for data type "byte[]"

Anonymous — Mon, 12 Jun 2023 04:12:16 GMT

We have changed the security level to 'None', you should be able to view it now. ;）

Re: Talend is not generating "getBytes" for data type "byte[]"

billxu — Mon, 12 Jun 2023 06:42:20 GMT

Thank you! I replied the message from your dev team.

Re: Talend is not generating "getBytes" for data type "byte[]"

billxu — Mon, 19 Jun 2023 08:57:52 GMT

Many thanks to Talend's dev team.

This problem can be solved by just changing columns type to align with db type.

(1) There is no need to add a custom data type in mapping (in this case, I added a data type named "RAW" for java data type "byte[]"),

(2) and the columns type in schema should not be configured with types not in default mapping (in this case, "RAW" is not in default mapping).

(3) Otherwise, tDBInput won't recognize the data type correctly and won't generate codes for it. (in this case, custom added "RAW" is not recognized by tAS400DBInput, so that tAS400DBInput doesn't know which getter shall be used for it, and leaves blank only)

Best regards,

Bill XU