problem with msql and servlet

[Marcos]

hi,

    i have created a servlet to access to a mysql database. the servlet
is like this one:

import java.sql.*;

public class QueryCoffees {
    public static void main(String args[]) {

        String username = "xxx";
        String password = "xxx";
        String url = "jdbc:mysql://localhost:3306/docencia";
        String queryString = "SELECT codigo, dni FROM docencia";

        try {
            Class.forName("org.gjt.mm.mysql.Driver");
        } catch(java.lang.ClassNotFoundException e) {
            System.err.print("ClassNotFoundException: ");
            System.err.println(e.getMessage());
        }

        try {
            Connection con;
            Statement stmt;

            con = DriverManager.getConnection(url, username, password);
            System.out.println ("Ok, connection to the DB worked.");
            System.out.println ("Let's see can retrieve something with:
" + queryString);


            stmt = con.createStatement();
            ResultSet rs = stmt.executeQuery(queryString);
            while (rs.next()) {
                String s = rs.getString("codigo");
                String n = rs.getString("dni");
....
....
....
}


in error_log (apache directory):

java.lang.ClassCastException: QueryCoffees
        at org.apache.jserv.JServServletManager.load_init(Compiled Code)

        at org.apache.jserv.JServServletManager.loadServlet(Compiled
Code)
        at org.apache.jserv.JServConnection.processRequest(Compiled
Code)
        at org.apache.jserv.JServConnection.run(Compiled Code)
        at java.lang.Thread.run(Compiled Code)

in  mod_jserv.log:

    [23/10/2000 17:24:00:932] (EMERGENCY) ajp12[1]: cannot scan servlet
headers  (500)
    [23/10/2000 17:24:00:932] (ERROR) an error returned handling request
via protocol "ajpv12"

thanks in advance,

marcos


--
m a r c o s @ i v a l . e s

___________________________________________________________________________
To unsubscribe, send email to [EMAIL PROTECTED] and include in the body
of the message "signoff SERVLET-INTEREST".

Archives: http://archives.java.sun.com/archives/servlet-interest.html
Resources: http://java.sun.com/products/servlet/external-resources.html
LISTSERV Help: http://www.lsoft.com/manuals/user/user.html