jongo | Query in Java as in Mongo shell

I have two large text files containing a list of dependencies.

The first file contains a list of dependencies in a project sorted by service a small snippet of the file looks like this:

project_dependencies.txt:

I use MongoDB via Jongo (a Java client), and I need to sort results in a case-insensitive way for a particular query.

MongoDB's documentation states that an index should be created with a certain collation level, and that the queries should use the same configuration :

I'm tring to implement aggregation operations for Mongo data service in WSO2DSS (in WSO2EI) since only the basic operations like CRUD and Count are supported out of the box as mentioned here. So I cloned WSO2EI code version 4.4.10 (our team happens to be using this version) and I've successfully added some of my own functionality. However, whenever I try to use org.jongo.MongoCollection.aggregate() function, I get error Error in MongoQuery.runQuery: Command failed with error 9: 'The 'cursor' option is required, except for aggregate with the explain argument'. I checked all the posts regarding this issue and tried to use different versions of Mongo driver (3.4, 3.6..), also changed the actual syntax a lot but no matter what I try, I always get this error if I use the .aggregate() function. Also should I be using org.jongo.MongoCollection.aggregate(String pipelineOperator) or com.mongodb.async.client.aggregate(java.util.List pipeline) as stated in the Mongo Java 3.6 documentation here. Example code I used:

I have a class which contains other some properties of another classes and when I try to convert from json to my class, there is an error displayed.

This is my class:

I want to use Jongo for date queries. The user should be able to enter a string with the query, so I want to use the find method with a string. I am using groovy.

My code:

i want to retrieve first two character value like if i give 02-01-2017 00:05:46 i should get result like

I have a Play! 2.5.3 project with one subproject (with its own routes). In the main routes file the subproject's routes are defined as follows:

In my diploma thesis I developed REST API for select/save operations between client and database. Data will be post from sensors as JSON and stored in MongoDB . We chose three different technologies for storing: Jongo driver 1.3.0, Java MongoDB driver 3.4.0 and MongoRepository from Spring (with Jackson FasterXML). After implemenetation we started with load tests through JMeter. Test case had these parameters:

threads - 100, 250, 500, 1000

ramp up period - 10 seconds

loop count - 30

We are supposed that drivers will be more effective than MongoRepository, but in case of 1000 threads MongoRepository load 400 requests per second and drivers could not process all of requests. So MongoRepository can store rapidly fast. Can anyone says why MongoRepository is more effective ?

EDIT:

MongoRepository look like this:

I am combining Spring Boot and jongo/mongo to create a dynamic mongo app that does not use POJO's. Everything in and out of the database is a Map. I have everything working exactly the way I want, except one thing. I don't want to send _id from mongo to the client. This system uses a "mark obsolete and insert new record" style of updates so we can maintain a change history for the document. therefore, I don't want any client to even be tempted to use the _id field, I have another I want them to use.

Now I find all kinds of examples on how to ignore fields in pojo's, but i want to write a Jackson Map serializer that ignores a specific value of the map. I can't find anything like that yet. I suppose gson would do as well, I just don't currently have spring configured for gson.

any idea how to write this serializer?