jdbc compilation error too weird

[gopal krishnan]

i am trying to execute the below simple java program
but i am getting the below error..

import java.sql.*;

class SqlConnection {
	public static void main(String[] args) {
		Connection con = null;
		try 
		{
			Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
			con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.accdb)}; DBQ=C:\\Users\\gopc\\odbc_sql.accdb","","");
			Statement statement = con.createStatement();
			statement.execute("select * from log_entry");
			ResultSet rs = statement.getResultSet();
			if (rs != null)
			{
				while (rs.next())
				{
					System.out.println(rs.getString("date"));
				}
			}
		} catch (Exception e) {
			System.out.println("Error: " + e);
		}
	}
}

getting the below compilation error, seems to be too weired.

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>javac SqlConnection.java
SqlConnection.java:9: error: incompatible types
con = DriverManager.getConnection("jdbc:odbc:Driver={Microsoft Acess Driver (*.accdb)}; DBQ=C:\\Users\\gopc\\odbc_sql.accdb","","");
^
required: Connection
found: java.sql.Connection
SqlConnection.java:10: error: cannot find symbol
Statement statement = con.createStatement();
^
symbol: method createStatement()
location: variable con of type Connection
2 errors

C:\Documents and Settings\gopc\workspace\JDBC_Connection\src>

[Campbell Ritchie]

What does it say in the getConnection method documentation?
Have you got another Connection class of your own?

[gopal krishnan]

i'm not defining it.. using the existing..

[Wendy Gibbons]

on the line you declare the con variable explicitly give the whole lot: java.sql.connection (getting the case correct).
and the same for driver mananger java.sql.DriverManager.
Just to see if somehow you are not using the classes you expect to be.

[Matthew Brown]

It does look like you have another Connection class in the same package. Possibly a compiled version that's hanging around even if you've deleted the source code. If you examined what Connection.class referred to it would confirm it.