Issues regarding Connectionpooling with MySQL database server and Tomcat 5.5 server

[hareesh Puthala]

Hi All,

I am getting this error while iam trying to create connection pool using Mysql DB(5.1) and Tomcat webserver(5.5).

I placed the mysql-connector-java-5.1.13-bin.jar file in tomcat/commons/lib folder and environment variable also set for this jar.

javax.naming.NoInitialContextException: Need to specify class name in environment or system property, or as an applet parameter,
                                                           or in an application resource file:  java.naming.factory.initial
	at javax.naming.spi.NamingManager.getInitialContext(Unknown Source)
	at javax.naming.InitialContext.getDefaultInitCtx(Unknown Source)
	at javax.naming.InitialContext.getURLOrDefaultInitCtx(Unknown Source)
	at javax.naming.InitialContext.lookup(Unknown Source)

Here is the code of DBConnectionManager.java

package com.spdcl.connection;

import java.sql.Connection;

import javax.naming.Context;
import javax.naming.InitialContext;
import javax.sql.DataSource;

public class DBConnectionManager {
	static private DBConnectionManager instance;

	static synchronized public DBConnectionManager getInstance() {

		if (instance == null) {
			instance = new DBConnectionManager();
		}
		return instance;
	}

	public void freeConnection(Connection con) throws Exception {
		con.close();
	}

	public Connection getConnection(String name) {
		Connection dbconn = null;

		try {
			DataSource ds = null;
			Class.forName("com.mysql.jdbc.Driver");
			String jndiname = "java:/comp/env/jdbc/".concat(name);
			Context initContext = new InitialContext();
			ds = (javax.sql.DataSource) initContext.lookup(jndiname);
			dbconn = ds.getConnection();
		} catch (Exception e) {
			e.printStackTrace();
		}
		return dbconn;
	}
}

Main class code is:

Connection con = DBConnectionManager.getInstance().getConnection(
				"MySQLDB");

context.xml code:

<?xml version="1.0" encoding="UTF-8"?>
<Context
	path="C:\Program Files\Apache Software Foundation\Tomcat 5.5\webapps\MySQLTest"
	docBase="MySQLTest" debug="5" reloadable="true" crossContext="true">

	<Resource name="jdbc/MySQLDB" auth="Container"
		type="javax.sql.DataSource" driverClassName="com.mysql.jdbc.Driver"
		url="jdbc:mysql://localhost:3306/mysql" username="root"
		password="hareesh" maxActive="20" maxIdle="5" maxWait="-1" />


</Context>

can anyone help me out.
Thanks in advance.

[Campbell Ritchie]

Why are you using "javadoc" tags and not code tags; your quoted code is illegible otherwise.

[Rob Spoor]

So why didn't you change it for him, like I now did?

[Campbell Ritchie]

You're obviously in a better mood, or less busy, than I was this morning.

[Rob Spoor]

Apparently.

I'm going to move this to our Tomcat forum as I'm sure you'll get more help there.