Are you aware of the new placing of files in 6.x? There's a new lib folder.
Put the file there and try again.
On 5/25/07, Mohammed Zabin <[EMAIL PROTECTED]> wrote:
Hello Geeks
Following is my problem, I am trying to configure my Tomcat 6 to connect
to
my localhost Oracle 10g Database, following is my server.xml file :
<Resource name="jdbc/myoracle" auth="Container"
type="javax.sql.DataSource" driverClassName="
oracle.jdbc.OracleDriver"
url="jdbc:oracle:thin:@127.0.0.1:1521:orcldb"
username="hr" password="hr" maxActive="20" maxIdle="10"
maxWait="-1"/>
and i put the following in web.xml:
<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 the following is code is the JSP code:
<%@ page import="javax.naming.Context,javax.naming.InitialContext,
javax.naming.NamingException,javax.sql.DataSource, java.sql.*" %>
<%
Context initContext = new InitialContext();
Context envContext = (Context)initContext.lookup("java:/comp/env");
DataSource ds = (DataSource)envContext.lookup("jdbc/myoracle");
Connection conn = ds.getConnection();
out.println( "Connection Established" );
%>
After running the jsp page, i got the following error:
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)
i have downloaded JDBC driver from otn.oracle classes12.zip and i
changed it to classes12.jar, and put it in CLASSPATH.
I am working on this problem almost from 2 weeks, i didn't know what
the problem is, any help plzzzzzzzzzz
