DataSource is Null in JNDI Connection with Tomcat

[Kousik Majumder]

Hi,
I am getting NullPointerException due to null value of DataSource when trying to connect through JNDI in Tomcat 5.5
I have checked all the values of parameters in server.xml.

can somebody tell me the reasons why this is coming?

 
Context initContext = new InitialContext();
            DataSource ds  = (DataSource)initContext.lookup("java:/comp/env/jdbc/cesco");
    System.out.println("DS = "+ds);  // Here it is Null i.e DS = null
            if(ds == null)
                throw new Exception("DataSource Is Null !!!");
            Connection conn = ds.getConnection();

server.xml:

 
<Context path="/JndiExam" docBase="E:\JndiExam_NB\build\web" reloadable="true">
<Resource name="jdbc/cesco"
   auth="Container"
   type="oracle.jdbc.pool.OracleDataSource"
   factory="org.apache.commons.dbcp.BasicDataSourceFactory"   
   driverClassName="oracle.jdbc.driver.OracleDriver"
   url="jdbc:oracle:thin:@127.0.0.1:1521:cesco"
   username="bass" 
   password="bass"
   maxActive="20"
   maxIdle="10"
   maxWait="-1" />
</Context>
 

web.xml:
<resource-ref>
       <description>Oracle Datasource example</description>
       <res-ref-name>jdbc/cesco</res-ref-name>
       <res-type>javax.sql.DataSource</res-type>
       <res-auth>Container</res-auth>
</resource-ref>

Thanks in Advance,

Kousik

[karthikeyan Chockalingam]

Place the jar file containing Oracle database implementation classes under
<TOMCAT_HOME>\common\lib rather than WEB-INF\lib directory specific to the project.

Also I found the installer version of (that ends with .exe) Tomcat 5.5.17 to have some strange problems. Try the .zip version which will avoid those.