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 >