Java EE (Java Enterprise Edition) General Discussion

Software
jakarta-tomcat-5.5.2
JDK 1.5
MS Access 2000

Requirements
Connection Pooling in Tomcat

Problem

I inserted a resource Tag in server.xml file

<Resource name="B2BSite" auth="Container"
          type="javax.sql.DataSource" driverClassName="sun.jdbc.odbc.JdbcOdbcDriver"
          url="jdbc:odbc:B2BSite"
          username="myuser" password="mypasswd" maxActive="20" maxIdle="10" maxWait="-1"/>

I also inserted the following line in web.xml.

    <resource-ref>
      <res-ref-name>aaa</res-ref-name>
      <res-type>javax.sql.DataSource</res-type>
      <res-auth>Container</res-auth>
   </resource-ref>

After that I tried to access the java.sql.Connection Object by the following code in JSP

javax.naming.Context initContext = new javax.naming.InitialContext();
javax.naming.Context envContext = (javax.naming.Context)initContext.lookup("java:/comp/env");
javax.sql.DataSource ds = (javax.sql.DataSource)envContext.lookup("aaa");
java.sql.Connection conn = ds.getConnection();
System.out.println(conn);
conn.close();

The following Exception occured

HTTP Status 500 - 
 
--------------------------------------------------------------------------------
 
type Exception report
 
message 
 
description The server encountered an internal error () that prevented it from fulfilling this request.
 
exception 
 
javax.servlet.ServletException: Cannot create JDBC driver of class '' for connect URL 'null'
	org.apache.jasper.runtime.PageContextImpl.doHandlePageException(PageContextImpl.java:825)
	org.apache.jasper.runtime.PageContextImpl.handlePageException(PageContextImpl.java:758)
	org.apache.jsp.B2bSite.test_jsp._jspService(org.apache.jsp.B2bSite.test_jsp:105)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:296)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	temp.loginServlet.doFilter(loginServlet.java:34)
 
 
root cause 
 
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC driver of class '' for connect URL 'null'
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.createDataSource(BasicDataSource.java:780)
	org.apache.tomcat.dbcp.dbcp.BasicDataSource.getConnection(BasicDataSource.java:540)
	org.apache.jsp.B2bSite.test_jsp._jspService(org.apache.jsp.B2bSite.test_jsp:88)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:94)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:325)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:296)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:246)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:802)
	temp.loginServlet.doFilter(loginServlet.java:34)
 
 
note The full stack trace of the root cause is available in the Apache Tomcat/5.5.2 logs.
 
 
--------------------------------------------------------------------------------
 
Apache Tomcat/5.5.2

Thanks in advance

CSJakharia