ciao a tutti
su invito del moderatore apro un nuovo topic

Ho questo problema
java.sql.SQLException: No suitable driver

quando eseguo il seguente codice preso dal libro deitel


codice:
// Fig. 28.23: DisplayAuthors.java
// Displaying the contents of the authors table.
import java.sql.Connection;
import java.sql.Statement;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.ResultSetMetaData;
import java.sql.SQLException;

public class DisplayAuthors
{
   // database URL
   static final String DATABASE_URL = "jdbc:mysql://localhost/books";

   // launch the application
   public static void main( String args[] )
   {
      Connection connection = null; // manages connection
      Statement statement = null; // query statement
      ResultSet resultSet = null; // manages results

      // connect to database books and query database
      try
      {
         // establish connection to database
         connection = DriverManager.getConnection(
            DATABASE_URL, "deitel", "deitel" );

         // create Statement for querying database
         statement = connection.createStatement();

         // query database
         resultSet = statement.executeQuery(
            "SELECT authorID, firstName, lastName FROM authors" );

         // process query results
         ResultSetMetaData metaData = resultSet.getMetaData();
         int numberOfColumns = metaData.getColumnCount();
         System.out.println( "Authors Table of Books Database:\n" );

         for ( int i = 1; i <= numberOfColumns; i++ )
            System.out.printf( "%-8s\t", metaData.getColumnName( i ) );
         System.out.println();

         while ( resultSet.next() )
         {
            for ( int i = 1; i <= numberOfColumns; i++ )
               System.out.printf( "%-8s\t", resultSet.getObject( i ) );
            System.out.println();
         } // end while
      }  // end try
      catch ( SQLException sqlException )
      {
         sqlException.printStackTrace();
      } // end catch
      finally // ensure resultSet, statement and connection are closed
      {
         try
         {
            resultSet.close();
            statement.close();
            connection.close();
         } // end try
         catch ( Exception exception )
         {
            exception.printStackTrace();
         } // end catch
      } // end finally
   } // end main
} // end class DisplayAuthors
ho eseguito il seguente comando nella cartella che contiene DisplayAuthors

>java -classpath .;c:\mysql-connector-java-5.1.14\mysql-connector-java-5.1.14-bin.jar DisplayAuthors

dopo aver avviato il server con il comando mysqld

insomma dopo aver seguito tutta la procedura del libro ma niente da fare

Ho visto altre discussioni che in passato hanno affrontato tale problema..
grazie a chiunque vorrà aiutarmi