Database Connection Pooling in Tomcat using Eclipse

by · September 22, 2009

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. dynamic-project-eclipse

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. db-connection-pooling-eclipse Copy following content in the context.xml file.
<?xml version="1.0" encoding="UTF-8"?>
<Context>
	<!-- Specify a JDBC datasource -->
	<Resource name="jdbc/testdb" auth="Container"
		type="javax.sql.DataSource" username="DB_USERNAME" password="DB_PASSWORD"
		driverClassName="oracle.jdbc.driver.OracleDriver"
		url="jdbc:oracle:thin:@xxx:1525:dbname"
		maxActive="10" maxIdle="4" />

</Context>

Code language: HTML, XML (xml)
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 TestServlet.java. I have created this file under package: net.viralpatel.servlet. Copy following code into it.
package net.viralpatel.servlet;

import java.io.IOException;
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) {
			e.printStackTrace();
		}
	}

	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 (resultSet.next()) {
				System.out.println(resultSet.getString(1) + resultSet.getString(2) + resultSet.getString(3));
			}
		} catch (SQLException e) {
			e.printStackTrace();
		}finally {
			try { if(null!=resultSet)resultSet.close();} catch (SQLException e) 
			{e.printStackTrace();}
			try { if(null!=statement)statement.close();} catch (SQLException e) 
			{e.printStackTrace();}
			try { if(null!=connection)connection.close();} catch (SQLException e) 
			{e.printStackTrace();}
		}
	}
}

Code language: Java (java)
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");

Code language: Java (java)
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"
	xmlns="http://java.sun.com/xml/ns/j2ee"
	xmlns:xsi="http://www.w3.org/2001/XMLSchema-instance"
	xsi:schemaLocation="http://java.sun.com/xml/ns/j2ee http://java.sun.com/xml/ns/j2ee/web-app_2_4.xsd">
	<display-name>TomcatConnectionPooling</display-name>
	<welcome-file-list>
		<welcome-file>index.jsp</welcome-file>
	</welcome-file-list>

	<servlet>
		<servlet-name>TestServlet</servlet-name>
		<servlet-class>
			net.viralpatel.servlet.TestServlet
		</servlet-class>
	</servlet>
	<servlet-mapping>
		<servlet-name>TestServlet</servlet-name>
		<url-pattern>/servlet/test</url-pattern>
	</servlet-mapping>
</web-app>

Code language: HTML, XML (xml)
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. db-connection-run-project-eclipse 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.

Tags:

You may also like...

