create a poolable connection using mysql eclipse helios and apache tomcat 6 with java

[computerbum]

Hello everyone,

I am trying to setup a poolable connection using eclipse helios, apache tomcat 6, mysql, and java.

I was able to get a connection through a jsp page that would return data following this tutorial from:

Apache Tomcat 6.0 - JNDI Datasource HOW-TO

But now I want to create a class in java that will get my connection from the context.xml.

I am in desperate need here, please help!

[computerbum]

Here is my context.xml stored my META-INF

<?xml version="1.0" encoding="UTF-8"?>

<Context>
    <!-- Specify a JDBC datasource -->
    
    <Resource 
        name="jdbc/wrights_auto" 
        auth="Container"
        type="javax.sql.DataSource" 
        maxActive="10" maxIdle="4"
        username="root" 
        password="homedb"
        driverClassName="com.mysql.jdbc.Driver"
        url="jdbc:mysql://localhost:3306/wrights_auto"
         />
 
</Context>

Here is the class I am running and it fails on this line:

DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/wrights_auto");

error message: Exception in thread "main" 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(N amingManager.java:645)

package com.adc.wrights.common;

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

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


public class DAO {

    public void doSomething() throws Exception {
        /*
         * Create a JNDI Initial context to be able to
         *  lookup  the DataSource
         *
         * In production-level code, this should be cached as
         * an instance or static variable, as it can
         * be quite expensive to create a JNDI context.
         *
         * Note: This code only works when you are using servlets
         * or EJBs in a J2EE application server. If you are
         * using connection pooling in standalone Java code, you
         * will have to create/configure datasources using whatever
         * mechanisms your particular connection pooling library
         * provides.
         */

        InitialContext ctx = new InitialContext();

         /*
          * Lookup the DataSource, which will be backed by a pool
          * that the application server provides. DataSource instances
          * are also a good candidate for caching as an instance
          * variable, as JNDI lookups can be expensive as well.
          */
          
        DataSource ds = (DataSource)ctx.lookup("java:comp/env/jdbc/wrights_auto");

        /*
         * The following code is what would actually be in your
         * Servlet, JSP or EJB 'service' method...where you need
         * to work with a JDBC connection.
         */

        Connection conn = null;
        Statement stmt = null;

        try {
            conn = ds.getConnection();

            /*
             * Now, use normal JDBC programming to work with
             * MySQL, making sure to close each resource when you're
             * finished with it, which allows the connection pool
             * resources to be recovered as quickly as possible
             */

            stmt = conn.createStatement();
            stmt.execute("select * from clients");

            stmt.close();
            stmt = null;

            conn.close();
            conn = null;
        } finally {
            /*
             * close any jdbc instances here that weren't
             * explicitly closed during normal code path, so
             * that we don't 'leak' resources...
             */

            if (stmt != null) {
                stmt.close();

                stmt = null;
            }

            if (conn != null) {
                conn.close();

                conn = null;
            }
        }
    }


    
	/**
	 * @param args
	 * @throws Exception 
	 * @throws IOException 
	 * @throws ServletException 
	 * @throws SQLException 
	 */
	public static void main(String[] args) throws Exception {
		// TODO Auto-generated method stub
		DAO conn = new DAO();
		
		
		conn.doSomething();
		
		//Connection con = conn.dataSource.getConnection();
		
		

	}