topic Re: TMongoDBOutput cannot update document in Talend Studio

TMongoDBOutput cannot update document

Anonymous — Sat, 16 Nov 2024 03:38:09 GMT

Hi all,

I think this is very simple, but i have posted 3 times and no one can help.

I just find a way to update data from a Mongodb collection and then save it back to the right place.

So that, I use a tMongoDBInput to read data, and use tMap to change the data and finally use a tMongoDBOutput to save data

All the schemas have _id as key field already, and currently I set the Action on Data to Update

The job is running successfully, but there is no update in database.

Re: TMongoDBOutput cannot update document

fdenis — Thu, 09 Jan 2020 09:39:21 GMT

did you set a key value for the update?

Re: TMongoDBOutput cannot update document

Anonymous — Fri, 10 Jan 2020 04:40:01 GMT

Hi fdenis,

Yes, sure. I also change the type of the _ID into OBJECT to map the data type in database

Re: TMongoDBOutput cannot update document

Anonymous — Fri, 10 Jan 2020 06:51:23 GMT

Hello all,

I found it, just an wierd require from MongoDB syntax, let it here for other to refference

The problem here is cause by using Object ID (which is auto generated by Mongodb when you insert new document into the database). Just try to avoid using it as you key, but if you really want to use, please add ObjectID('[your document id here]').

That is all the story which take me out more than 1 week.