Problem with converting Oracle SQL query to Mongodb Java equivalent

[Russell West]

I am very new to Mongodb development and have been tasked to convert a Java application that originally accessed an Oracle database to access a Mongodb database.  I have been successful in converting simple queries but have not been able to successfully generate the Mongodb Java equivalent to the following Oracle sql query.  Any and all assistance is greatly appreciated.

 

String query_str = "select * from table1 where field1 like " ' + value1 + "%" +  ' " +

                             " and field2 between " + fld2min + " and " fld2max +

                             " and field3 between " + fld3min + " and " fld3max;

 

Thanks,

Russell

                            

[Nishant Bhardwaj]

Hi Russell,

As you know MongoDB is a Document database, and usually there is no direct 1-1 mapping between SQL tables and MongoDB collection. Since relational databases and document databases such as MongoDB have different approaches to the same problem. It will be good to review Database Modeling in the MongoDB manual.

You are right in asking how things in SQL world are related to MongoDB terminology. Following links from MongoDB manual are good starting points :

• SQL to MongoDB Mapping Chart.
• SQL to Aggregation Mapping Chart

You might as well want to review Use Cases in the MongoDB manual, similar to yours.

Regards,

Nishant

​