MySql , Eclipse . Type MisMatch of Connection object . Please help me...

[j_arif123]

Please help me to fix this code:

 import java.sql.*;

public class ColumnName{
  public static void main(String[] args) {
  System.out.println("Getting Column Names Example!");
  Connection con= null;
  Statement st = null;
  String url = "jdbc:mysql://localhost:3306/";
  String db = "my_sample_db";
  String driver = "com.mysql.jdbc.Driver";
  String user = "root";
  String pass = "";
  try{
  Class.forName(driver);
  con = DriverManager.getConnection(url+db, user, pass);
  try{
	  	st = ((java.sql.Connection) con).createStatement();
  		ResultSet rs = st.executeQuery("SELECT * FROM employee");
  		ResultSetMetaData md = rs.getMetaData();
  		int col = md.getColumnCount();
  		System.out.println("Number of Column : " + col);
  		System.out.println("Columns Name: ");
  		for (int i = 1; i <= col; i++){
  		String col_name = md.getColumnName(i);
  		System.out.println(col_name);
  }
  }
  catch (SQLException s){
  System.out.println("SQL statement is not executed!");
  }
  }
  catch (Exception e){
  e.printStackTrace();
  }
  }
}

Console Error:

Exception in thread "main" java.lang.Error: Unresolved compilation problem:
Type mismatch: cannot convert from java.sql.Connection to Connection

at ColumnName.main(ColumnName.java:15)

As a newbie , i started using database from few days ago. So , I think i did not configure mysql-connector/j properly. So, please give me some tips about this. Advance Thankssssss.

[Tolls]

Do you have another class called Connection in your class path?
That's what that error looks like.

This cast:

((java.sql.Connection) con).createStatement();

is unecessary by the way.
Just con.createStatement().

[j_arif123]

Do you have another class called Connection in your class path?

No.
But when i combined line-6 :

Connection con= null;

and line-15

con = DriverManager.getConnection(url+db, user, pass);

,

that error gone away (as below).

java.sql.Connection con = DriverManager.getConnection(url+db, user, pass);

After above changed is made , i replaced

st = ((java.sql.Connection) con).createStatement();

by

st.createStatement();

At first time when this casting was not done, an error was thrown . But now no cast is done , and there is no error ?! How?
But still there are some questions : 1) Wont eclipse recognise our code and the jar files added under 'referenced libraries' itself when when compilation and execution?
2) When creating objects of classes of jdbc , is it necessary to write code like : java.sql.Connection..... etc... ?

[Tolls]

There must have been another Connection class somewhere for that error.
Anyway, normally you don't have to specifiy the full classname (class and package).
The only time is if there is a clash of names, ie two classes with the same name from different packages (eg java.util.Date and java.sql.Date).

So, since you are including java.sql.Connection (it's generally better to include each class, rather than using '*'), you should not need to say Java.sql.Connection.