MongoDB-Java connection - Not able to query a collection from Java Program, getting socket exception

[Tan Ban]

I'm trying to query Mongocollection from Java Program. Connection is LDAP. Everything looks OK, till I create a MongoCursor object. But at the line where MongoCursor object is created, I'm getting socket exception as follows

INFO: Closed connection [connectionId{localValue:2}] to "Host:Port" because there was a socket exception raised by this connection.

Message-Exception authenticating MongoCredential{mechanism=PLAIN, userName='uname', source='dbname', password=hidden, mechanismProperties={}}

I'm wondering, Am I following the right way to query a collection, to retrieve documents (here I'm using 'create date' criteria). Why Am I getting socket excpetion?

Here is what I tried so far-

import java.io.FileInputStream;
import java.io.FileNotFoundException;
import java.io.IOException;
import java.util.ArrayList;
import java.util.List;
import java.util.Properties;
import org.bson.Document;
import com.mongodb.BasicDBObject;
import com.mongodb.DBCursor;
import com.mongodb.MongoClient;
import com.mongodb.MongoCredential;
import com.mongodb.ServerAddress;
import com.mongodb.client.MongoCollection;
import com.mongodb.client.MongoCursor;
import com.mongodb.client.MongoDatabase;

public class MongoDBCon {
    private static Properties prop;
    private static FileInputStream fis;
    public static void main(String[] args) throws Exception {
    try {
        prop =  new Properties();
        fis = new FileInputStream(System.getProperty("user.dir")+"\\src\\config.properties");
        prop.load(fis);
        String user = prop.getProperty("username");
        String password = prop.getProperty("password");
        String host =prop.getProperty("host");
        String db = prop.getProperty("database");
        String col = prop.getProperty("collection");

        List<ServerAddress> seeds = new ArrayList<ServerAddress>();
        seeds.add( new ServerAddress( host));
        List<MongoCredential> credentials = new ArrayList<MongoCredential>();
        credentials.add(
            MongoCredential.createPlainCredential(user, db, password.toCharArray())
        );
        MongoClient mongo = new MongoClient( seeds, credentials );
        MongoDatabase database = mongo.getDatabase(db);
        MongoCollection<Document> collection = database.getCollection(col);
        BasicDBObject query=new BasicDBObject();
        query.put("createdDate","2018-10-30 03:21:05.226");
        MongoCursor<Document> cursor = collection.find(query).iterator();
        while (cursor.hasNext()) {
            System.out.println(cursor.next().toJson());
        }   
    }catch(Exception e) {
        System.out.println("Message-" + e.getMessage());
    }

    }

}

[VikasKumar Gupta]

Dear Tan,
I think your collection has huge data and your search query is also returning huge data. Please check if you collection is indexed properly. Try to count records in your query and if count shows huge no of records then try to use skip and limit to get data data in batch.

Regards,
Vikas