Forum Discussion
HimanshuTayal
7 years agoCommunity Hero
Hi ekta_sriv ,
Not sure about JDBC step but i have did the same using groovy with (mongo-java-driver-3.4.2) driver you can have a look at below code:
import com.mongodb.MongoClient;
import com.mongodb.MongoClientURI;
String url = "mongodb://USER_NAME:PSWD@PORT/?authSource=AUTH_SOURCE&authMechanism=AUTH_MECHANISM"
MongoClientURI client = new MongoClientURI(url);
MongoClient mongoClient = new MongoClient(client);
DB db = mongoClient.getDB("YOUR DB NAME");
DBCollection collec = db.getCollection("YOUR DB COLLECTION NAME");
BasicDBObject query = new BasicDBObject();
query.append("some_parameter",value);
//execute query
def queryExec = collec.find(query);
while (cursor.hasNext())
{
//YOUR CODE to fetch values;
}
mongoClient.close();