Creating a collection with validation in MongoDB 3.4 using Java

Question

I am trying to create a collection with validation in MongoDB(3.4) via Java.

This is working fine when executed in the shell:

  db.createCollection( "accounts",
   {
      validator: { $and:
         [
            { username: { $type: "string" } },
            { email: { $regex: /@*\.*$/ } },
            { password: { $type: "string" } }
         ]
      }
   }
)

So now I wanted to create the same collection with that validation in java. Sadly the previous answers I have found here are using deprecated methods.

This is what I tried since the validator field is an option field.

//String createDatabase = "{ 'validator': { '$and':[{ 'username': { '$type': 'string' } },{ 'email': { '$regex': '@*.*$' } },{ 'password': { '$type': 'string' } }]}}";
String createDatabase =  " { \"validator\": { \"$and\":[{ \"username\": { \"$type\": \"string\" } },{ \"email\": { \"$regex\": \"@*.*$\" } },{ \"password\": { \"$type\": \"string\" } }]}}";
JsonParser jsonParser = new JsonParser();
DBObject dbobj= (DBObject) JSON.parse(createDatabase);
getMongoClient().getDatabase(DATABASE_NAME).createCollection(collectionName, new CreateCollectionOptions().validationOptions(new ValidationOptions().validator((Bson) dbobj)) );

This is the exception I got. I assume that's because somehow the json cannot be parsed, I checked back if it's valid and it should be.

   {
      "validator": { "$and":
         [
            { "username": { "$type": "string" } },
            { "email": { "$regex": "@*.*$" } },
            { "password": { "$type": "string" } }
         ]
      }
   }

Above is the json that I tried to parse.

 com.mongodb.MongoCommandException: Command failed with error 2: 'unknown operator: $and' on server localhost:27017. The full response is { "ok" : 0.0, "errmsg" : "unknown operator: $and", "code" : 2, "codeName" : "BadValue" }

Andriy Simonov · Accepted Answer · 2018-02-06 23:26:53Z

1

Well, you can use the Filters utility class API to build the validator as it described in the documentation. Here is the code:

    Bson username = Filters.type("username", BsonType.STRING);
    Bson email = Filters.regex("email", "@*.*$");
    Bson password = Filters.type("password", BsonType.STRING);

    Bson validator = Filters.and(username, email, password);

    ValidationOptions validationOptions = new ValidationOptions()
                                          .validator(validator);
    database.createCollection("accounts", new CreateCollectionOptions()
                                          .validationOptions(validationOptions));

It creates a collection with validation on MongoDB 3.4.

answered Feb 6, 2018 at 23:26

Andriy Simonov

1,3081 gold badge12 silver badges22 bronze badges

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

1 Comment

rhewid Over a year ago

Thank you, exactly what I was searching for!

Collectives™ on Stack Overflow

Creating a collection with validation in MongoDB 3.4 using Java

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related