Name jdbc is not bound in this Context

[jaan bhavsar]

Hi to all Ranchers,
I am making connection pool with tomcat.i define necessary entry in server.xml,web.xml and made one listener class to get the connection.but i am getting error "javax.naming.NameNotFoundException:Name jdbc is not bound in this Context" when i start the tomcat server.and also in my listener value of dataSourcejndi name is displayed null.

is there any jar files need to put in tomcat common/lib,i put mysql connector and odbc14.jar .


Please guide me how to get the jndidatasource name in listener .I attached three files for your reference in single file.
1)web.xml
2)server.xml
3)Applistener.java

1)web.xml

 
 <resource-ref>   
            <description>DB Connection</description>   
           <res-ref-name>jdbc/test</res-ref-name>   
           <res-type>javax.sql.DataSource</res-type>   
           <res-auth>Container</res-auth>   
   </resource-ref>   
           <filter>   
                        <filter-name>struts2</filter-name>   
                        <filter-class>org.apache.struts2.dispatcher.FilterDispatcher</filter-class>   
           </filter>   
           <filter-mapping>   
                  <filter-name>struts2</filter-name>   
                 <url-pattern>/*</url-pattern>   
           </filter-mapping>   
          <listener>    
               <listener-class>    
                         util.AppListener    
               </listener-class>    
         </listener>   
 

2)Server.xml(in tomcat)

  
<Context path="/smallProject"  
               docBase="smallProject" reloadable="true"    
              debug="8">    
   <Resource    
                 name="jdbc/test"  
     auth="Container"      
     type="javax.sql.DataSource"/>    
  
    <ResourceParams name="jdbc/test">   
     <parameter>    
        <name>factory</name>    
        <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>    
     </parameter>    
    <parameter>   
         <name>maxActive</name>   
         <value>10</value>    
    </parameter>    
    <parameter>    
        <name>maxIdle</name>   
         <value>3</value>    
    </parameter>    
    <parameter>    
        <name>maxWait</name>   
         <value>5</value>    
    </parameter>    
    <parameter>    
        <name>username</name>    
        <value>root</value>   
    </parameter>    
    <parameter>    
         <name>password</name>    
        <value>test</value>    
    </parameter>    
    <parameter>    
        <name>driverClassName</name>    
        <value>com.mysql.jdbc.Driver</value>    
    </parameter>   
    <parameter>    
        <name>url</name>    
        <value>jdbc:mysql://192.168.1.2:3306/test</value>   
    </parameter>    
</ResourceParams>    
</Context>   
 

3)Listener Class to get the jndidatasource name
i am getting the jndiname null

 
package util; 
import javax.naming.Context; 
import javax.naming.InitialContext; 
import javax.servlet.ServletContext; 
import javax.servlet.ServletContextEvent; 
import javax.servlet.ServletContextListener; 
import javax.sql.DataSource; 

public class AppListener implements ServletContextListener { 
public void contextInitialized(ServletContextEvent sce) { 

ServletContext servletContext = sce.getServletContext(); 
String dataSourceJndiName = servletContext.getInitParameter 
("jdbc/test"); 
System.out.println("jndiname-->"+dataSourceJndiName); 
try{ 
Context context = new InitialContext(); 
DataSource dataSource = (DataSource)context.lookup 
("jdbc/test"); 

servletContext.setAttribute("dataSource",dataSource); 
}catch(Exception e) 
{ 
e.printStackTrace(); 
} 
} 
public void contextDestroyed(ServletContextEvent des) { 

} 

} 

Thank you in Advance
 

[amit punekar]

Hi,
Access the Datasource using "java:comp/env/jdbc/test".

[jaan bhavsar]

Thanks amit. I done that and its working good