Hi Man,
Where is your connection Interface and result set Interface? If you add those two, probably your problem will be solved. If you don't provide any database access statements, it gives the error of SQLException. I think it will help.
Hari
>From: Thang Nguyen <[EMAIL PROTECTED]>
>Reply-To: A mailing list about Java Server Pages specification and reference <[EMAIL PROTECTED]>
>To: [EMAIL PROTECTED]
>Subject: JBDC/OBDC driver loading problem.
>Date: Tue, 27 Feb 2001 11:25:45 -0800
>
>Hi,
>
>I am currently using Tomcat4.0 and jdk1.3 and my system is Windows
>2000. I setup everything and it works fine. However, when I try
>to run one of my servlets (a servlet that will connect to odbc
>database). Pls take a look at
>my CLASSPATH and servelt, let me know if I am missing something. Thanks
>much.
>
>
>I got the error complaining about the driver which is "SQLException
>caught: No suitable driver"
>
>Here is my CLASSPATH:
>CLASSPATH= C:\tomcat4.0\jakarta-tomcat-4.0\bin\servlet.jar;
>C:\jdk1.3\jre\lib\rt.jar
>
>
>And here is my java code:
>
>
>/*
>VideoSelectServlet
>*/
>
>import java.io.*;
>import java.sql.*;
>import javax.servlet.*;
>import javax.servlet.http.*;
>
>/**
> * This is a simple example of an HTTP Servlet. It responds to the GET
> * method of the HTTP protocol.
> **/
>public class VideoSelectServlet extends HttpServlet {
>
> public void doGet (HttpServletRequest request,
> HttpServletResponse response)
> throws ServletException, IOException
> {
> Connection con = null;
> Statement stmt = null;
> ResultSet rs = null;
>
> try {
> Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
> String url = "jdbc.odbc.Movie Catalog";
> con = DriverManager.getConnection (url, "", "");
> System.out.println("Testpoint");
> }
> catch (ClassNotFoundException e) {
> System.out.println("SQLException caught: " + e.getMessage());
>
> }
> catch (SQLException e) {
> System.out.println("SQLException caught: " + e.getMessage());
>
> }
> finally {
> try {
> if (con != null) con.close();
> }
> catch (SQLException ignored) {}
> }
> }
>
> public String getServletInfo() {
> return "The BookDetail servlet returns information about" +
> "any book that is available from the bookstore.";
> }
>}
>
>===========================================================================
>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://java.sun.com/products/jsp/faq.html
> http://www.esperanto.org.nz/jsp/jspfaq.html
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
> http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
Get your FREE download of MSN Explorer at
http://explorer.msn.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://java.sun.com/products/jsp/faq.html
http://www.esperanto.org.nz/jsp/jspfaq.html
http://www.jguru.com/jguru/faq/faqpage.jsp?name=JSP
http://www.jguru.com/jguru/faq/faqpage.jsp?name=Servlets
