{"id":4479,"date":"2024-03-14T01:31:22","date_gmt":"2024-03-14T01:31:22","guid":{"rendered":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/"},"modified":"2025-07-31T08:32:45","modified_gmt":"2025-07-31T08:32:45","slug":"how-do-you-configure-the-data-source-connection-pool-for-tomcat","status":"publish","type":"post","link":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/","title":{"rendered":"Tomcat Connection Pool Setup Guide"},"content":{"rendered":"<p>Configuring a data source connection pool in Tomcat requires configuration in the context.xml file. The following are the configuration steps:<\/p>\n<p>Open the conf folder in the installation directory of Tomcat, and locate the context.xml file.<\/p>\n<p>Add the data source configuration in the context.xml file, with an example configuration as shown below:<\/p>\n<pre class=\"post-pre\"><code class=\"lang-xml\">&lt;Resource name=\"jdbc\/yourDataSourceName\" auth=\"Container\" type=\"javax.sql.DataSource\"\r\n               maxTotal=\"100\" maxIdle=\"30\" maxWaitMillis=\"10000\"\r\n               username=\"yourUsername\" password=\"yourPassword\" driverClassName=\"com.mysql.cj.jdbc.Driver\"\r\n               url=\"jdbc:mysql:\/\/localhost:3306\/yourDatabaseName?useSSL=false\"\r\n               validationQuery=\"SELECT 1\" testOnBorrow=\"true\"\/&gt;\r\n<\/code><\/pre>\n<p>The &#8216;name&#8217; property represents the JNDI name of the data source, while &#8216;maxTotal&#8217;, &#8216;maxIdle&#8217;, and &#8216;maxWaitMillis&#8217; respectively indicate the maximum total connections, maximum idle connections, and maximum wait time of the connection pool. &#8216;username&#8217; and &#8216;password&#8217; are for the database username and password, &#8216;driverClassName&#8217; is the class name of the database driver, &#8216;url&#8217; is the database connection address, &#8216;validationQuery&#8217; is the query statement for validation, and &#8216;testOnBorrow&#8217; indicates whether validation should be performed when retrieving a connection from the pool.<\/p>\n<p>Put the jar file of the database driver into the lib folder of Tomcat.<\/p>\n<p>4. Configure the JNDI name of the data source in the web.xml file, with an example configuration as follows:<\/p>\n<pre class=\"post-pre\"><code class=\"lang-xml\">&lt;resource-ref&gt;\r\n    &lt;description&gt;DB Connection&lt;\/description&gt;\r\n    &lt;res-ref-name&gt;jdbc\/yourDataSourceName&lt;\/res-ref-name&gt;\r\n    &lt;res-type&gt;javax.sql.DataSource&lt;\/res-type&gt;\r\n    &lt;res-auth&gt;Container&lt;\/res-auth&gt;\r\n&lt;\/resource-ref&gt;\r\n<\/code><\/pre>\n<p>In the application, retrieve a data source connection using the JNDI name. Here is an example code.<\/p>\n<pre class=\"post-pre\"><code class=\"lang-java\">Context ctx = new InitialContext();\r\nDataSource ds = (DataSource) ctx.lookup(\"java:comp\/env\/jdbc\/yourDataSourceName\");\r\nConnection conn = ds.getConnection();\r\n<\/code><\/pre>\n<p>The above are the steps for configuring a data source connection pool in Tomcat, with this configuration you can manage database connections in your application using a connection pool.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Configuring a data source connection pool in Tomcat requires configuration in the context.xml file. The following are the configuration steps: Open the conf folder in the installation directory of Tomcat, and locate the context.xml file. Add the data source configuration in the context.xml file, with an example configuration as shown below: &lt;Resource name=&#8221;jdbc\/yourDataSourceName&#8221; auth=&#8221;Container&#8221; type=&#8221;javax.sql.DataSource&#8221; [&hellip;]<\/p>\n","protected":false},"author":7,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_import_markdown_pro_load_document_selector":0,"_import_markdown_pro_submit_text_textarea":"","footnotes":""},"categories":[1],"tags":[1785,906,4093,121,376],"class_list":["post-4479","post","type-post","status-publish","format-standard","hentry","category-uncategorized","tag-connection-pool","tag-context-xml","tag-data-source","tag-jdbc","tag-tomcat"],"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>Tomcat Connection Pool Setup Guide - Blog - Silicon Cloud<\/title>\n<meta name=\"description\" content=\"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.\" \/>\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-do-you-configure-the-data-source-connection-pool-for-tomcat\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Tomcat Connection Pool Setup Guide\" \/>\n<meta property=\"og:description\" content=\"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\" \/>\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-14T01:31:22+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-07-31T08:32:45+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-do-you-configure-the-data-source-connection-pool-for-tomcat\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\"},\"author\":{\"name\":\"Sophia Anderson\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30\"},\"headline\":\"Tomcat Connection Pool Setup Guide\",\"datePublished\":\"2024-03-14T01:31:22+00:00\",\"dateModified\":\"2025-07-31T08:32:45+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\"},\"wordCount\":218,\"publisher\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#organization\"},\"keywords\":[\"connection pool\",\"context.xml\",\"Data Source\",\"JDBC\",\"Tomcat\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\",\"url\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\",\"name\":\"Tomcat Connection Pool Setup Guide - Blog - Silicon Cloud\",\"isPartOf\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/#website\"},\"datePublished\":\"2024-03-14T01:31:22+00:00\",\"dateModified\":\"2025-07-31T08:32:45+00:00\",\"description\":\"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.\",\"breadcrumb\":{\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.silicloud.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Tomcat Connection Pool Setup Guide\"}]},{\"@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":"Tomcat Connection Pool Setup Guide - Blog - Silicon Cloud","description":"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.","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-do-you-configure-the-data-source-connection-pool-for-tomcat\/","og_locale":"en_US","og_type":"article","og_title":"Tomcat Connection Pool Setup Guide","og_description":"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.","og_url":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/","og_site_name":"Blog - Silicon Cloud","article_publisher":"https:\/\/www.facebook.com\/SiliCloudGlobal\/","article_published_time":"2024-03-14T01:31:22+00:00","article_modified_time":"2025-07-31T08:32:45+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-do-you-configure-the-data-source-connection-pool-for-tomcat\/#article","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/"},"author":{"name":"Sophia Anderson","@id":"https:\/\/www.silicloud.com\/blog\/#\/schema\/person\/19a24313de9c988db3d69226b4a40a30"},"headline":"Tomcat Connection Pool Setup Guide","datePublished":"2024-03-14T01:31:22+00:00","dateModified":"2025-07-31T08:32:45+00:00","mainEntityOfPage":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/"},"wordCount":218,"publisher":{"@id":"https:\/\/www.silicloud.com\/blog\/#organization"},"keywords":["connection pool","context.xml","Data Source","JDBC","Tomcat"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/","url":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/","name":"Tomcat Connection Pool Setup Guide - Blog - Silicon Cloud","isPartOf":{"@id":"https:\/\/www.silicloud.com\/blog\/#website"},"datePublished":"2024-03-14T01:31:22+00:00","dateModified":"2025-07-31T08:32:45+00:00","description":"Learn to configure Tomcat data source connection pools with context.xml settings and optimization tips.","breadcrumb":{"@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.silicloud.com\/blog\/how-do-you-configure-the-data-source-connection-pool-for-tomcat\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.silicloud.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Tomcat Connection Pool Setup Guide"}]},{"@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\/4479","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=4479"}],"version-history":[{"count":2,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4479\/revisions"}],"predecessor-version":[{"id":149146,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/posts\/4479\/revisions\/149146"}],"wp:attachment":[{"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/media?parent=4479"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/categories?post=4479"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.silicloud.com\/blog\/wp-json\/wp\/v2\/tags?post=4479"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}