I'm trying to create a dynamic mongodb query using spring criteria. My
query is :  Criteria.where(key1).is(value1 .and(key2).is(value2)

If I use it the query works but if I try:

new
Criteria().andOperator(Criteria.where(key1).is(value1),Criteria.where(key2) .is(value2))

It doesn't works. I would want to use the second solutions because the
number of keys and values aren't fixed.

Can someone tell me what's the difference beetween these solutions or where
is the error?

I'll try to create manually the query but it doesn't work:

            BasicDBList andList = new BasicDBList();
            andList.add(new BasicDBObject(key1,value1));
            andList.add(new BasicDBObject(key2,value2));      
           BasicDBObject queryObject = new BasicDBObject("$and", andList);

 but                  
mongoTemplate.getCollection(collectionName).find(queryObject);
 is empty!

Can someone hel me to find errors?

 Thanks too much.

You should be able to use the BasicDBObject.toString() method to export the
query as JSON, which you can then copy/paste into the shell. Have you tried
running that outside of the Java application and confirming if it yields
the expected results?

Your second code example looks correct when compared to one of the answers
in http://stackoverflow.com/questions/10444038/mongo-db-query-in-java. The
only difference is that you were using a BasicDBList instead of an
ArrayList in the SO example, which I don't think is reason for concern.