How to get data from MongoDB version 3.4 using Java?

Question

I am trying to collect data from my mongodb in java, I need to use select query and put it in jtextarea. Select Query will be filled with combo box element.

Here is the code:

/**** Connect to MongoDB ****/

MongoClientURI connectionString = new MongoClientURI("mongodb://localhost:27017");
MongoClient mClient = new MongoClient(connectionString);

/**** Get database ****/
MongoDatabase db = mClient.getDatabase("productDB");

mClient.getAddress();
/**** Get collection / table from 'productDB' ****/
MongoCollection<Document> tableCollection = db.getCollection("local");
/**** Find and display ****/
Document whereQuery = new Document();
whereQuery.put("Product Category",categoryCB.getSelectedIndex());



MongoCursor<Document> cursor = tableCollection.find(whereQuery);
mClient.close();

In tableCollection.find shows:

cannot convert from FindIterable to MongoCursor

Is there any way to do this differently?

Tharun · Accepted Answer · 2017-11-10 13:14:17Z

1

You are trying to receive a FindIterable object in a MongoCursor reference.

Change thetype of the reference variable 'cursor' from MongoCursor to FindIterable or its supertype MongoIterable.

FindIterable<Document> cursor = tableCollection.find(whereQuery);

(or)

MongoIterable<Document> cursor = tableCollection.find(whereQuery);

answered Nov 10, 2017 at 13:14

Tharun

3112 silver badges14 bronze badges

Sign up to request clarification or add additional context in comments.

3 Comments

Selim Over a year ago

your code doesn't show anything, i tried to put it in jtextarea but cannot get result, by the way thank you for your effort :).

Tharun Over a year ago

You have to iterate over the result to get your data.

Selim Over a year ago

How to do that? i am new at java and i do not like Java at all :D.

Selim · Accepted Answer · 2017-11-11 18:43:08Z

0

I have found code for this problem and it works, main part is in code below

mClient = new MongoClient(connectionString);
db = mClient.getDatabase("Your Database Name");

tableCollection = db.getCollection("Your Table Name");
whereQuery = new Document();

whereQuery.put("Your Attribute", typeCB.getSelectedItem().toString());
iterator=tableCollection.find(whereQuery);
cursor = iterator.iterator();

while (cursor.hasNext()) 
{
      /*put your code here*/
}

answered Nov 11, 2017 at 18:43

Selim

116 bronze badges

Collectives™ on Stack Overflow

How to get data from MongoDB version 3.4 using Java?

2 Answers 2

3 Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

3 Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related