cant connect to mysql

[naved momin]

i have mysql installed on my machine and also i have set it up in my ide which is netbeans i have trying to perform simple databse operation
like follows

public class DataBaseDemo {

    /**
     * @param args the command line arguments
     */
    public static void main(String[] args) {
        // TODO code application logic here
        try
        {
            Class.forName("Sun.jdbc.odbc.jdbcodbcDriver");
            Connection con = DriverManager.getConnection("jdbc.odbc.my");
            Statement stat = (Statement) con.createStatement();
            String str ="select * from emp";
            ResultSet rs = stat.execute();


            while(rs.next())
            {
                System.out.println(rs.getInt("empid")+ "" + rs.getString(2));

            }
        }
        catch (ClassNotFoundException ex) {
            Logger.getLogger(DataBaseDemo.class.getName()).log(Level.SEVERE, null, ex);
        }        catch (SQLException ex) {
            Logger.getLogger(DataBaseDemo.class.getName()).log(Level.SEVERE, null, ex);
        }



    }

}

now my problem is

what should be the path in this particular statement 
Class.forName("Sun.jdbc.odbc.jdbcodbcDriver");

and what should be the path in this particular statement '
Connection con = DriverManager.getConnection("jdbc.odbc.my");

thanks for reading this

and one more thing my (mysql ) is runnng fine there is no problem in mysql

[Campbell Ritchie]

I presume that "MySQL is running" means you can run it from the command line.
How are you adding those drivers to the classpath? Always set the classpath locally, not as a system variable.
How are you passing the password?
Is jdbcodbc the right sort of Driver? Have you been through the MySQL handbook, which has a chapter in about connecting from Java™? Try § 20.3.

[naved momin]

Campbell Ritchie wrote:I presume that "MySQL is running" means you can run it from the command line.
How are you adding those drivers to the classpath? Always set the classpath locally, not as a system variable.
How are you passing the password?
Is jdbcodbc the right sort of Driver? Have you been through the MySQL handbook, which has a chapter in about connecting from Java™? Try § 20.3.

no campbell this is not the code for the mysql this code is for connecting to the microsoft sql server with jdbcodbc driver
i m asking what should be the path means driver path in this code for connecting to mysql server

[Campbell Ritchie]

Aren't the details in the MySQL documentation I mentioned earlier? You have to download a .jar with the connector in, and add it to your classpath. Don't set the classpath permanently.

And you are confusing me, asking about MySQL and showing SQL Server driver names.

[Vishal Trivedi]

I use to have following line for my examples
Driver Instance
Class.forName("com.mysql.jdbc.Driver").newInstance();

getting connection
("jdbc:mysql://localhost/ databaseName", "UserName", "Password")


these features are however vendor specific. I had MySQLConnector
Downloaded it from the MySQL website

And besides there is plenty on the web about it.

[Campbell Ritchie]

Vishal Trivedi, thank you. That looks correct. Only, don't display a password, otherwise malicious code or naughty people may be able to read it and use it to harm you.