anyways, i put the jar file in my classpath, and this will override the lib folder i think, isn't it?
On 5/25/07, Javier Ortiz <[EMAIL PROTECTED]> wrote:
Yes but not in the same path as in previous versions. On 5/25/07, Mohammed Zabin <[EMAIL PROTECTED]> wrote: > > 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 > > > > > >