Cannot find symbol

[Joe Lemmer]

Hi there

I'd be grateful if someone could point out to me where I'm going wrong with the following code. I have one very basic JDBC test program that seems to work fine, but another very similar program where I have the following errors when I try to compile:

cannot find symbol:
symbol: class Statement
location: class Jdbc11
Statement stmt;

cannot find symbol:
symbol: class Connection
location: class Jdc11
Connection con = DriveManager.getConnection("jdbc:mysql://localhost/mysql", "root", "secret");

cannot find symbol:
symbol: variable DriveManager
loction: class Jdbc11
Connection con = DriveManager.getConnection("jdbc:mysql://localhost/mysql", "root", "secret");

Here's the full code for the program that does NOT work:

    
import java.sql.*;
 
public class Jdbc11  {
    public static void main(String args[])  {
        try {
            Statement stmt;
            Class.forName( "com.mysql.jdbc.Driver" );
        
            String url = "jdbc:mysql://localhost:3306/mysql";
 
            Connection con = DriveManager.getConnection("jdbc:mysql://localhost/mysql", "root", "secret");
 
            System.out.println("URL: " + url);
            System.out.println("Connection: " + con);
 
            stmt = con.createStatement();
 
            stmt.executeUpdate(
                        "CREATE DATABASE JunkDB");
 
            stmt.executeUpdate(
                        "GRANT SELECT,INSERT,UPDATE,DELETE," +
                        "CREATE,DROP " +
                        "ON JunkDB.* TO 'auser'@'localhost' " +
                        "IDENTIFIED BY 'drowssap';");
 
            con.close();
        }
 
        catch( Exception e )  {
            e.printStackTrace();
        }  // end catch
 
    }  // end main
 
}  // end class Jdbc11

and just for comparison, here's the code for the program that does work:

import java.sql.* ;
 
public class Test
{
 
    public static void main( String[] args )
    {
        try
        {
            Class.forName( "com.mysql.jdbc.Driver" ).newInstance();
            try
            {
                Connection con = DriverManager.getConnection( "jdbc:mysql://localhost/films", "root", "secret" );
 
                try
                {
                    Statement statement = con.createStatement();
 
                    ResultSet rs = statement.executeQuery("SELECT title FROM film_titles");
 
                    while ( rs.next() )
                    {
                        System.out.println( rs.getString( "title" ) );
                    }
                    rs.close();
                    statement.close();
                }
                catch ( SQLException e )
                {
                    System.out.println( "JDBC error: " + e );
                }
                finally
                {
                    con.close();
                }
            }
            catch( SQLException e )
            {
                System.out.println( "could not get JDBC connection: " + e );
            }
        }
        catch( Exception e )
        {
            System.out.println( "could not load JDBC driver: " + e );
        }
    }
 
}

Cheers

Joe Lemmer

[Ulf Dittmer]

Not sure about the first two, but the last one is explained by a spelling mistake.

[Joe Lemmer]

Hi Ulf

Thanks for the reply.

I've changed the spelling mistake, but I still get the same three errors.

My other program still works though. Very Confusing!

Regards

Joe

[Ulf Dittmer]

Strange. I just copied it verbatim, and it compiles fine (after correcting the typo).

It's especially odd since Connection, Statement and DriverManager are all in the same package, so one would expect the compiler to be able to find all of them, or none.

[Joe Lemmer]

Right. Well at least it compiles on your machine Ulf. It must be something very basic that I'm missing. Think I'll try just typing it in again.

Thanks for your help. :-)
[ November 08, 2008: Message edited by: Joe Lemmer ]