JNDI null issue

[Dan Parsons]

I am trying to get JNDI to work.

My attempt gives me error:
Cannot create JDBC driver of class '' for connect URL 'null'

server.xml(C:\jakarta-tomcat-5.0.28\conf)

<Resource name="jdbc/myoracle" auth="Container"
                 type="javax.sql.DataSource"/> 
   
   <ResourceParams name="jdbc/myoracle">
     <parameter>
       <name>driverClassName</name>
       <value>oracle.jdbc.driver.OracleDriver</value>
     </parameter>
     <parameter>
       <name>url</name>
       <value>jdbc:oracle:thin:@abcdefghi:1521:infie:"scott":"tiger"</value>
     </parameter>
     <parameter>
       <name>username</name>
       <value>scott</value>
     </parameter>
     <parameter>
       <name>password</name>
       <value>tiger</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>

Entered the following in web xml(C:\jakarta-tomcat-4.1.27\webapps\projectOne\WEB-INF)

<resource-ref>
         <description>Oracle Datasource example</description>
         <res-ref-name>jdbc/myoracle</res-ref-name>
         <res-type>javax.sql.DataSource</res-type>
         <res-auth>Container</res-auth>
 </resource-ref>
 
and
<servlet>
               <servlet-name>JndiServlet</servlet-name>
               <servlet-class>JndiServlet</servlet-class>
   </servlet>
 
 <servlet-mapping>
                <servlet-name>JndiServlet</servlet-name>
                               <url-pattern>/servlet/JndiServlet</url-pattern>
   </servlet-mapping>

Code for jndiServlet

 
import java.io.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.util.*;
import java.sql.*;
import javax.sql.*;
 
import javax.naming.*;
 
public class JndiServlet extends HttpServlet
{
DataSource ds;
  public void init() throws ServletException {
     try{
          Context env =null;
 
                env =(Context) new InitialContext().lookup("java:comp/env");
                  ds = (DataSource)env.lookup("jdbc/myoracle");
               }
               catch (NamingException ne)
                      { throw new ServletException(ne.getMessage());
                 }
  }
 
  public void doGet (HttpServletRequest req, HttpServletResponse res)
          throws ServletException, IOException
        {
     // Send out first page:
       res.setContentType("text/html");
        PrintWriter out = res.getWriter();
 
 
       out.println("In get");
        try{
                    Connection conn = ds.getConnection();
                 Statement stmt = conn.createStatement ();
                    ResultSet rset = stmt.executeQuery ("select empno from emp");
                    out.println ("Hello here");
                    while (rset.next ())
                   out.println (rset.getString (1));
 
              }
              catch (SQLException se)
                    {
                      out.println("Parvalue" + se.getMessage());
  }
 
 
     }
         public void doPost (HttpServletRequest req, HttpServletResponse res)
          throws ServletException, IOException
         {
 
       StringBuffer HTML = new StringBuffer();
       res.setContentType("text/html");
       PrintWriter out = res.getWriter();
 
        try{
            Connection conn = ds.getConnection();
         Statement stmt = conn.createStatement ();
            ResultSet rset = stmt.executeQuery ("select empno from emp");
            out.println ("Hello here");
            while (rset.next ())
           out.println (rset.getString (1));
 
      }
      catch (SQLException se)
            {
              out.println("Parvalue" + se.getMessage());
  }
 
 
 
        }//End of doPost
 
 
}   //end of servlet

[ November 05, 2007: Message edited by: Dan Parsons ]