How to log Spring-data queries to a Couchbase Database












1















In my Spring-Boot app we have a Spring-Data repository connection to the Couchbase server.



I know that when connecting to SQL server, one can see the actual queries sent to the DB by adding to the property file line such as this one (As mentioned here):



logging.level.org.hibernate.SQL=DEBUG


What should be the way to do it when using Couchbase?










share|improve this question



























    1















    In my Spring-Boot app we have a Spring-Data repository connection to the Couchbase server.



    I know that when connecting to SQL server, one can see the actual queries sent to the DB by adding to the property file line such as this one (As mentioned here):



    logging.level.org.hibernate.SQL=DEBUG


    What should be the way to do it when using Couchbase?










    share|improve this question

























      1












      1








      1








      In my Spring-Boot app we have a Spring-Data repository connection to the Couchbase server.



      I know that when connecting to SQL server, one can see the actual queries sent to the DB by adding to the property file line such as this one (As mentioned here):



      logging.level.org.hibernate.SQL=DEBUG


      What should be the way to do it when using Couchbase?










      share|improve this question














      In my Spring-Boot app we have a Spring-Data repository connection to the Couchbase server.



      I know that when connecting to SQL server, one can see the actual queries sent to the DB by adding to the property file line such as this one (As mentioned here):



      logging.level.org.hibernate.SQL=DEBUG


      What should be the way to do it when using Couchbase?







      spring-data-jpa spring-data couchbase n1ql






      share|improve this question













      share|improve this question











      share|improve this question




      share|improve this question










      asked Nov 19 '18 at 11:15









      riorioriorio

      1,88131034




      1,88131034
























          2 Answers
          2






          active

          oldest

          votes


















          2














          Add logback as your dependency



              <dependency>
          <groupId>ch.qos.logback</groupId>
          <artifactId>logback-classic</artifactId>
          <version>1.2.3</version>
          </dependency>


          and add the file logback.xml to your resources folder:



          <configuration>
          <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
          <encoder>
          <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
          </encoder>
          </appender>

          <root level="debug">
          <appender-ref ref="STDOUT" />
          </root>




          If I remember it correctly, you can enable dubug level only in the class that prints the query with the following configuration:



          <configuration>
          <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
          <encoder>
          <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
          </encoder>
          </appender>

          <logger name="org.springframework.data.couchbase.repository.query" level="debug" />

          <root level="info">
          <appender-ref ref="STDOUT" />
          </root>







          share|improve this answer































            1














            Following deniswasrosa's answer I was able to see the queries just by adding this to the yml file:



            logging:
            level:
            org.springframework.data.couchbase.repository.query: DEBUG


            I had no need to add the dependency.






            share|improve this answer
























            • Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

              – deniswsrosa
              Nov 21 '18 at 16:24











            Your Answer






            StackExchange.ifUsing("editor", function () {
            StackExchange.using("externalEditor", function () {
            StackExchange.using("snippets", function () {
            StackExchange.snippets.init();
            });
            });
            }, "code-snippets");

            StackExchange.ready(function() {
            var channelOptions = {
            tags: "".split(" "),
            id: "1"
            };
            initTagRenderer("".split(" "), "".split(" "), channelOptions);

            StackExchange.using("externalEditor", function() {
            // Have to fire editor after snippets, if snippets enabled
            if (StackExchange.settings.snippets.snippetsEnabled) {
            StackExchange.using("snippets", function() {
            createEditor();
            });
            }
            else {
            createEditor();
            }
            });

            function createEditor() {
            StackExchange.prepareEditor({
            heartbeatType: 'answer',
            autoActivateHeartbeat: false,
            convertImagesToLinks: true,
            noModals: true,
            showLowRepImageUploadWarning: true,
            reputationToPostImages: 10,
            bindNavPrevention: true,
            postfix: "",
            imageUploader: {
            brandingHtml: "Powered by u003ca class="icon-imgur-white" href="https://imgur.com/"u003eu003c/au003e",
            contentPolicyHtml: "User contributions licensed under u003ca href="https://creativecommons.org/licenses/by-sa/3.0/"u003ecc by-sa 3.0 with attribution requiredu003c/au003e u003ca href="https://stackoverflow.com/legal/content-policy"u003e(content policy)u003c/au003e",
            allowUrls: true
            },
            onDemand: true,
            discardSelector: ".discard-answer"
            ,immediatelyShowMarkdownHelp:true
            });


            }
            });














            draft saved

            draft discarded


















            StackExchange.ready(
            function () {
            StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373431%2fhow-to-log-spring-data-queries-to-a-couchbase-database%23new-answer', 'question_page');
            }
            );

            Post as a guest















            Required, but never shown

























            2 Answers
            2






            active

            oldest

            votes








            2 Answers
            2






            active

            oldest

            votes









            active

            oldest

            votes






            active

            oldest

            votes









            2














            Add logback as your dependency



                <dependency>
            <groupId>ch.qos.logback</groupId>
            <artifactId>logback-classic</artifactId>
            <version>1.2.3</version>
            </dependency>


            and add the file logback.xml to your resources folder:



            <configuration>
            <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
            <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
            </encoder>
            </appender>

            <root level="debug">
            <appender-ref ref="STDOUT" />
            </root>




            If I remember it correctly, you can enable dubug level only in the class that prints the query with the following configuration:



            <configuration>
            <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
            <encoder>
            <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
            </encoder>
            </appender>

            <logger name="org.springframework.data.couchbase.repository.query" level="debug" />

            <root level="info">
            <appender-ref ref="STDOUT" />
            </root>







            share|improve this answer




























              2














              Add logback as your dependency



                  <dependency>
              <groupId>ch.qos.logback</groupId>
              <artifactId>logback-classic</artifactId>
              <version>1.2.3</version>
              </dependency>


              and add the file logback.xml to your resources folder:



              <configuration>
              <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
              <encoder>
              <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
              </encoder>
              </appender>

              <root level="debug">
              <appender-ref ref="STDOUT" />
              </root>




              If I remember it correctly, you can enable dubug level only in the class that prints the query with the following configuration:



              <configuration>
              <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
              <encoder>
              <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
              </encoder>
              </appender>

              <logger name="org.springframework.data.couchbase.repository.query" level="debug" />

              <root level="info">
              <appender-ref ref="STDOUT" />
              </root>







              share|improve this answer


























                2












                2








                2







                Add logback as your dependency



                    <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.2.3</version>
                </dependency>


                and add the file logback.xml to your resources folder:



                <configuration>
                <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
                <encoder>
                <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
                </encoder>
                </appender>

                <root level="debug">
                <appender-ref ref="STDOUT" />
                </root>




                If I remember it correctly, you can enable dubug level only in the class that prints the query with the following configuration:



                <configuration>
                <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
                <encoder>
                <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
                </encoder>
                </appender>

                <logger name="org.springframework.data.couchbase.repository.query" level="debug" />

                <root level="info">
                <appender-ref ref="STDOUT" />
                </root>







                share|improve this answer













                Add logback as your dependency



                    <dependency>
                <groupId>ch.qos.logback</groupId>
                <artifactId>logback-classic</artifactId>
                <version>1.2.3</version>
                </dependency>


                and add the file logback.xml to your resources folder:



                <configuration>
                <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
                <encoder>
                <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
                </encoder>
                </appender>

                <root level="debug">
                <appender-ref ref="STDOUT" />
                </root>




                If I remember it correctly, you can enable dubug level only in the class that prints the query with the following configuration:



                <configuration>
                <appender name="STDOUT" class="ch.qos.logback.core.ConsoleAppender">
                <encoder>
                <pattern>%d{HH:mm:ss.SSS} [%thread] %-5level %logger{36} - %msg%n</pattern>
                </encoder>
                </appender>

                <logger name="org.springframework.data.couchbase.repository.query" level="debug" />

                <root level="info">
                <appender-ref ref="STDOUT" />
                </root>








                share|improve this answer












                share|improve this answer



                share|improve this answer










                answered Nov 19 '18 at 12:14









                deniswsrosadeniswsrosa

                522514




                522514

























                    1














                    Following deniswasrosa's answer I was able to see the queries just by adding this to the yml file:



                    logging:
                    level:
                    org.springframework.data.couchbase.repository.query: DEBUG


                    I had no need to add the dependency.






                    share|improve this answer
























                    • Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                      – deniswsrosa
                      Nov 21 '18 at 16:24
















                    1














                    Following deniswasrosa's answer I was able to see the queries just by adding this to the yml file:



                    logging:
                    level:
                    org.springframework.data.couchbase.repository.query: DEBUG


                    I had no need to add the dependency.






                    share|improve this answer
























                    • Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                      – deniswsrosa
                      Nov 21 '18 at 16:24














                    1












                    1








                    1







                    Following deniswasrosa's answer I was able to see the queries just by adding this to the yml file:



                    logging:
                    level:
                    org.springframework.data.couchbase.repository.query: DEBUG


                    I had no need to add the dependency.






                    share|improve this answer













                    Following deniswasrosa's answer I was able to see the queries just by adding this to the yml file:



                    logging:
                    level:
                    org.springframework.data.couchbase.repository.query: DEBUG


                    I had no need to add the dependency.







                    share|improve this answer












                    share|improve this answer



                    share|improve this answer










                    answered Nov 21 '18 at 12:13









                    riorioriorio

                    1,88131034




                    1,88131034













                    • Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                      – deniswsrosa
                      Nov 21 '18 at 16:24



















                    • Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                      – deniswsrosa
                      Nov 21 '18 at 16:24

















                    Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                    – deniswsrosa
                    Nov 21 '18 at 16:24





                    Thanks, I will write a post on Couchbase's blog about that to document this whole thing.

                    – deniswsrosa
                    Nov 21 '18 at 16:24


















                    draft saved

                    draft discarded




















































                    Thanks for contributing an answer to Stack Overflow!


                    • Please be sure to answer the question. Provide details and share your research!

                    But avoid



                    • Asking for help, clarification, or responding to other answers.

                    • Making statements based on opinion; back them up with references or personal experience.


                    To learn more, see our tips on writing great answers.




                    draft saved


                    draft discarded














                    StackExchange.ready(
                    function () {
                    StackExchange.openid.initPostLogin('.new-post-login', 'https%3a%2f%2fstackoverflow.com%2fquestions%2f53373431%2fhow-to-log-spring-data-queries-to-a-couchbase-database%23new-answer', 'question_page');
                    }
                    );

                    Post as a guest















                    Required, but never shown





















































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown

































                    Required, but never shown














                    Required, but never shown












                    Required, but never shown







                    Required, but never shown







                    Popular posts from this blog

                    Guess what letter conforming each word

                    Port of Spain

                    Run scheduled task as local user group (not BUILTIN)