Hi, I hope someone can help me with this :
(thanks in advance)

1. I have downloaded the JSDK2.0 which has a 'servletrunner'
   and the example servlets and some of my own work fine with
   it. I understand that at least for now I can use the
   'servletrunner' from the JSDK2.0 instead of the JServ.
   (Does anyone use JDBC with servletrunner ???)
 
2. BUT then when I want to connect with the JDBC of my Database
   (Sybase Anywhere Server) from a servlet I get this from the
   servletrunner : 
------------------------------------------------------------------------
   servletrunner starting with settings:
  port = 8080
  backlog = 50
  max handlers = 100
  timeout = 5000
  servlet dir = ./examples
  document dir = ./examples
  servlet propfile = ./examples/servlet.properties
addressbook: init
java.lang.ClassNotFoundException
        at sun.servlet.ServletLoader.loadClass(ServletLoader.java:227)
        at java.lang.ClassLoader.loadClassInternal(ClassLoader.java)
        at addressbook.doGet(addressbook.java:37)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:499)
        at javax.servlet.http.HttpServlet.service(HttpServlet.java:588)
        at sun.servlet.http.HttpServerHandler.sendResponse(HttpServerHandler.java:165)
        at 
sun.servlet.http.HttpServerHandler.handleConnection(HttpServerHandler.java:121)
        at sun.servlet.http.HttpServerHandler.run(HttpServerHandler.java:90)
        at java.lang.Thread.run(Thread.java)

------------------------------------------------------------------------
   WHAT does it exactly mean ? The servlet compiled fine and appeared to
   have found all the classes from the jsdk.jar and the classes.zip (containing
   also the JDBC driver etc.)
   Also, my code with JDBC connection works fine in a Java standalone program.
 
   The servlet throws an exeption already when I want to load the JDBC driver
   with           Class.forName("com.sybase.jdbc.SybDriver").newInstance();
   
   When compiling the servlet I see that it loads the class 'Class'. So where
   the heck does the exception come from ???????

   Does the CLASSPATH setting work differently in servlets than in java-standalone
   programs ???

   I add my code below, it is is rather short:

   ----------servlet code with JDBC------------------------------------
import java.io.*;
import java.sql.*;
import java.text.*;
import java.util.*;
import com.sybase.utils.Debug;
import com.sybase.jdbc.*;
import com.sybase.*;
import javax.servlet.*;
import javax.servlet.http.*;
import java.net.*;

public class addressbook extends HttpServlet
{
    public void doGet (
        HttpServletRequest      req,
        HttpServletResponse     res
    ) throws ServletException, IOException
    {

       Connection con = null;
       Statement stmt = null;
       ResultSet rs = null;

        res.setContentType("text/html");
        PrintWriter out = res.getWriter();

        out.println("<HTML><HEAD><TITLE>Addressen</TITLE></HEAD>");
        out.println("<BODY>");
        out.println("<UL>");
        out.println("Hi Norman");

        try
        {

          //grrrrrrrrrrr : next line throws already an exeption in the 'servletrunner'
          // WHY ????
          Class.forName("com.sybase.jdbc.SybDriver").newInstance();
          out.println("Driver loaded");

//naturally I have altered the severname and password info for this Email
 con = 
DriverManager.getConnection("jdbc:sybase:Tds:flower.someone.com:2638?ServiceName=mydata.db","User","passwd");

          out.println("db-connected");
        stmt = con.createStatement();
        rs = stmt.executeQuery("SELECT * FROM people");

            while(rs.next()) {
                 String ename = rs.getString("au_fname");
                 String ename1 = rs.getString("au_lname");
                 ename = ename + " " + ename1;
                 out.println(ename);
            }
           out.println("</UL>");
           out.println("</BODY></HTML>");

            // Close the connection
            con.close();


        }
        catch (SQLException ex)
        {
            //displaySQLEx(ex);
            System.out.println("Exeption was thrown.");
        }
        catch (java.lang.Exception ex)
        {
          out.println("exeption");
          ex.printStackTrace ();
        }

            out.close();
    }
}


 
 



 
   


-- 

          
                    --------------------------- 
                       Dr. Norman Fahrer
                       [EMAIL PROTECTED]






----------------------------------------------------------------
To subscribe:        [EMAIL PROTECTED]
To unsubscribe:      [EMAIL PROTECTED]
Archives and Other:  <http://java.apache.org/main/mail.html/>
Problems?:           [EMAIL PROTECTED]

Reply via email to