Connection Pool with Tomcat6 and Mysql

Inside $tomcat_home/conf/context.xml add this inside <Context>

<Resource name=”jdbc/datasourcename” auth=”Container” type=”javax.sql.DataSource” maxActive=”100″ maxIdle=”30″ maxWait=”1000″ username=”dbuser” password=”dbpwd” driverClassName=”com.mysql.jdbc.Driver” url=”jdbc:mysql://localhost:3306/exodus”/>

Now restart tomcat

Inside you web.xml add this before </web-app>:

<resource-ref>
<description>My DB Connection</description>
<res-ref-name>jdbc/datasourcename</res-ref-name>
<res-type>javax.sql.DataSource</res-type>
<res-auth>Container</res-auth>
</resource-ref>

Java code to connect:

Context initCtx = new InitialContext();

DataSource ds = (DataSource) initCtx.lookup(“java:comp/env/jdbc/datasourcename”);

Connection connection = ds.getConnection();