MySQL connectivity issue

[staneja]

I am trying to create a calss with a constructior that creates connection with MYSql database , i am using database name as dbetch . I have set the path varable but still it id throwing error

package login;
import java.sql.*;
import java.sql.DriverManager;
import com.mysql.jdbc.Connection;
public class conn {
 Connection con=null;
 ResultSet rs=null;
 Statement st=null;

 public conn() {
  Class.forName("com.mysql.jdbc.Driver");

  con=DriverManager.getConnection("jdbc:mysql://localhost/dbetech","root","");
 }
}

Error thrown

D:\etech\WEB-INF\src>javac *.java
conn.java:18: incompatible types
found   : java.sql.Connection
required: com.mysql.jdbc.Connection
                con=DriverManager.getConnection("jdbc:mysql:///dbetech","root","");

1 error

[staneja]

Sorry but i am suing follwoing line to craete connection-:

con=DriverManager.getConnection("jdbc:mysql:///dbetech","root","");

[Ezzaral]

Use java.sql.Connection for your "con" variable type. Just change the import type and it will be fine.

[staneja]

Hey......... it worked for me...thanks a lot