DBCP

[Mohammed Zabin]

*Hi All*
**
*I want to use DBCP to connect my localhost Oracle Database, I have write
the following in servlet.xml file:*

<Resource name="jdbc/myoracledb" auth="Container"
                 type="javax.sql.DataSource" />

   <ResourceParams name="jdbc/myoracledb">
      <parameter>
         <name>factory</name>
         <value>org.apache.commons.dbcp.BasicDataSourceFactory</value>
      </parameter>
      <parameter>
         <name>driverClassName</name>
         <value>oracle.jdbc.OracleDriver</value>
      </parameter>
      <parameter>
         <name>url</name>
         <value>jdbc:oracle:thin:@127.0.0.1:1521:mine</value>
      </parameter>
      <parameter>
         <name>username</name>
         <value>hr</value>
      </parameter>
      <parameter>
         <name>password</name>
         <value>hr</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>

*and the following in web.xml file:*

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

*and following is my JSP code:*


<%@ page import="javax.sql.*, javax.naming.*, java.sql.*" %>

<%
 Context initContext = new InitialContext();
 Context envContext  = (Context)initContext.lookup("java:/comp/env");
 DataSource ds = (DataSource)envContext.lookup("jdbc/myoracledb");
 Connection conn = ds.getConnection();

 out.println( "Connection Established" );
%>

*When running the above jsp page, i got the following exception:*

*org.apache.jasper.JasperException: javax.servlet.ServletException:
org.apache.tomcat.dbcp.dbcp.SQLNestedException: Cannot create JDBC
driver of class '' for connect URL 'null'
        
org.apache.jasper.servlet.JspServletWrapper.handleJspException(JspServletWrapper.java:532)
        
org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:408)
        org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:320)
        org.apache.jasper.servlet.JspServlet.service(JspServlet.java:266)
        javax.servlet.http.HttpServlet.service(HttpServlet.java:803)*

Any Help Please, I am working to solving this problem from one week, I
am lost, what is the reason for this exception, any help will be
apprecieated

Jotnarta