Query DBRef with Spring Data MongoDB using QueryDSL

Question

I'm using Spring Data MongoDB and QueryDSL to perform some simple queries, but I'm having issues trying to use a predicate with a DBRef object's field.

It seems the DBRef are not resolved, so the query always returns empty results. There are some questions about this topic from 2014 mostly, and although there seem to have been some work done about it on both QueryDSL and Spring Data's side I still can't make it work and didn't find any working example.

I'm looking for a simple solution, as in the following simplified test case:

@Document
class Foo {
    @Id Integer id;
    @DBref Bar bar;
}

@Document
class Bar {
    @Id Integer id;
    String name;
}

interface FooRepository extends MongoRepository<Foo, Integer>, QueryDslPredicateExecutor<Foo> { ... }

and the query I'm trying to use :

fooRepository.findAll(QFoo.foo.bar.name.eq("test"))

I'm using QueryDSL 4.1.4, Spring Boot 1.5.3 with Spring Data MongoDB 1.10.3

Is this supported? Am I missing anything?

mp911de · Accepted Answer · 2017-06-01 20:41:37Z

2

TL;DR;

It's not supported.

Explanation

You're expressing a predicate that follows the reference into a different document.

MongoDB is a document-oriented database that knows no joins. Each document may contain subdocuments or references (which are sort of artificial). Also, each document has to be either looked up individually or fetched as a collection of documents based on a query.

Because there are no joins built-in to MongoDB you can't query across DBRef references. You can express a query that scans the subdocument as the subdocument is embedded.

Spring Data MongoDB exposes functionality provided by MongoDB in a more user-friendly way and does not pretend to provide functionality that isn's supported by MongoDB.

Since MongoDB 3.4, the aggregation framework supports $graphLookup to let MongoDB lookup during the aggregation stage to look up individual documents. Lookups are expensive and that's something you'd rather want to avoid.

answered Jun 1, 2017 at 20:41

mp911de

18.2k2 gold badges59 silver badges100 bronze badges

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

1 Comment

tranceholic Over a year ago

is there any another way beside $graphLookup ?

Collectives™ on Stack Overflow

Query DBRef with Spring Data MongoDB using QueryDSL

1 Answer 1

TL;DR;

Explanation

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

TL;DR;

Explanation

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related