72 Comments

  1. anony says:
    21 October, 2009, 12:20  

    Great article, exactly what I was looking for! Thanks!

    Reply
  2. abc says:
    14 January, 2010, 20:30  

    excellent work

    Reply
  3. visitor says:
    29 March, 2010, 13:25  

    where do you add the index.jsp?

    Reply
  4. machaa says:
    5 July, 2010, 14:52  

    I’m getting this error in Eclipse:

    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1136)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:880)
    at TestServlet.doGet(TestServlet.java:42)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:852)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at java.net.URLClassLoader$1.run(Unknown Source)
    at java.security.AccessController.doPrivileged(Native Method)
    at java.net.URLClassLoader.findClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClass(Unknown Source)
    at java.lang.ClassLoader.loadClassInternal(Unknown Source)
    at java.lang.Class.forName0(Native Method)
    at java.lang.Class.forName(Unknown Source)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1130)
    … 16 more

    Reply
    • siva kumar says:
      16 June, 2012, 11:51  

      Hi machaa,

      It cannot find the mysql.jar file. so you put mysql.jar on your web-inf/lib directory.

      Reply
      • Vikash says:
        9 July, 2012, 18:16  

        I had done this but its show same error
        what the reason

        Reply
        • Raj says:
          1 July, 2016, 16:29  

          right click on ‘lib’ and click on ‘build path’>’configure build path’

          Reply
  5. Sreedhar Siliveri says:
    29 July, 2010, 20:08  

    Excellent job … “Programming made easy” …

    — Sreedhar Siliveri

    Reply
  6. Yan says:
    6 August, 2010, 16:59  

    to solve problem with “cannot load class”:
    http://forums.sun.com/thread.jspa?threadID=5381419

    Reply
  7. Yan says:
    6 August, 2010, 18:17  

    context.xml

    Reply
  8. Yan says:
    6 August, 2010, 18:18  

    Resource name=”jdbc/orclPool”
    auth=”Container”
    type=”oracle.jdbc.pool.OracleDataSource”
    url=”jdbc:oracle:thin:@host:1521:orcl”
    factory=”oracle.jdbc.pool.OracleDataSourceFactory”
    user=”user”
    password=”pass”
    connectionCachingEnabled=”true”
    connectionCacheName=”orclConnCash”
    connectionCacheProperties=”{MinLimit=0, MaxLimit=5, InitialLimit=3, connectionWaitTimeout=10}”

    Reply
  9. mike says:
    18 October, 2010, 0:28  

    I repeat your code but I don’t know what is wrong..
    java.lang.NullPointerException
    paquete.TestServlet.doGet(TestServlet.java:40)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    javax.servlet.http.HttpServlet.service(HttpServlet.java:803)

    note The full stack trace of the root cause is available in the Apache Tomcat/5.5.23 logs.

    Reply
    • balaji says:
      27 December, 2011, 11:08  

      Hi Mike,

      Did you managed to resolve nullpointer exception now?if so can you give me solution..iam facing same error..doGet throwing null

      Reply
  10. jestin says:
    9 February, 2011, 7:57  

    there is no instruction for index.jsp.. please let us know how to create it

    Reply
  11. Prakash says:
    20 June, 2011, 10:05  

    Very good explanation of connection pooling with example..Thanks !

    Reply
  12. user says:
    4 July, 2011, 14:10  

    its very easy to understand for learners new to this topic .thank u very much.

    Reply
  13. Wojtek_PL says:
    12 October, 2011, 12:48  

    Thanks,

    I spent hours trying to make it works.
    With this one – it took me minutes. :-)

    Reply
  14. sundar says:
    20 January, 2012, 10:43  

    it show

    rg.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at net.viralpatel.servlet.TestServlet.doGet(TestServlet.java:43)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    … 17 more

    Reply
  15. Nexus says:
    27 March, 2012, 14:59  

    Thanks a lot, this article is very usefull

    Reply
  16. Waseem says:
    27 April, 2012, 2:59  

    Great article, thanks a lot

    Reply
  17. appesereddy says:
    31 May, 2012, 12:08  

    Greate Good Work ,,,,,Thanks

    Reply
  18. Navyasree says:
    6 June, 2012, 11:42  

    anybody can tel me how to connect struts with oracle.. please tel me..

    Reply
  19. Vikash says:
    9 July, 2012, 18:14  

    I always found this error
    g.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at net.viralpatel.servlet.TestServlet.doGet(TestServlet.java:43)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:191)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:127)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:298)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:859)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:588)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:489)
    at java.lang.Thread.run(Thread.java:595)
    Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1680)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1526)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    … 17 more

    Plz help me

    Reply
  20. subh says:
    11 July, 2012, 22:59  

    thnx lot its really very help full

    Reply
  21. JC says:
    12 July, 2012, 1:11  

    I am finding that after a while, I get “timeouts” on the connections (idle?) … the cannot get a connection. I modified some of the context.xml values, but problem persists. MySQL set to “autoreconnect” … also ensuring that the Connections are being closed in each call….

    Ideas?

    Reply
  22. AllanD says:
    17 July, 2012, 10:10  

    Hello,
    I see the value of having a Tomcat server with database poling, but can I connect to the tomcat from php running on apache on a different box?

    If so, how would I connect from php apache to this remote tomcat server to obtain a databsae connection?

    Reply
  23. sneha says:
    8 August, 2012, 9:46  

    Hello,
    I want to know can this pooling be done by reading the data through a property file..??If yes then why go for XML than property files..???
    If so a little guidance on how to go with pooling with property file??

    Reply
  24. krish says:
    8 August, 2012, 17:19  

    List out what are all the .jar files i have to put in lib folder for this example

    Reply
  25. Fandy Akhmad says:
    13 August, 2012, 12:22  

    Halo, Viralpatel.
    I just wonder about your example. How i know the connection pool are used?
    And how i reuse that connection from pool?

    Thank you.

    Reply
  26. mano says:
    15 November, 2012, 12:19  

    org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot load JDBC driver class ‘com.mysql.jdbc.Driver’
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1429)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:1371)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:1044)
    at net.viralpatel.servlet.TestServlet.doGet(TestServlet.java:50)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:621)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:722)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:305)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:210)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:225)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:123)
    at org.apache.catalina.authenticator.AuthenticatorBase.invoke(AuthenticatorBase.java:472)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:168)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:98)
    at org.apache.catalina.valves.AccessLogValve.invoke(AccessLogValve.java:927)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:118)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:407)
    at org.apache.coyote.http11.AbstractHttp11Processor.process(AbstractHttp11Processor.java:1001)
    at org.apache.coyote.AbstractProtocol$AbstractConnectionHandler.process(AbstractProtocol.java:585)
    at org.apache.tomcat.util.net.JIoEndpoint$SocketProcessor.run(JIoEndpoint.java:310)
    at java.util.concurrent.ThreadPoolExecutor.runWorker(Unknown Source)
    at java.util.concurrent.ThreadPoolExecutor$Worker.run(Unknown Source)
    at java.lang.Thread.run(Unknown Source)
    Caused by: java.lang.ClassNotFoundException: com.mysql.jdbc.Driver
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1711)
    at org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1556)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createConnectionFactory(BasicDataSource.java:1420)
    … 21 more

    how to rectify this problem

    Reply
  27. rakesh says:
    5 December, 2012, 0:09  

    Thanks

    after a long time I have tried connection pooling…. and it working great.

    Reply
  28. rakesh says:
    16 December, 2012, 16:06  

    while executing datasource.getConnection it shows the error message

    Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:766)
    at org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
    at TestServlet.init(TestServlet.java:32)
    at javax.servlet.GenericServlet.init(GenericServlet.java:212)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1160)
    at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:805)
    at org.apache.catalina.core.ApplicationDispatcher.invoke(ApplicationDispatcher.java:656)
    at org.apache.catalina.core.ApplicationDispatcher.processRequest(ApplicationDispatcher.java:469)
    at org.apache.catalina.core.ApplicationDispatcher.doForward(ApplicationDispatcher.java:403)
    at org.apache.catalina.core.ApplicationDispatcher.forward(ApplicationDispatcher.java:301)
    at org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:699)
    at org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:670)
    at org.apache.jsp.index_jsp._jspService(index_jsp.java:83)
    at org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:98)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:384)
    at org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
    at org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:228)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:104)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:212)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:634)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:445)
    at java.lang.Thread.run(Thread.java:619)
    Caused by: java.lang.ClassNotFoundException: oracle.jdbc.driver.OracleDriver

    Reply
    • rakesh says:
      16 December, 2012, 19:29  

      previously it was showing error OracleDriver not found even after paste the oracle14.zar as i am using 10g ……

      but when I added the the extenal zar file it works ……

      thatnks anyway

      Reply
  29. moriak says:
    18 December, 2012, 4:31  

    Great article men. Thanks. It was easy.

    Reply
    • prateek says:
      16 February, 2013, 17:07  

      Hi Moriak,

      Are u able to run the above program successfully.

      Regards,

      Reply
  30. re montesclaros says:
    19 December, 2012, 6:29  

    Nice post. Thanks

    Reply
    • shiva says:
      18 January, 2013, 20:43  

      Context envContext = (Context)initContext.lookup(“java:/comp/env”);
      what does this Lookup “java:/comp/env” means.. what is the use of this property.

      Reply
  31. prateek says:
    16 February, 2013, 17:06  

    Hi Dear,

    Could you please share the complete code ASAP?

    Regards,

    Reply
  32. Muhammad Farhaan Kazi says:
    12 March, 2013, 20:36  

    Beautiful, You explained stuff in very simplified, coherent way. lovely

    Reply
  33. hemu says:
    16 March, 2013, 13:13  

    to solve the below error,
    —————Cannot load JDBC driver class ‘oracle.jdbc.driver.OracleDriver’
    you can place the mysql-connector.jar or oralce driver jar e.g ojdbc6.jar
    in lib folder of container/server e.g. Tomcat 6.0\lib\ folder in my case

    Reply
    • Muthu says:
      19 March, 2013, 13:23  

      For MS SQL Server with Eclipse , the steps below,

      1. Create the Resource details in Context.xml in /conf/.

      2. in Servlet

      in inti method..
      Context initContext = new InitialContext();
      Context envContext = (Context)initContext.lookup(“java:/comp/env”);
      dataSource = (DataSource)envContext.lookup(“jdbc/WebAppDB”);

      in dopost method
      Connection conn = dataSource.getConnection();

      It will work with eclipse :)

      Reply
  34. Vikrant Thakur says:
    4 April, 2013, 7:02  

    Very informative. Thanks.

    Reply
  35. Chanchal Dhande says:
    18 April, 2013, 15:45  

    Thanks. Great article, very informative and simple.

    Reply
  36. Mansoor says:
    22 May, 2013, 17:07  

    Explained and demonstrated well…all the very best..

    Reply
  37. Pallavi says:
    4 July, 2013, 16:40  

    when i use context.xml in meta-inf folder tomcat is throwing an error. Can anyone suggest me how to work about.

    Thank you in advance.

    Reply
  38. Prateek Mathur says:
    29 July, 2013, 12:20  

    Hi there…
    I just loved this article. It has been like a life saver for me.

    Reply
  39. sai says:
    12 August, 2013, 7:35  

    Hi
    I am trying to set a connectionpool however i am failing.i am getting this error.
    javax.naming.NameNotFoundException: Name jdbc is not bound in this Context
    at org.apache.naming.NamingContext.lookup(NamingContext.java:770)
    at org.apache.naming.NamingContext.lookup(NamingContext.java:153)
    at Testservlet.init(Testservlet.java:27)
    at javax.servlet.GenericServlet.init(GenericServlet.java:212)
    at org.apache.catalina.core.StandardWrapper.loadServlet(StandardWrapper.java:1161)
    at org.apache.catalina.core.StandardWrapper.allocate(StandardWrapper.java:806)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:129)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:662)
    java.lang.NullPointerException
    at Testservlet.doGet(Testservlet.java:39)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:690)
    at javax.servlet.http.HttpServlet.service(HttpServlet.java:803)
    at org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(ApplicationFilterChain.java:290)
    at org.apache.catalina.core.ApplicationFilterChain.doFilter(ApplicationFilterChain.java:206)
    at org.apache.catalina.core.StandardWrapperValve.invoke(StandardWrapperValve.java:233)
    at org.apache.catalina.core.StandardContextValve.invoke(StandardContextValve.java:175)
    at org.apache.catalina.core.StandardHostValve.invoke(StandardHostValve.java:128)
    at org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java:102)
    at org.apache.catalina.core.StandardEngineValve.invoke(StandardEngineValve.java:109)
    at org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java:286)
    at org.apache.coyote.http11.Http11Processor.process(Http11Processor.java:844)
    at org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java:583)
    at org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java:447)
    at java.lang.Thread.run(Thread.java:662)
    can you help me.

    Reply
  40. Siddu says:
    29 August, 2013, 14:39  

    How to implement connection pooling in core java applications?

    Reply
  41. Mags says:
    29 August, 2013, 20:21  

    This implementation has a fault. When you add Resource tag in the context.xml, the same resource will be loaded for each and every webapp present in the Tomcat webapps folder.

    By default, there are 5 applications present in the webapps folder of Tomcat: docs, examples, host-manager, manager and ROOT. If you are setting minIdle/maxIdle to 5, then it would create 5*5+5 Idle database connections, out of 5*5 connections would not be used.

    Still a good article for basics of Connection Pooling. :-)

    Reply
  42. dsolis says:
    10 September, 2013, 3:48  

    Thanks a lot!!, very useful

    Reply
  43. Vikash says:
    18 September, 2013, 13:06  

    The lookup string “java:/comp/env” should be “java:comp/env”. Except this every thing works smoothly.

    Reply
  44. Swarnim Bhardwaj says:
    27 September, 2013, 16:47  

    Very good article …..keep up the good work..!!!

    Reply
  45. isuy says:
    28 September, 2013, 1:14  

    Very nice. Thanks, but your code is not thread safe. Connection and Statement should be declared locally.

    Reply
  46. veeruforjava says:
    12 October, 2013, 18:25  

    Hi
    Your tutorial is very nice.keep it up

    Reply
  47. Palanikumar says:
    1 November, 2013, 16:04  

    Respected Sir,

    I am using notepad for all java program run. How can i connect jsp file t o mysql database. i dont want coding. but i have more error during run the program. my doubts is we are creating JDBC connection we go to administrator tools connect database and so on…. these procedure is similarly follow for MYSQL tell me clear idea. i have more confuse…..

    Reply
  48. Awlad says:
    10 November, 2013, 16:41  

    Above mentioned connection pool tutorial is very nice.
    Can anyone tell me how I can configure/ initiate above mentioned connection pool during application load, e.g. when my application deploys/ loads first servlet, connection properties (url, user, password, db name) will be taken from web page and creates a connection pool, Is it possible by this methodology (using tomcat dbcp)?

    Reply
  49. Jean says:
    19 November, 2013, 16:02  

    Great article, but is missing the source to index.jsp

    Reply
  50. Omer says:
    9 December, 2013, 23:41  

    Hi
    Great tutorial, Will this work with JBOSS as well, Thanks

    Reply
  51. Ankur says:
    30 December, 2013, 23:25  

    where is index.jsp file…….

    Reply
  52. Ramya says:
    23 February, 2014, 12:22  

    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.

    Reply
  53. Siddu says:
    12 March, 2014, 20:46  

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

    Reply
  54. ANJU CHAUDHARY says:
    25 March, 2014, 15:38  

    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

    Reply
  55. Dheeraj Remella says:
    23 April, 2014, 20:41  

    Thanks for the article, Viral.

    Reply
  56. Arpit says:
    22 May, 2014, 0:43  

    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,
    Arpit

    Reply
    • raj says:
      3 July, 2014, 12:58  

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

      Reply
  57. Sandip says:
    31 July, 2014, 20:15  

    Can you please explain what is connection pooling?

    Reply
  58. Glyn Bartlett says:
    27 August, 2014, 8:10  

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

    http://stackoverflow.com/questions/25518074/tomcat-connection-pooling-issue-after-following-tutorial

    Your help is greatly appreciated.

    Regards,

    Glyn

    Reply
  59. rajasekhar says:
    4 September, 2014, 12:49  

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

    Reply
  60. nitin says:
    19 September, 2014, 13:27  

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

    Reply
  61. venkateswarlu says:
    21 December, 2014, 23:47  

    can you please exact definition of connection pooling?

    Reply
  62. Abhi says:
    7 January, 2015, 14:38  

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

    Reply
  63. Nish says:
    5 April, 2016, 9:55  

    Why v need to include web.xml file in webinfo inside the lib folder

    Reply

Leave a Reply

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

Follow: