Database Connection Pooling in Tomcat using Eclipse

tomcat-connection-poolingDatabase Connection Pooling is a great technique used by lot of application servers to optimize the performance. Database Connection creation is a costly task thus it impacts the performance of application. Hence lot of application server creates a database connection pool which are pre initiated db connections that can be leverage to increase performance.

Apache Tomcat also provide a way of creating DB Connection Pool. Let us see an example to implement DB Connection Pooling in Apache Tomcat server. We will create a sample web application with a servlet that will get the db connection from tomcat db connection pool and fetch the data using a query. We will use Eclipse as our development environment. This is not a prerequisite i.e. you may want to use any IDE to create this example.

Step 1: Create Dynamic Web Project in Eclipse

Create a Dynamic Web Project in Eclipse by selecting:
File -> New -> Project… ->Dynamic Web Project.

Step 2: Create context.xml

Apache Tomcat allow the applications to define the resource used by the web application in a file called context.xml (from Tomcat 5.x version onwards). We will create a file context.xml under META-INF directory.
Copy following content in the context.xml file.

<?xml version="1.0" encoding="UTF-8"?>
	<!-- Specify a JDBC datasource -->
	<Resource name="jdbc/testdb" auth="Container"
		type="javax.sql.DataSource" username="DB_USERNAME" password="DB_PASSWORD"
		maxActive="10" maxIdle="4" />


In above code snippet, we have specify a database connection pool. The name of the resource is jdbc/testdb. We will use this name in our application to get the data connection. Also we specify db username and password and connection URL of database. Note that I am using Oracle as the database for this example. You may want to change this Driver class with any of other DB Providers (like MySQL Driver Class).

Step 3: Create Test Servlet and WEB xml entry

Create a file called I have created this file under package: net.viralpatel.servlet. Copy following code into it.

package net.viralpatel.servlet;

import java.sql.Connection;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.naming.NamingException;
import javax.servlet.ServletException;
import javax.servlet.http.HttpServlet;
import javax.servlet.http.HttpServletRequest;
import javax.servlet.http.HttpServletResponse;
import javax.sql.DataSource;

public class TestServlet extends HttpServlet {
	private DataSource dataSource;
	private Connection connection;
	private Statement statement;
	public void init() throws ServletException {
		try {
			// Get DataSource
			Context initContext  = new InitialContext();
			Context envContext  = (Context)initContext.lookup("java:/comp/env");
			dataSource = (DataSource)envContext.lookup("jdbc/testdb");

		} catch (NamingException e) {

	public void doGet(HttpServletRequest req, HttpServletResponse resp)
			throws ServletException, IOException {
		ResultSet resultSet = null;
		try {
			// Get Connection and Statement
			connection = dataSource.getConnection();
			statement = connection.createStatement();
			String query = "SELECT * FROM STUDENT";
			resultSet = statement.executeQuery(query);
			while ( {
				System.out.println(resultSet.getString(1) + resultSet.getString(2) + resultSet.getString(3));
		} catch (SQLException e) {
		}finally {
			try { if(null!=resultSet)resultSet.close();} catch (SQLException e) 
			try { if(null!=statement)statement.close();} catch (SQLException e) 
			try { if(null!=connection)connection.close();} catch (SQLException e) 

In the above code we initiated the datasource using InitialContext lookup:

Context initContext  = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
dataSource = (DataSource)envContext.lookup("jdbc/testdb");

Create test servlet mapping in the web.xml file (deployment descriptor) of the web application. The web.xml file will look like:

<?xml version="1.0" encoding="UTF-8"?>
<web-app id="WebApp_ID" version="2.4"


Now Run the web application in Tomcat using Eclipse (Alt + Shift + X, R). You will be able to see the result of the query executed.
Thus this way we can create a database pool in Tomcat and get the connections from it.

Get our Articles via Email. Enter your email address.

You may also like...


  1. Ankur says:

    where is index.jsp file…….

  2. Ramya says:

    I am not able to get a connection from my pool. When i set the maxactive to 1, i see 14 connections created in oracle under the machine name. While using ds.getconnection(), i don’t get more than one connection. I have added the pooling connection details to tomcat’s context.xml. in th is way the connection pool is available to all applications.

    My issues is i see connections getting created, but when calling getconnection(), i don’t see any connection being given from the pool.

  3. Siddu says:

    How to implement connection pooling in core java application? for stand alone application.


    I am not able for understand why you used context.xml file under meta -INF, and programing of step 4 pls tell me in detail of all process

  5. Dheeraj Remella says:

    Thanks for the article, Viral.

  6. Arpit says:

    Hi Viral,

    First I would like to thankyou for explaining java concepts in very simple way.
    I am a regular follow of your blog and learnt alot from you. You have given a simple example i was looking for connection pooling.

    The whole idea of connection pooling is that when application startsup a pool of connection is created. When we want to interact with the database we get a connection from pool and upon completing we return that connection to the pool i.e. we never close the connection.

    Here in your are closing the connection.

    Please expalin.

    Awaiting you reply…!

    Thanks & Regards,

    • raj says:

      Its not closing database connection, while invoke the close. It return to pool connection

  7. Sandip says:

    Can you please explain what is connection pooling?

  8. Glyn Bartlett says:

    I get a 404 error when I run this. I have followed your example exactly. Please see this post for the details:

    Your help is greatly appreciated.



  9. rajasekhar says:

    Context envContext = (Context)initContext.lookup(“java:/comp/env”); in this why you use “java:/comp/env” ? may i copy as it is……?

  10. nitin says:

    What if i don’t close resultset and statement and only close connection ?
    would it hamper the connection pooling or connection.

  11. venkateswarlu says:

    can you please exact definition of connection pooling?

  12. Abhi says:

    I am not getting Context envContext = (Context)initContext.lookup(“java:/comp/env”); line ?can you explain this line

Leave a Reply

Your email address will not be published. Required fields are marked *

You may use these HTML tags and attributes: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>