Forum Discussion

SriAchar's avatar
SriAchar
Occasional Contributor
8 years ago

Connection to MongoDB

Hi All,   I am trying to connect to MongoDB using Groovy. Here is what I have tried:   import com.gmongo.GMongo def mongo = new GMongo("<server_name>:<port>") def db = mongo.getDB("<DB_Name>") ...
SriAchar's avatar
SriAchar
Occasional Contributor
8 years ago

Hi Rupert,

 

As in your example, I am using this:

 

import com.gmongo.*
import com.mongodb.*
import com.gmongo.GMongo
import com.mongodb.MongoCredential

 

def credential = MongoCredential.createMongoCRCredential("<username>", "<database>","<password>".toCharArray())
log.info "credential excepted"
log.info credential

 

def client = new MongoClient(new ServerAddress("<server address>",port), [credential])
log.info "client excepted"
log.info client

 

def mongo = new GMongo (client)
log.info "mongo excepted"
log.info mongo

 

def db = mongo.getDB("<database>")
log.info "db excepted"
log.info db

 

def collection = db.getCollection("<collection>")
log.info "collection excepted"
log.info collection

 

log.info collection.findOne(<key1>:"<value1>").<key2>

 

I am getting the error: ERROR:com.mongodb.MongoTimeoutException: Timed out after 30000 ms while waiting for a server that matches ReadPreferenceServerSelector{readPreference=primary}. Client view of cluster state is {type=UNKNOWN, servers=[{address=<address>, type=UNKNOWN, state=CONNECTING, exception={com.mongodb.MongoSocketReadTimeoutException: Timeout while receiving message}, caused by {java.net.SocketTimeoutException: Read timed out}}].

 

Using the log.info, I am getting the logs till "collection expected" and collection info. Hence, I am assuming, it connected but was not able to execute the last line.

 

Also, in your example, the first line is:

@Grab(group='com.gmongo', module='gmongo', version='1.3')

I am not sure how to use this. Putting that in my script, the error comes up:

java.lang.NoClassDefFoundError: org/apache/ivy/core/settings/IvySettings

Thanks,

Srikanth

    • rupert_anderson's avatar
      rupert_anderson
      Valued Contributor
      8 years ago

      Hi Srikanth,

       

      To use Grape dependencies in SoapUI you need to add the ivy jar to the lib folder, then it will download and resolve the gmongo dependency on-the-fly, if you want to do this please see:

       

      http://rupertanderson.com/blog/r2-soapui-groovy-grape-dependencies/

       

      Otherwise, you can manually add the gmongo jar to the /ext folder, as nmrao suggested (should have the same effect) - however, I think you have probably already done this?

       

      If I get a chance I'll install a test mongo db locally and setup authentication, so that I can test your code.

       

      Thanks,

      Rupert

      • SriAchar's avatar
        SriAchar
        Occasional Contributor
        8 years ago

        Hi Rao and Rupert,

         

        Thanks for your replies.

         

        Two cases:
        1) I have downloaded the ivy-2.2.0.jar and placed it in \SmartBear\SoapUI-5.2.1\lib and deleted gmongo-1.5.jar from \SmartBear\SoapUI-5.2.1\bin\ext folder
        2) Having the gmongo-1.5.jar at \SmartBear\SoapUI-5.2.1\bin\ext and deleted the ivy-2.2.0.jar in the \SmartBear\SoapUI-5.2.1\lib

        Both cases I am getting the error (as mentioned in my message above)

         

        Thanks,

        Srikanth