type Exception report

message 

description The server encountered an internal error () that prevented it from fulfilling  this  request.

exception 

javax.servlet.ServletException:  Class  TestMysql is not a Servlet
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
	org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 212 )
	org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 818 )
	org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java: 624 )
	org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 445 )
	java.lang.Thread.run(Unknown Source)


root cause 

java.lang.ClassCastException: TestMysql
	org.apache.catalina.valves.ErrorReportValve.invoke(ErrorReportValve.java: 105 )
	org.apache.catalina.connector.CoyoteAdapter.service(CoyoteAdapter.java: 212 )
	org.apache.coyote.http11.Http11Processor.process(Http11Processor.java: 818 )
	org.apache.coyote.http11.Http11Protocol$Http11ConnectionHandler.process(Http11Protocol.java: 624 )
	org.apache.tomcat.util.net.JIoEndpoint$Worker.run(JIoEndpoint.java: 445 )
	java.lang.Thread.run(Unknown Source)


note The full stack trace of the root cause is available in the Apache Tomcat/ 6 . 0 . 2  logs.

D:\Tomcat\webapps\ROOT\WEB-INF\lib\j2ee.jar; D:\Tomcat\webapps\ROOT\WEB-INF\lib\servlet-api.jar;C:\mysql-connector-java- 3 . 1 . 14 \mysql-connector-java- 3 . 1 . 14 -bin.jar TestMysql;

 import  java.sql.*;
 import  javax.servlet.*;

 public   class  TestMysql  extends  HttpServlet
{
   public   static   void  main(String args[]) {
     try  {
     

      String driver = "com.mysql.jdbc.Driver";

      System.out.println( "=> loading driver:" );
       Class .forName( driver );
      System.out.println( "OK" );

     

      String url = "jdbc:mysql://localhost:3306/test";

      System.out.println( "=> connecting:" );
      DriverManager.getConnection( url, "", "" );
      System.out.println( "OK" );
    }
     catch ( Exception x ) {
      x.printStackTrace();
    }
  }
}

<?xml version="1.0" encoding="ISO-8859-1"?>

<!DOCTYPE web-app
     PUBLIC  "-//Sun Microsystems, Inc.//DTD Web Application 2.3//EN"
    "http://java.sun.com/dtd/web-app_2_3.dtd">

<web-app>

  <servlet>
    <servlet-name>SendMailServlet</servlet-name>
    <servlet- class >SendMailServlet</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>SimpleMailReader</servlet-name>
    <servlet- class >SimpleMailReader</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>Log1</servlet-name>
    <servlet- class >LoginServlet</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>sql</servlet-name>
    <servlet- class >mysql</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>Simple</servlet-name>
    <servlet- class >SimpleServlet</servlet- class >
  </servlet>

<servlet>
    <servlet-name>SimpleMail</servlet-name>
    <servlet- class >SimpleMailUser</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>TestMysql</servlet-name>
    <servlet- class >TestMysql</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>Client</servlet-name>
    <servlet- class >Client </servlet- class >
  </servlet>
   
  <servlet>
    <servlet-name>LoginHandler</servlet-name>
    <servlet- class >LoginHandler</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>SessionLogin</servlet-name>
    <servlet- class >SessionLogin</servlet- class >
  </servlet>

  <servlet>
    <servlet-name>UserAuthentication</servlet-name>
    <servlet- class >UserAuthentication</servlet- class >
  </servlet>



  <servlet-mapping>
    <servlet-name>SendMailServlet</servlet-name>
    <url-pattern>/SendMailServlet</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>SimpleMailReader</servlet-name>
    <url-pattern>/SimpleMailReader</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>Log1</servlet-name>
    <url-pattern>/Login</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>sql</servlet-name>
    <url-pattern>/sql</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>Simple</servlet-name>
    <url-pattern>/Sim</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>SimpleMail</servlet-name>
    <url-pattern>/Simpl</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>TestMysql</servlet-name>
    <url-pattern>/Test3</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>Client</servlet-name>
    <url-pattern>/Client</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>LoginHandler</servlet-name>
    <url-pattern>/Log</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>SessionLogin</servlet-name>
    <url-pattern>/Session</url-pattern>
  </servlet-mapping>

  <servlet-mapping>
    <servlet-name>UserAuthentication</servlet-name>
    <url-pattern>/User</url-pattern>
  </servlet-mapping>

 <resource-ref>
        <description>MySQL Datasource example</description>
        <res-ref-name>jdbc/test</res-ref-name>
        <res-type>javax.sql.DataSource</res-type>
        <res-auth>admin</res-auth>
    </resource-ref>


</web-app>

/ИМЯ_АРХИВА
..../WEB-INF
......../classes
............TestMysql.class
......../lib
............Необходимые библиотеки
........web.xml

HTTP Status  405  - HTTP method GET is not supported by  this  URL

 import  java.sql.*;
 import  javax.servlet.*;

 public   class  TestMysql 
{
   public   static   void  main(String args[]) {
     try  {
      /* Test loading driver */

      String driver = "com.mysql.jdbc.Driver";

      System.out.println( "=> loading driver:" );
       Class .forName( driver );
      System.out.println( "OK" );

      /* Test the connection */

      String url = "jdbc:mysql://localhost:3306/test";

      System.out.println( "=> connecting:" );
      DriverManager.getConnection( url, "", "" );
      System.out.println( "OK" );
    }
     catch ( Exception x ) {
      x.printStackTrace();
    }
  }
}

 public   class  TestMysql  extends  javax.servlet.http.HttpServlet {

     protected   void  doPost(javax.servlet.http.HttpServletRequest request,
                          javax.servlet.http.HttpServletResponse response)
             throws  javax.servlet.ServletException, java.io.IOException {

        processRequest(request, response);
    }

     protected   void  doGet(javax.servlet.http.HttpServletRequest request,
                         javax.servlet.http.HttpServletResponse response)
             throws  javax.servlet.ServletException, java.io.IOException {