Springboot With Mongodb Error while using find*() query

Question

I am getting the following error:

at com.aks.springStorage.SpringStorageApplication.main(SpringStorageApplication.java:22) [classes/:na]
Caused by: org.springframework.data.mongodb.UncategorizedMongoDbException: Query failed with error code 2 and error message 'Field 'locale' is invalid in: { locale: "company" }' on server localhost:27017; nested exception is com.mongodb.MongoQueryException: Query failed with error code 2 and error message 'Field 'locale' is invalid in: { locale: "company" }' on server localhost:27017

Strange thing is I am not using any variable like "locale" in company collection. I am able to insert and able to get the count, but none of the findAll* are working, getting the same error.

public interface CompanyRepository extends MongoRepository<Company, String> {
    List<Company> findByName(String name);

    @Query("{'contact.address': ?0}")
    List<Company> findByAddress(String address);
}

@Document(collation = "company")
public class Company {
    private int id;
    private String name;
    private List<Product> products;
    private Contact contact;

    public Company(int id, String name, List<Product> products, Contact contact) {
        this.id = id;
        this.name = name;
        this.products = products;
        this.contact = contact;
    }

    public int getId() {
        return id;
    }

    public void setId(int id) {
        this.id = id;
    }

    public String getName() {
        return name;
    }

    public void setName(String name) {
        this.name = name;
    }

    public List<Product> getProducts() {
        return products;
    }

    public void setProducts(List<Product> products) {
        this.products = products;
    }

    public Contact getContact() {
        return contact;
    }

    public void setContact(Contact contact) {
        this.contact = contact;
    }
}

// Client code:      
//this is working fine
int count = (int) companyRepo.count();

// Failing Here
companies = companyRepo.findByName("yy");

@MadhavKumarJha thanks! it was a typo error, I changed to collection. it worked. — Akhil Patro
– Akhil Patro, Commented Dec 30, 2019 at 16:48
The elusive "this question is a typo but should stay because it's an infuriatingly easy auto-complete typo" question! — chrylis -cautiouslyoptimistic-
– chrylis -cautiouslyoptimistic-, Commented Jul 30, 2020 at 4:05

Archie · Accepted Answer · 2019-12-30 16:18:03Z

107

@Document(collation="company")

This looks like a typo and the cause of your issue. You try to set collection name, but instead of collection you use collation property: https://docs.mongodb.com/manual/reference/collation/

The correct form of annotation would be:

@Document(collection = "company")
public class Company {
    // ...
}

Or simpler – since value is an alias for collection:

@Document("company")
public class Company {
    // ...
}

You can even completely omit collection name. In that case Spring will use class name as collection name:

@Document // name of collection wil be "company", as per class name
public class Company {
    // ...
}

The last example is why this was working for you with e.g. count queries, even though you did not provide collection name explicitly.

edited Dec 30, 2019 at 16:18

answered Dec 30, 2019 at 16:05

Archie

6,9316 gold badges38 silver badges44 bronze badges

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

3 Comments

Dhrumil Shah Over a year ago

this is issue with intellij AutoSuggest :)

Coney Over a year ago

Helps a lot, facing the same issue

prabath shalitha Over a year ago

Facing same issue. Thanks a lot..!

Mahadi Hasan · Accepted Answer · 2021-05-25 04:15:07Z

14

This sometime happens when you miss annotated entity class with annotation @Document

Wrong @Document(collation = "department")
Right @Document(collection = "department")

answered May 25, 2021 at 4:15

Mahadi Hasan

1671 silver badge9 bronze badges

1 Comment

micartey Over a year ago

Hahah, this is exactly what got me :D

Procrastinator · Accepted Answer · 2022-05-04 07:05:05Z

6

On my side i used @Document(collection = "products") and worked. Use collection instead of collation in @Document.

edited May 4, 2022 at 7:05

Procrastinator

2,67445 gold badges31 silver badges37 bronze badges

answered Apr 29, 2022 at 12:35

Timotheo Mhoja

612 silver badges4 bronze badges

Comments

whoami - fakeFaceTrueSoul · Accepted Answer · 2023-06-20 12:58:12Z

0

I use @Document(collection = "main class/name of database or collection") instead of collation and it works, for example @Document(collection ="student")

edited Jun 20, 2023 at 12:58

whoami - fakeFaceTrueSoul

18.1k6 gold badges35 silver badges51 bronze badges

answered Jun 20, 2023 at 4:30

Shiv Choudhary

1011 silver badge2 bronze badges

Comments

Today's No-Code Recommender · Accepted Answer · 2023-09-07 04:02:54Z

0

change @Document(collation = "company") to @Document(collection = "company")

answered Sep 7, 2023 at 4:02

Today's No-Code Recommender

11 bronze badge

Collectives™ on Stack Overflow

Springboot With Mongodb Error while using find*() query

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

3 Comments

1 Comment

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related