{"id":9876,"date":"2024-03-14T10:17:11","date_gmt":"2024-03-14T10:17:11","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/"},"modified":"2024-03-20T16:33:24","modified_gmt":"2024-03-20T16:33:24","slug":"how-can-you-close-connections-in-the-druid-connection-pool","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/","title":{"rendered":"How can you close connections in the Druid connection pool?"},"content":{"rendered":"<p>When using the Druid connection pool to close connections, you can call the close() method of the connection object to release connection resources. An example is shown below:<\/p>\n<pre class=\"post-pre\"><code><span class=\"hljs-keyword\">import<\/span> com.alibaba.druid.pool.DruidDataSource;\r\n<span class=\"hljs-keyword\">import<\/span> java.sql.Connection;\r\n<span class=\"hljs-keyword\">import<\/span> java.sql.SQLException;\r\n\r\n<span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">class<\/span> <span class=\"hljs-title class_\">DruidConnectionPoolExample<\/span> {\r\n\r\n    <span class=\"hljs-keyword\">public<\/span> <span class=\"hljs-keyword\">static<\/span> <span class=\"hljs-keyword\">void<\/span> <span class=\"hljs-title function_\">main<\/span><span class=\"hljs-params\">(String[] args)<\/span> {\r\n        <span class=\"hljs-comment\">\/\/ \u521b\u5efaDruid\u8fde\u63a5\u6c60<\/span>\r\n        <span class=\"hljs-type\">DruidDataSource<\/span> <span class=\"hljs-variable\">dataSource<\/span> <span class=\"hljs-operator\">=<\/span> <span class=\"hljs-keyword\">new<\/span> <span class=\"hljs-title class_\">DruidDataSource<\/span>();\r\n        dataSource.setUrl(<span class=\"hljs-string\">\"jdbc:mysql:\/\/localhost:3306\/test\"<\/span>);\r\n        dataSource.setUsername(<span class=\"hljs-string\">\"root\"<\/span>);\r\n        dataSource.setPassword(<span class=\"hljs-string\">\"password\"<\/span>);\r\n\r\n        <span class=\"hljs-keyword\">try<\/span> {\r\n            <span class=\"hljs-comment\">\/\/ \u83b7\u53d6\u8fde\u63a5<\/span>\r\n            <span class=\"hljs-type\">Connection<\/span> <span class=\"hljs-variable\">connection<\/span> <span class=\"hljs-operator\">=<\/span> dataSource.getConnection();\r\n            \r\n            <span class=\"hljs-comment\">\/\/ \u6267\u884c\u6570\u636e\u5e93\u64cd\u4f5c<\/span>\r\n            <span class=\"hljs-comment\">\/\/ ...<\/span>\r\n\r\n            <span class=\"hljs-comment\">\/\/ \u5173\u95ed\u8fde\u63a5<\/span>\r\n            connection.close();\r\n        } <span class=\"hljs-keyword\">catch<\/span> (SQLException e) {\r\n            e.printStackTrace();\r\n        } <span class=\"hljs-keyword\">finally<\/span> {\r\n            <span class=\"hljs-comment\">\/\/ \u5173\u95ed\u8fde\u63a5\u6c60<\/span>\r\n            dataSource.close();\r\n        }\r\n    }\r\n}\r\n<\/code><\/pre>\n<p>In the example above, a Druid connection pool object is first created, and a connection is obtained through the getConnection() method. After the database operation is completed, the connection is closed by calling connection.close(), and finally the dataSource.close() is called in the finally block to close the connection pool. This ensures that the connection resources are properly released.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>When using the Druid connection pool to close connections, you can call the close() method of the connection object to release connection resources. An example is shown below: import com.alibaba.druid.pool.DruidDataSource; import java.sql.Connection; import java.sql.SQLException; public class DruidConnectionPoolExample { public static void main(String[] args) { \/\/ \u521b\u5efaDruid\u8fde\u63a5\u6c60 DruidDataSource dataSource = new DruidDataSource(); dataSource.setUrl(&#8220;jdbc:mysql:\/\/localhost:3306\/test&#8221;); dataSource.setUsername(&#8220;root&#8221;); dataSource.setPassword(&#8220;password&#8221;); try [&hellip;]<\/p>\n","protected":false},"author":14,"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-9876","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v21.5 (Yoast SEO v21.5) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How can you close connections in the Druid connection pool? - 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-can-you-close-connections-in-the-druid-connection-pool\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How can you close connections in the Druid connection pool?\" \/>\n<meta property=\"og:description\" content=\"When using the Druid connection pool to close connections, you can call the close() method of the connection object to release connection resources. An example is shown below: import com.alibaba.druid.pool.DruidDataSource; import java.sql.Connection; import java.sql.SQLException; public class DruidConnectionPoolExample { public static void main(String[] args) { \/\/ \u521b\u5efaDruid\u8fde\u63a5\u6c60 DruidDataSource dataSource = new DruidDataSource(); dataSource.setUrl(&quot;jdbc:mysql:\/\/localhost:3306\/test&quot;); dataSource.setUsername(&quot;root&quot;); dataSource.setPassword(&quot;password&quot;); try [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\" \/>\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-14T10:17:11+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2024-03-20T16:33:24+00:00\" \/>\n<meta name=\"author\" content=\"Noah Thompson\" \/>\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=\"Noah Thompson\" \/>\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-can-you-close-connections-in-the-druid-connection-pool\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\"},\"author\":{\"name\":\"Noah Thompson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a\"},\"headline\":\"How can you close connections in the Druid connection pool?\",\"datePublished\":\"2024-03-14T10:17:11+00:00\",\"dateModified\":\"2024-03-20T16:33:24+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\"},\"wordCount\":98,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\",\"name\":\"How can you close connections in the Druid connection pool? - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T10:17:11+00:00\",\"dateModified\":\"2024-03-20T16:33:24+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"How can you close connections in the Druid connection pool?\"}]},{\"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a\",\"name\":\"Noah Thompson\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g\",\"caption\":\"Noah Thompson\"},\"url\":\"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"How can you close connections in the Druid connection pool? - 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-can-you-close-connections-in-the-druid-connection-pool\/","og_locale":"en_US","og_type":"article","og_title":"How can you close connections in the Druid connection pool?","og_description":"When using the Druid connection pool to close connections, you can call the close() method of the connection object to release connection resources. An example is shown below: import com.alibaba.druid.pool.DruidDataSource; import java.sql.Connection; import java.sql.SQLException; public class DruidConnectionPoolExample { public static void main(String[] args) { \/\/ \u521b\u5efaDruid\u8fde\u63a5\u6c60 DruidDataSource dataSource = new DruidDataSource(); dataSource.setUrl(\"jdbc:mysql:\/\/localhost:3306\/test\"); dataSource.setUsername(\"root\"); dataSource.setPassword(\"password\"); try [&hellip;]","og_url":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T10:17:11+00:00","article_modified_time":"2024-03-20T16:33:24+00:00","author":"Noah Thompson","twitter_card":"summary_large_image","twitter_creator":"@SiliCloudGlobal","twitter_site":"@SiliCloudGlobal","twitter_misc":{"Written by":"Noah Thompson","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/"},"author":{"name":"Noah Thompson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/2e83cc6ab9f60d36921c2d0f9f280f4a"},"headline":"How can you close connections in the Druid connection pool?","datePublished":"2024-03-14T10:17:11+00:00","dateModified":"2024-03-20T16:33:24+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/"},"wordCount":98,"commentCount":0,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/","url":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/","name":"How can you close connections in the Druid connection pool? - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T10:17:11+00:00","dateModified":"2024-03-20T16:33:24+00:00","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-can-you-close-connections-in-the-druid-connection-pool\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"How can you close connections in the Druid connection pool?"}]},{"@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\/2e83cc6ab9f60d36921c2d0f9f280f4a","name":"Noah Thompson","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/350e537e1530ede2762ee0237e877d6693f4f7163ab4f303202cc9a6b27b6cb4?s=96&d=mm&r=g","caption":"Noah Thompson"},"url":"https:\/\/www.silicloud.com\/blog\/author\/noahthompson\/"}]}},"_links":{"self":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9876","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\/14"}],"replies":[{"embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/comments?post=9876"}],"version-history":[{"count":1,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9876\/revisions"}],"predecessor-version":[{"id":43074,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/9876\/revisions\/43074"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=9876"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=9876"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=9876"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}