{"id":22899,"date":"2024-03-16T00:28:35","date_gmt":"2024-03-16T00:28:35","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/"},"modified":"2024-03-21T23:58:46","modified_gmt":"2024-03-21T23:58:46","slug":"how-does-logback-log-sql-statements","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/","title":{"rendered":"How does logback log SQL statements?"},"content":{"rendered":"

To print SQL logs using logback, you need to follow these steps:<\/p>\n

    \n
  1. pom.xml refers to the Project Object Model file in a Java project.<\/li>\n<\/ol>\n
    <dependency<\/span>><\/span>\r\n    <groupId<\/span>><\/span>ch.qos.logback<\/groupId<\/span>><\/span>\r\n    <artifactId<\/span>><\/span>logback-classic<\/artifactId<\/span>><\/span>\r\n    <version<\/span>><\/span>1.2.3<\/version<\/span>><\/span>\r\n<\/dependency<\/span>><\/span>\r\n<\/code><\/pre>\n
      \n
    1. The configuration file for logback is logback.xml.<\/li>\n
    2. logger<\/li>\n<\/ol>\n
      <configuration<\/span>><\/span>\r\n    <!-- \u5176\u4ed6\u914d\u7f6e --><\/span>\r\n    \r\n    <logger<\/span> name<\/span>=\"com.example.MySQL\"<\/span> level<\/span>=\"DEBUG\"<\/span>><\/span>\r\n        <appender-ref<\/span> ref<\/span>=\"CONSOLE\"<\/span> \/><\/span>\r\n    <\/logger<\/span>><\/span>\r\n    \r\n    <!-- \u5176\u4ed6\u914d\u7f6e --><\/span>\r\n<\/configuration<\/span>><\/span>\r\n<\/code><\/pre>\n
      In the  element, the name attribute specifies the path of the class for printing SQL logs, the level attribute specifies the log level (such as DEBUG, INFO, etc.), and the appender-ref element specifies the output target to be used.<\/p>\n
        \n
      1. logger is Slf4J<\/li>\n<\/ol>\n
        String<\/span> url<\/span> =<\/span> \"jdbc:mysql:\/\/localhost:3306\/mydb?logger=Slf4J\"<\/span>;\r\n<\/code><\/pre>\n
        In this way, when you use logback to log SQL statements, the log will be printed to the output destination specified in the logback configuration file.<\/p>\n
        Please note that the logging level in the above example is set to DEBUG, which means only SQL statements at the DEBUG level and above will be recorded. You can adjust the logging level according to your needs.<\/p>\n","protected":false},"excerpt":{"rendered":"
        To print SQL logs using logback, you need to follow these steps: pom.xml refers to the Project Object Model file in a Java project. <dependency> <groupId>ch.qos.logback<\/groupId> <artifactId>logback-classic<\/artifactId> <version>1.2.3<\/version> <\/dependency> The configuration file for logback is logback.xml. logger <configuration> <!– \u5176\u4ed6\u914d\u7f6e –> <logger name=”com.example.MySQL” level=”DEBUG”> <appender-ref ref=”CONSOLE” \/> <\/logger> <!– \u5176\u4ed6\u914d\u7f6e –> <\/configuration> In the element, […]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[],"class_list":["post-22899","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"\nHow does logback log SQL statements? - Blog - Silicon Cloud<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How does logback log SQL statements?\" \/>\n<meta property=\"og:description\" content=\"To print SQL logs using logback, you need to follow these steps: pom.xml refers to the Project Object Model file in a Java project. <dependency> <groupId>ch.qos.logback<\/groupId> <artifactId>logback-classic<\/artifactId> <version>1.2.3<\/version> <\/dependency> The configuration file for logback is logback.xml. logger <configuration> <!-- \u5176\u4ed6\u914d\u7f6e --> <logger name="com.example.MySQL" level="DEBUG"> <appender-ref ref="CONSOLE" \/> <\/logger> <!-- \u5176\u4ed6\u914d\u7f6e --> <\/configuration> In the element, […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\" \/>\n<meta property=\"og:site_name\" content=\"Blog - Silicon Cloud\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\" \/>\n<meta property=\"article:published_time\" content=\"2024-03-16T00:28:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-21T23:58:46+00:00\" \/>\n<meta name=\"author\" content=\"Sophia Anderson\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:site\" content=\"@SiliCloudGlobal\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Sophia Anderson\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"How does logback log SQL statements?\",\"datePublished\":\"2024-03-16T00:28:35+00:00\",\"dateModified\":\"2024-03-21T23:58:46+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\"},\"wordCount\":147,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\",\"name\":\"How does logback log SQL statements? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-16T00:28:35+00:00\",\"dateModified\":\"2024-03-21T23:58:46+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How does logback log SQL statements?\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"name\":\"Silicon Cloud Blog\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\",\"name\":\"Silicon Cloud Blog\",\"url\":\"https:\/\/www.silicloud.com\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"contentUrl\":\"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png\",\"width\":1024,\"height\":1024,\"caption\":\"Silicon Cloud Blog\"},\"image\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/SiliCloudGlobal\/\",\"https:\/\/twitter.com\/SiliCloudGlobal\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\",\"name\":\"Sophia Anderson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g\",\"caption\":\"Sophia Anderson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How does logback log SQL statements? - Blog - Silicon Cloud","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/","og_locale":"en_US","og_type":"article","og_title":"How does logback log SQL statements?","og_description":"To print SQL logs using logback, you need to follow these steps: pom.xml refers to the Project Object Model file in a Java project. <dependency> <groupId>ch.qos.logback<\/groupId> <artifactId>logback-classic<\/artifactId> <version>1.2.3<\/version> <\/dependency> The configuration file for logback is logback.xml. logger <configuration> <!-- \u5176\u4ed6\u914d\u7f6e --> <logger name=\"com.example.MySQL\" level=\"DEBUG\"> <appender-ref ref=\"CONSOLE\" \/> <\/logger> <!-- \u5176\u4ed6\u914d\u7f6e --> <\/configuration> In the element, […]","og_url":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-16T00:28:35+00:00","article_modified_time":"2024-03-21T23:58:46+00:00","author":"Sophia Anderson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Sophia Anderson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"How does logback log SQL statements?","datePublished":"2024-03-16T00:28:35+00:00","dateModified":"2024-03-21T23:58:46+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/"},"wordCount":147,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/","url":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/","name":"How does logback log SQL statements? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-16T00:28:35+00:00","dateModified":"2024-03-21T23:58:46+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-does-logback-log-sql-statements\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How does logback log SQL statements?"}]},{"@type":"WebSite","@id":"https:\/\/www.silicloud.com\/blog\/#website","url":"https:\/\/www.silicloud.com\/blog\/","name":"Silicon Cloud Blog","description":"","publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.silicloud.com\/blog\/#organization","name":"Silicon Cloud Blog","url":"https:\/\/www.silicloud.com\/blog\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","contentUrl":"https:\/\/www.silicloud.com\/blog\/wp-content\/uploads\/2023\/11\/EN-SILICON-Full.png","width":1024,"height":1024,"caption":"Silicon Cloud Blog"},"image":{"@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/SiliCloudGlobal\/","https:\/\/twitter.com\/SiliCloudGlobal"]},{"@type":"Person","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30","name":"Sophia Anderson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/c726c09aa40e37115fb5c62d0c3ed62c16ca255d3763e2e3ae83a70ddf8c2175?s=96&d=mm&r=g","caption":"Sophia Anderson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/sophiaanderson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22899","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/users\/7"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=22899"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22899\/revisions"}],"predecessor-version":[{"id":56846,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/22899\/revisions\/56846"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=22899"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=22899"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=22899"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}