Forum Discussion

aly's avatar
aly
New Contributor
9 years ago

Is it possible to connect to mongodb from soapUI opensource using овис component?

Hello I am now trying to connect to mongoDB from SoapUI opensource. I have seen some topics here but have not seen if it is possible to resolve this problem with JDBC component in SOAPUI? What I a...
rupert_anderson's avatar
rupert_anderson
Valued Contributor

Hi aly,

 

I never thought of using the JDBC TestStep to talk to MongoDB, quite interesting! I normally use the GMongo wrapper or MongoDB REST API instead, the GMongo Groovy TestStep option works great.

 

But, if I was to try I think the driver class and connection string may be different if you try a raw JDBC connection e.g.

 

JDBC Driver class name:  mongodb.jdbc.MongoDriver
URL format:              jdbc:mongo://<serverName>/<databaseName>

Taken from http://www.unityjdbc.com/mongojdbc/mongo_jdbc.php

 

Also I don't think adding the GMongo driver is necessary for the JDBC test step, as the GMongo is just a nice Groovy wrapper that the JDBC TestStep cant use - think it might just need the JDBC driver details. 

 

Does that help?

 

Otherwise, using the GMongo Groovy TestStep Option is suprisingly nice e.g. something like (needs both the drivers you added)

 

 import com.gmongo.GMongo
     
def mongo = new GMongo('localhost:27017')
def db = mongo.getDB('test')

log.info db.invoices.findOne()

I have also seen other use the Mongo REST API as a service / Request TestStep option - https://docs.mongodb.org/ecosystem/tools/http-interfaces/

 

Hope this helps,

Rup

 

Incidentally, 

TesterNo1's avatar
TesterNo1
Contributor
9 years ago

i tried  and could not get it working from JDBC test step.In jDBC step, you can write groovy code to access the db.It requires gmongo jar file and mongo diver  to be copied to ext folder .

  • rupert_anderson's avatar
    rupert_anderson
    Valued Contributor
    9 years ago

    Hi,

     

    Ok, I got this update from you on the ticket:

     

    http://screencast.com/t/WjMwVq54c

     

    Check teh screencast.It worked for me.

     

    Which looked cool, nice screencast to share the solution :-)

     

    But then you edited the post with whats currently written there - so are you ok with this now? or are there still problems I can try to help with?

     

    Thanks,

    Rupert

    • aly's avatar
      aly
      New Contributor
      9 years ago

      Hi,

       

      thanks for reply. I am using opensource version so I do not have Drivers options. Where did you take this link? Maybe I can try to do the same but with Global properties option? 

      • rupert_anderson's avatar
        rupert_anderson
        Valued Contributor
        9 years ago

        Hi Aly,

         

        I was actually replying to TesterNo1, he was the one who added that screencast link. It seemed he edited this reply.

         

        I think that driver manager (shown in his screencast) is a pro/Ready API feature (https://www.soapui.org/data-driven-tests/reference/jdbc-connections.html), so probaby not relavent to you. However the connection string and driver class shown may be helpful to you as I think yours are different? (as per my original reply) 

         

        Thanks,

        Rupert