why BasicDatasource not find by compiler? even i added commons.dbcp.jar in project /webroot/lib

[kiran nyala]

hi I am trying to write one DBplugin class for postgresql, compiler warning me at import org.apache.commons.dbcp.BasicDataSource and its relavant code... why? I also added commons-dbcp-1.2.1.jar under /WEB-INF/lib

please check this code and resolve it ..thank you in advance

 package in.gov.cgg.plugins;

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

import javax.servlet.ServletContext;
import javax.servlet.ServletException;

import org.apache.commons.dbcp.BasicDataSource;
import org.apache.struts.action.ActionServlet;
import org.apache.struts.action.PlugIn;
import org.apache.struts.config.ModuleConfig;

public class DataBasePlugin implements PlugIn 
{
	public static BasicDataSource datasource;
	
	static Connection con=null;
	static Connection conn=null;
	
	static ServletContext context=null;
    
    public DataBasePlugin() 
    {
    	//    	initializing datasource
	}
	public void destroy() 
	{
		try {
			
			if(con!=null) {
				if(!con.isClosed()) {
					con.close();
					con=null;
				}
				else
					con=null;
			}   
		}
		catch (Exception e) {
			e.printStackTrace();
		}
	}

public void init(ActionServlet actionServlet, ModuleConfig modConfig)
		throws ServletException 
	{
		try
		{
			datasource=(BasicDataSource)actionServlet.getServletContext().getAttribute("empdb");
			
		}
		catch(Exception e)
		{
			e.printStackTrace();
		}
	}

	public static Connection getConnection()
    {
        try
        {
             do
             {
                con=datasource.getConnection();
                //conn=datasource.getConnection();
                System.out.println("in DataBAseplugin");
             }
             while(con==null || con.isClosed());
        }
        catch(Exception e)
        {
            e.printStackTrace();
        }
        return con;
    }
	
	public static void closeConnection(Connection _con) 
	{
		try
		{
			if(_con!=null) {
				if(!_con.isClosed()) {
					_con.close();
					_con=null;
				}
				else
					_con=null;
			}
		}
		catch(Exception e) 
		{
			e.printStackTrace();
		}
		finally
		{
			System.gc();
		}
	}
}   

----------struts-config.xml---------

<struts-config>
  <data-sources>
  	<data-source key="datasource" type="org.apache.commons.dbcp.BasicDataSource">
  	<set-property property="driverClass" value="org.postgresql.Driver"/>
  	<set-property property="url" value="jdbc:postgresql://localhost/test"/>
  	<set-property property="user" value="kiran"/>
  	<set-property property="password" value="kiran"/>  
  	</data-source>
  </data-sources>
  <form-beans />
  <global-exceptions />
  <global-forwards />
  <action-mappings />
  <message-resources parameter="in.gov.cgg.struts.ApplicationResources" />
  <plug-in className="in.gov.cgg.plugins.DataBasePlugin"/>
  
</struts-config>

[rakesh kumar nampally]

Add jar file to build path in eclipse, it should solve your issue.