Hi
it is giving u class not found exception coz the class u shud b looking for
is "sun.jdbc.odbc.JdbcOdbcDriver" & not "jdbc.odbc.JdbcOdbcDriver" ... try
working with Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); instead
Class.forName("jdbc.odbc.JdbcOdbcDriver"); c if it works...
Regards,
aruniima
-----Original Message-----
From: rookie jsp [mailto:[EMAIL PROTECTED]]
Sent: Monday, January 21, 2002 4:20 PM
To: [EMAIL PROTECTED]
Subject: JDBC-ODBC trouble
Hi...
I was trying to use JDBC-ODBC brige for the first
time.According to the documetnation the driver comes
inbuilt with the JSDK2.0 version that I have
installed.That would mean that the following JSP
should work perfectly fine.....
but I am afraid it does'nt .....any ideas ppl ?
<html>
<body>
<%@ page import="java.io.*" %>
<%@ page import="java.lang.*" %>
<%@ page import="java.sql.*" %>
<%@ page import="javax.servlet.http.*"%>
<%
Class.forName("jdbc.odbc.JdbcOdbcDriver");
String url = "jdbc:odbc:serverName";
Connection con = DriverManager.getConnection(url,
"user", "passwd");
java.sql.Statement stmt = con.createStatement();
ResultSet rs = stmt.executeQuery("SELECT name FROM
santa");
while (rs.next()) {
String s = rs.getString("name");
System.out.println("Name = " + s);
}
%>
</body>
</html>
the error dumped on the browser is:
javax.servlet.ServletException:
jdbc.odbc.JdbcOdbcDriver
at
org.apache.jasper.runtime.PageContextImpl.handlePageException(Unknown
Source)
at
org.apache.jsp.checkPasswd$jsp._jspService(checkPasswd$jsp.java:100)
at
org.apache.jasper.runtime.HttpJspBase.service(Unknown
Source)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at
org.apache.jasper.servlet.JspServlet.service(Unknown
Source)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardContext.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardHostValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.ErrorReportValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.AccessLogValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at
org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)
root cause
java.lang.ClassNotFoundException:
jdbc.odbc.JdbcOdbcDriver
at
org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown
Source)
at
org.apache.catalina.loader.WebappClassLoader.loadClass(Unknown
Source)
at
org.apache.jasper.servlet.JasperLoader.loadClass(Unknown
Source)
at
org.apache.jasper.servlet.JasperLoader.loadClass(Unknown
Source)
at
java.lang.ClassLoader.loadClassInternal(ClassLoader.java:313)
at java.lang.Class.forName0(Native Method)
at java.lang.Class.forName(Class.java:120)
at
org.apache.jsp.checkPasswd$jsp._jspService(checkPasswd$jsp.java:79)
at
org.apache.jasper.runtime.HttpJspBase.service(Unknown
Source)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.jasper.servlet.JspServlet$JspServletWrapper.service(Unknown
Source)
at
org.apache.jasper.servlet.JspServlet.serviceJspFile(Unknown
Source)
at
org.apache.jasper.servlet.JspServlet.service(Unknown
Source)
at
javax.servlet.http.HttpServlet.service(HttpServlet.java:853)
at
org.apache.catalina.core.ApplicationFilterChain.internalDoFilter(Unknown
Source)
at
org.apache.catalina.core.ApplicationFilterChain.doFilter(Unknown
Source)
at
org.apache.catalina.core.StandardWrapperValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardContextValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardContext.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardHostValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.ErrorDispatcherValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.ErrorReportValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.valves.AccessLogValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardEngineValve.invoke(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invokeNext(Unknown
Source)
at
org.apache.catalina.core.StandardPipeline.invoke(Unknown
Source)
at
org.apache.catalina.core.ContainerBase.invoke(Unknown
Source)
at
org.apache.catalina.connector.http.HttpProcessor.process(Unknown
Source)
at
org.apache.catalina.connector.http.HttpProcessor.run(Unknown
Source)
at java.lang.Thread.run(Thread.java:484)
----------------------------------------------------------------------------
----
__________________________________________________
Do You Yahoo!?
Everything you'll ever need on one web page
from News and Sport to Email and Music Charts
http://uk.my.yahoo.com
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff
JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST
DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
----------------------------------------------------------------------------
This message contains privileged and confidential information and is
intended only for the individual named. If you are not the intended
recipient you should not disseminate, distribute, store, print, copy or
deliver this message. Please notify the sender immediately by e-mail if you
have received this e-mail by mistake and immediately delete this e-mail from
your system.
E-mail transmission cannot be guaranteed to be secure or error-free as
information could be intercepted, corrupted, lost, destroyed, arrive late or
incomplete, or contain viruses. The sender therefore does not accept
liability for any errors or omissions in the contents of this message which
arise as a result of e-mail transmission. If verification is required
please request a hard-copy version.
--------------------------------------------------------------------------
===========================================================================
To unsubscribe: mailto [EMAIL PROTECTED] with body: "signoff JSP-INTEREST".
For digest: mailto [EMAIL PROTECTED] with body: "set JSP-INTEREST DIGEST".
Some relevant FAQs on JSP/Servlets can be found at:
http://archives.java.sun.com/jsp-interest.html
http://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.jsp
http://www.jguru.com/faq/index.jsp
http://www.jspinsider.com
