Thank you
Lib folder in CATALINA_HOME, as mentioned in Tomact 6, isn't it?
On 5/25/07, Javier Ortiz <[EMAIL PROTECTED]> wrote:
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
>
