JNDI Connection with Oracle (Problem with NullPointerException)

[Kousik Majumder]

Hi,

I am trying to use INDI connection pooling. I have used the configuration as described in
http://tomcat.apache.org/tomcat-4.1-doc/jndi-datasource-examples-howto.html.

But still I am getting NullPointerException due to null of DataSource.

Can anyone tell me the reason.
my server.xml code:-

  
<GlobalNamingResources>
    <Resource name="jdbc/cesco" auth="Container"
              type="javax.sql.DataSource"/> 
 
        <ResourceParams name="jdbc/cesco">
          <parameter>
            <name>factory</name>
            <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
          </parameter>
          <parameter>
            <name>driverClassName</name>
            <value>oracle.jdbc.driver.OracleDriver</value>
          </parameter>
          <parameter>
            <name>url</name>
            <value>jdbc :-o	 racle:thin:@//192.168.142.9:1521:cesco</value>
          </parameter>
          <parameter>
            <name>username</name>
            <value>cesco</value>
          </parameter>
          <parameter>
            <name>password</name>
            <value>cesco</value>
          </parameter>
          <parameter>
            <name>maxActive</name>
            <value>20</value>
          </parameter>
          <parameter>
            <name>maxIdle</name>
            <value>10</value>
          </parameter>
          <parameter>
            <name>maxWait</name>
            <value>-1</value>
          </parameter>
        </ResourceParams>
          
  </GlobalNamingResources>

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>

ACTION CLASS/jsp:-

  
Context initContext = new InitialContext();
Context envContext  = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/cesco");
System.out.println("DS = "+ds);
Connection conn = ds.getConnection();

Thanks in advance.

Kousik