Tomcat with Oracle 11g

Hello,

I'm upgrading a legacy application to use an Oracle 11g database (moving from 9i) and I seem to be having some troubles connecting to the db. According to Oracle's documentation I need the 'ojdbc6.jar' file as described here: driver

So I downloaded that file and placed it into the $CATALINA_HOME/lib directory. I reloaded the app and now when I try to access it I get the following:

...root cause

java.lang.NoClassDefFoundError: oracle/jdbc/pool/OracleDataSource
	<context>.doGet(WebReportMain.java:66)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
	org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
	org.apache.jsp.jsp.login_jsp._jspService(login_jsp.java:57)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
root cause

java.lang.ClassNotFoundException: oracle.jdbc.pool.OracleDataSource
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1387)
	org.apache.catalina.loader.WebappClassLoader.loadClass(WebappClassLoader.java:1233)
	java.lang.ClassLoader.loadClassInternal(ClassLoader.java:320)
	<context>.doGet(WebReportMain.java:66)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:617)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.runtime.PageContextImpl.doForward(PageContextImpl.java:706)
	org.apache.jasper.runtime.PageContextImpl.forward(PageContextImpl.java:677)
	org.apache.jsp.jsp.login_jsp._jspService(login_jsp.java:57)
	org.apache.jasper.runtime.HttpJspBase.service(HttpJspBase.java:70)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)
	org.apache.jasper.servlet.JspServletWrapper.service(JspServletWrapper.java:374)
	org.apache.jasper.servlet.JspServlet.serviceJspFile(JspServlet.java:342)
	org.apache.jasper.servlet.JspServlet.service(JspServlet.java:267)
	javax.servlet.http.HttpServlet.service(HttpServlet.java:717)

Does anyone have any suggestions or experience with this? Please keep in mind that I am relatively new to Tomcat and java applications.

BTW...I'm using tomcat 6.0.20 and JVM 1.6.0_10 with Oracle 11.1.0.6

Thanks in advance!

Check that your JAR file is not corrupted. Unpack it and check that oracle.jdbc.pool.OracleDataSource.class is there.

Thanks for the reply...I verified that the file size is the same as what is published on Oracle's website. Also I did find the 'oracle.jdbc.pool.OracleDataSource' class when I ran: .

Any other suggestions?

Thanks!!!

Ok, I got passed that problem...turns out I was missing mail.jar. I'm not sure why that didn't appear before.

Anyway, now I've gotten to a login page that try's to get credentials from the browser. The original version of this app uses kerberos authentication via pubcookie. Is anyone familiar with this at all?

Thanks in advance!