Forum Discussion

Deepali's avatar
Deepali
Occasional Contributor
10 years ago

How 'find' command to be used to fetch results from mongoDB using groovy in soap ui

Below is the groovy code snippet I have written.   DB db = mongoClient.getDB( "qahmedb" ); DBCollection coll = db.getCollection("Hotel"); log.info "Collection Hotel selected successfully" DBCurs...
Groovy
MongoDB
Deepali's avatar
Deepali
Occasional Contributor
10 years ago

Thanks Rao for your help...but I have already tried this...but no luck.

  • nmrao's avatar
    nmrao
    Community Hero
    10 years ago
    Was that your complete script? Can you post the stacktrace from error.log? By the way how many records that you get in the collection.
    • Deepali's avatar
      Deepali
      Occasional Contributor
      10 years ago


      import com.mongodb.*
      import com.mongodb.MongoCredential as MC
      import com.mongodb.ServerAddress
      def credential = MC.createMongoCRCredential( "<username>",
      "<DBname>",
      "<pwd>".toCharArray() )
      def mongoClient = new MongoClient( new ServerAddress("<server sddress>"), [ credential ] )

      log.info "Connect to database successfully"
      DB db = mongoClient.getDB( "qahmedb" );
      DBCollection coll = db.getCollection("Hotel");
      log.info "Collection Hotel selected successfully"

      DBCursor cursor = coll.find({City_en : 'Orlando' });
      List list1 = new ArrayList();
      while( cursor.hasNext() )
      {
      def hotel = cursor.next()
      log.info "Found Hotels with ID $hotel._id and name $hotel.Title_en"
      }

       

       

       

      Stack trace:

       

      2016-01-25 15:56:32,000 ERROR [errorlog] org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'DBCollection{database=DB{name='qahmedb'}, name='Hotel'}' with class 'com.mongodb.DBCollection' to class 'com.mongodb.DBCursor'
      org.codehaus.groovy.runtime.typehandling.GroovyCastException: Cannot cast object 'DBCollection{database=DB{name='qahmedb'}, name='Hotel'}' with class 'com.mongodb.DBCollection' to class 'com.mongodb.DBCursor'
      at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.continueCastOnSAM(DefaultTypeTransformation.java:405)
      at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.continueCastOnNumber(DefaultTypeTransformation.java:319)
      at org.codehaus.groovy.runtime.typehandling.DefaultTypeTransformation.castToType(DefaultTypeTransformation.java:232)
      at org.codehaus.groovy.runtime.ScriptBytecodeAdapter.castToType(ScriptBytecodeAdapter.java:603)
      at Script43.run(Script43.groovy:15)
      at com.eviware.soapui.support.scripting.groovy.SoapUIGroovyScriptEngine.run(SoapUIGroovyScriptEngine.java:92)
      at com.eviware.soapui.support.scripting.groovy.SoapUIProGroovyScriptEngineFactory$SoapUIProGroovyScriptEngine.run(SoapUIProGroovyScriptEngineFactory.java:76)
      at com.eviware.soapui.impl.wsdl.teststeps.WsdlGroovyScriptTestStep.run(WsdlGroovyScriptTestStep.java:155)
      at com.eviware.soapui.impl.wsdl.panels.teststeps.GroovyScriptStepDesktopPanel$RunAction$1.run(GroovyScriptStepDesktopPanel.java:263)
      at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
      at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
      at java.lang.Thread.run(Unknown Source)

       

       

      With condition City_en : 'Orlando', it has 3 records, while in total it has 500+ records.

      It gives successful result when done without any condition in find query.

       

    • Deepali's avatar
      Deepali
      Occasional Contributor
      10 years ago

      Any help would be great regarding the above problem.

       

      Thanks

      Deepali

      • Harshini's avatar
        Harshini
        New Contributor
        8 years ago

        Hi Deepali,

         

        Query has to used as DB object when you put to find() method. Hope below query helps

         

        Try the below code

        try
        {
        BasicDBObject allQuery = new BasicDBObject();
        allQuery.put("_id", "000000000001093467822SO01");

        DBCursor cursor =dbColl.find(allQuery);
        //DBCursor cursor =dbColl.find();
        JSON json =new JSON();
        String serialize = json.serialize(cursor);
        System.out.println(serialize);
        //List list1 = new ArrayList();
        while(cursor.hasNext())
        {
        def var = cursor.next()
        log.info "Party id $var"
        }
        } catch (UnknownHostException e) {
        // TODO Auto-generated catch block
        e.printStackTrace();
        }

         

        Harshini Kasa