topic org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68)) in Talend Studio

org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

smathew2949 — Fri, 15 Nov 2024 22:19:20 GMT

Hi Team,

i have code written in tJavaRow to convert my mongo DB row to LIST so that I can write them to JSON file. code was working on Talend 7.3 version with mongo connector 3.2.X but post upgrade to Talend 8 version which does not have 3.2.X connector i had to upgrade my mongo connector to 3.5.X post i started getting error as below . Please suggest what would be the alternative to this problem. Please the check the screenshot as well

Exception in component tJavaRow_5 (Copy_of_Dynamicsconnectiontest)

org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68)): expected a valid value (number, String, array, object, 'true', 'false' or 'null')

at [Source: java.io.StringReader@7dc51783; line: 1, column: 3]

at org.codehaus.jackson.JsonParser._constructError(JsonParser.java:1433)

at org.codehaus.jackson.impl.JsonParserMinimalBase._reportError(JsonParserMinimalBase.java:521)

at org.codehaus.jackson.impl.JsonParserMinimalBase._reportUnexpectedChar(JsonParserMinimalBase.java:442)

at org.codehaus.jackson.impl.ReaderBasedParser._handleUnexpectedValue(ReaderBasedParser.java:1198)

at org.codehaus.jackson.impl.ReaderBasedParser.nextToken(ReaderBasedParser.java:485)

at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:211)

at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:194)

at org.codehaus.jackson.map.deser.std.CollectionDeserializer.deserialize(CollectionDeserializer.java:30)

at org.codehaus.jackson.map.ObjectMapper._readMapAndClose(ObjectMapper.java:2732)

at org.codehaus.jackson.map.ObjectMapper.readValue(ObjectMapper.java:1863)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tMongoDBInput_11Process(Copy_of_Dynamicsconnectiontest.java:2839)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tMongoDBConnection_1Process(Copy_of_Dynamicsconnectiontest.java:2033)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tJava_2Process(Copy_of_Dynamicsconnectiontest.java:1819)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tLibraryLoad_2Process(Copy_of_Dynamicsconnectiontest.java:1682)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tLibraryLoad_1Process(Copy_of_Dynamicsconnectiontest.java:1528)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tPrejob_1Process(Copy_of_Dynamicsconnectiontest.java:1352)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.runJobInTOS(Copy_of_Dynamicsconnectiontest.java:

Re: org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

Anonymous — Tue, 29 Nov 2022 02:06:17 GMT

Hello @sherin mathew ,

The possible workaround is to switch back to mongo 3.2.x connector by the below steps:

download the mongo 3.2.x connector mongo-java-driver-2.14.3.jar from https://mvnrepository.com/artifact/org.mongodb/mongo-java-driver/2.14.3
install the downloaded jar by Window-show view ->Talend ->Modules view in the studio
in the job tLibraryLoad component, change back the library to mongo-java-driver-2.14.3.jar
then re-try the job

Re: org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

smathew2949 — Tue, 29 Nov 2022 03:02:11 GMT

Thanks @Aiming Chen post implementing the workaround i am getting below error . since Talend would have written the code based on latest connector it may not be accepting the old jar .

022-11-29T02:57:49.844 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_1 - Start to work.

2022-11-29T02:57:49.846 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_1 - Parameters:LIBRARY = mvn:org.codehaus.jackson/jackson-mapper-asl/1.9.13/jar | HOTLIBS = [{LIBPATH=}] | IMPORT = |

2022-11-29T02:57:49.846 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_1 - Done.

2022-11-29T02:57:49.846 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_2 - Start to work.

2022-11-29T02:57:49.847 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_2 - Parameters:LIBRARY = mvn:org.codehaus.jackson/jackson-core-asl/1.9.14-TALEND/jar | HOTLIBS = [] | IMPORT = //import java.util.List; |

2022-11-29T02:57:49.847 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_2 - Done.

2022-11-29T02:57:49.847 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_3 - Start to work.

2022-11-29T02:57:49.848 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_3 - Parameters:LIBRARY = "mvn:org.talend.libraries/mongo-java-driver-3.2.2/6.0.0-SNAPSHOT/jar" | HOTLIBS = [] | IMPORT = //import java.util.List; |

2022-11-29T02:57:49.848 [DEBUG] crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest- tLibraryLoad_3 - Done.

Job Execution started at Tue Nov 29 02:57:49 UTC 2022

Exception in thread "main" java.lang.NoSuchMethodError: com.mongodb.MongoClientOptions$Builder.applicationName(Ljava/lang/String;)Lcom/mongodb/MongoClientOptions$Builder;

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tMongoDBConnection_1Process(Copy_of_Dynamicsconnectiontest.java:2118)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tJava_2Process(Copy_of_Dynamicsconnectiontest.java:1994)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tLibraryLoad_3Process(Copy_of_Dynamicsconnectiontest.java:1857)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tLibraryLoad_2Process(Copy_of_Dynamicsconnectiontest.java:1703)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tLibraryLoad_1Process(Copy_of_Dynamicsconnectiontest.java:1549)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.tPrejob_1Process(Copy_of_Dynamicsconnectiontest.java:1373)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.runJobInTOS(Copy_of_Dynamicsconnectiontest.java:11582)

at crm_projects.copy_of_dynamicsconnectiontest_0_1.Copy_of_Dynamicsconnectiontest.main(Copy_of_Dynamicsconnectiontest.java:10776)

Re: org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

Anonymous — Tue, 29 Nov 2022 03:40:36 GMT

@sherin mathew , thanks for the feedback, please disable the old jar.

let's come back to the original issue, the problem is that there are invalid characters in the input_row.values string in tJavaRow_5 component, is it possible to output the json string and provide to us to check?

Re: org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

smathew2949 — Tue, 29 Nov 2022 06:08:50 GMT

Team here is the solution that worked for me after a lot of research

instead of jackson-mapper-asl library load jackson-databind library 2.11.4 version in your tJavaRow import change the import for datamapper to com.fasterxml.jackson.databind.ObjectMapper and if you are using the tmongodbinput then check the box to ConvertBson document to string.

Below is the screenshot

Re: org.codehaus.jackson.JsonParseException: Unexpected character ('D' (code 68))

Anonymous — Tue, 29 Nov 2022 06:31:15 GMT

Thanks for your feedback and share the solution here.

Best regards

Aiming