mongodb - compound unique index using spring data not working

Question

I am trying to create unique compound index in mongodb using spring data.
But I see that the index is not created and the duplicate document is created in the DB.

My entity class:

@Document
@Getter
@Setter
@AllArgsConstructor
@NoArgsConstructor
@CompoundIndexes(
        @CompoundIndex(name = "daybook_index", def = "{'date' : 1, 'vehicleNumber' : 1}", unique = true)
)
public class Daybook {

    private String date;
    private String vehicleNumber;
    private String unit;
}

I am using repository.insert() method to create the document.

When I see in mongo express I see only one index created on _id and the index defined in the entity class is not created.

Is it a bug in spring data or am I doing something wrong?

P.S.: I tried to delete the collection too before running the application but didn't help.

G.S · Accepted Answer · 2022-05-16 15:07:36Z

3

As @Saxon mentioned:

Spring Data MongoDB 3.0, automatic index creation is turned off by default.

Instead of adding code, I am able to create the index by adding the spring data configuration in application.properties

spring.data.mongodb.auto-index-creation=true

answered May 16, 2022 at 15:07

G.S

11k8 gold badges43 silver badges56 bronze badges

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

Comments

Saxon · Accepted Answer · 2022-05-15 19:23:08Z

1

As of Spring Data MongoDB 3.0, automatic index creation is turned off by default. To turn it on you might use the proper flag overriding the method from MongoConfigurationSupport:

public class MongoConfiguration extends AbstractMongoClientConfiguration {
    .....
    @Override
    protected boolean autoIndexCreation() {
        return true;
    }
}

otherwise you might create the index with appropriate instructions.

mongoOperations.indexOps(Daybook.class).ensureIndex(new Index().on("date", Direction.ASC).on("vehicleNumber", Direction.ASC).unique());

answered May 15, 2022 at 19:23

Saxon

9374 silver badges8 bronze badges

Collectives™ on Stack Overflow

mongodb - compound unique index using spring data not working

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related