topic tOracleInput Exception java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344)....... in Talend Studio

tOracleInput Exception java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

paresh1 — Sat, 16 Nov 2024 01:52:20 GMT

Hi ,

For the above flow getting exception at tOracleInput with Use fetch size enabled:

java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

When I disable Use fetch size it is working fine.

Please help what can I do if I want to use fetch size functionality.

Thanks

Re: tOracleInput Exception java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

manodwhb — Fri, 17 Jul 2020 09:46:44 GMT

@Paresh Pawar , Have you checked the Use an existing connection in basic setting of tDBInput? if yes you need to connect the tDBConnection to tDBInput using on subjob ok. and One mor thing that there is a warning sign in to most right side of the component in tDBInput what was that? I feel you have not configured tDBInput properly.

Re: tOracleInput Exception java.lang.NullPointerException at oracle.sql.converter.CharacterConverter1Byte.toUnicodeChars(CharacterConverter1Byte.java:344).......

paresh1 — Fri, 17 Jul 2020 12:00:33 GMT

@Manohar B Thanks for your quick response.

Have you checked the Use an existing connection in basic setting of tDBInput? ----Yes I have selected Component list using existing connection.

I tried with subjob ok still same error.

The warning sign is for date pattern values. Even if I specify the date pattern values it is still throwing same error.