how to show query while using query annotations with MongoRepository with spring data

Question

I'm using MongoRepository in spring boot to access mongo:

public interface MongoReadRepository extends MongoRepository<User, String> {
    @Query(value = "{$where: 'this.name == ?0'}", count = true)
    public Long countName(String name);
}

and it could work, but i wonder know the exactly query it accessing mongo

how to do that?

i try to adding some config at properties like below:

logging.level.org.springframework.data.mongodb.core.MongoTemplate=DEBUG
logging.level.org.springframework.data.mongodb.repository.Query=DEBUG

and don't work.

could somebody help?

Luis Costa · Accepted Answer · 2016-09-27 09:56:39Z

99

I add the line (below) in application.properties and works fine:

logging.level.org.springframework.data.mongodb.core.MongoTemplate=DEBUG

for query:

@Query("{$and: [{'$or' : [{ 'name': {$regex : ?0, $options: 'i'}}, {'description': {$regex : ?1, $options: 'i'}}]}, { 'deleted' : ?2 }]}")

obtain this log:

2016-09-27 10:53:26.245 DEBUG 13604 --- [nio-9090-exec-3] o.s.data.mongodb.core.MongoTemplate      : find using query: { "$and" : [ { "$or" : [ { "name" : { "$regex" : "c" , "$options" : "i"}} , { "description" : { "$regex" : "c" , "$options" : "i"}}]} , { "deleted" : false}]} fields: null for class: class com.habber.domain.Entity in collection: entities

answered Sep 27, 2016 at 9:56

Luis Costa

1,1867 silver badges8 bronze badges

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

4 Comments

Luis Costa Over a year ago

make sure you have imported log4j

Vishal Arora Over a year ago

I even imported log4j and tried the same solution, but its not working for me

Ryan_D Over a year ago

remove the .MongoTemplate. It works as logging.level.org.springframework.data.mongodb.core

Artem Over a year ago

@VishalA check my comment, you may need to adjust your main logger configuration.

lin · Accepted Answer · 2024-01-09 09:37:50Z

37

Also, you can use a yml config file, put it in your application.yml file.

logging:
  level:
    org.springframework.data.mongodb.core.MongoTemplate: DEBUG

edited Jan 9, 2024 at 9:37

answered Feb 22, 2018 at 11:37

lin

1,5991 gold badge22 silver badges31 bronze badges

Comments

Wilder Valera · Accepted Answer · 2018-02-08 20:31:57Z

27

For ReactiveMongo add this property to your .properties file

logging.level.org.springframework.data.mongodb.core.ReactiveMongoTemplate=DEBUG

answered Feb 8, 2018 at 20:31

Wilder Valera

1,01910 silver badges11 bronze badges

Comments

Yubaraj · Accepted Answer · 2020-06-25 12:24:50Z

10

This is a late answer but I found the correct answer hasn't been given yet based on the question.

The answer already given by the people may be valid for other scenarios. But, if you are using the MongoRepository then the correct configuration would be the following:

logging.level.org.springframework.data.mongodb.repository.query= debug

You are using the Query in your configuration instead of query which is wrong.

When you add correct configuration then the logger would be like:

25-06-2020 17:58:43.301 [http-nio-9001-exec-10] DEBUG o.s.d.m.r.query.MongoQueryCreator.complete(162) - Created query Query: { "customer.id" : 2}, Fields: {}, Sort: {}

answered Jun 25, 2020 at 12:24

Yubaraj

4,0187 gold badges42 silver badges59 bronze badges

Comments

I.R. · Accepted Answer · 2023-01-23 11:37:56Z

1

The proposed solution is valid. But if you use @DocumentReference you may notice that N+1 queries won't appear in log.

If you want to know if referenced collection was queried, add the following property:

logging.level.org.springframework.data.mongodb.core.convert.MongoDatabaseFactoryReferenceLoader=TRACE

answered Jan 23, 2023 at 11:37

I.R.

5121 gold badge8 silver badges20 bronze badges

Comments

Ivan Rodrigues · Accepted Answer · 2022-03-16 15:59:59Z

0

I think that the complete solution is according @Wilder Valera and @Chaojun Zhong

When you want to log for MongoTemplate the answer:

logging:
   level:
       org.springframework.data.mongodb.core.MongoTemplate: DEBUG

When you want to log for ReactiveMongoTemplate you should use:

logging.level.org.springframework.data.mongodb.core.ReactiveMongoTemplate=DEBUG

answered Mar 16, 2022 at 15:59

Ivan Rodrigues

4694 silver badges21 bronze badges

Comments

Artem · Accepted Answer · 2023-07-19 15:59:11Z

0

Keep in mind, that even if you do

logging:
  level:
    org:
      springframework:
        data:
          mongodb:
            core:
              MongoTemplate: DEBUG

you still may not be able to see the DEBUG statements if your main logger's configuration set to output only INFO messages. In our case, we had a logback.xml where we had an appender for frameworks with level: INFO. Until we changed this one as well to DEBUG we didn't see the queries from MongoDB:

<appender name="FRAMEWORKS" class="ch.qos.logback.core.ConsoleAppender">
        <filter class="ch.qos.logback.classic.filter.ThresholdFilter">
            <level>DEBUG</level>
        </filter>
        ...
</appender>

answered Jul 19, 2023 at 15:59

Artem

2,5602 gold badges24 silver badges45 bronze badges

Collectives™ on Stack Overflow

how to show query while using query annotations with MongoRepository with spring data

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

7 Answers 7

4 Comments

Comments

Comments

Comments

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related