No database selected error in jdbc for mysql application

[rk sharma]

import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.ResultSet;
import java.sql.Statement;

public class JdbcMySql {

    public static void main(String[] args) throws Exception {

        // Load the JDBC-ODBC bridge driver
        
        Class.forName("sun.jdbc.odbc.JdbcOdbcDriver");
        
        // Connect to the database
        Connection con = DriverManager.getConnection("jdbc:odbc:radha", "root", "sharma");
        Statement stmt = con.createStatement();
		
        ResultSet rs=stmt.executeQuery("select * from employee");
		while(rs.next())
		{
			System.out.println(rs.getInt(1)+"	"+rs.getString(2)+"	 "+rs.getFloat(3));
		}
	}
}

and the error is

"No database selected"

very simple application how to resolve this one...please help me

[Paul Clapham]

That means that you haven't selected a database, like it says. But the selection of the database would be somewhere in the ODBC configuration, so showing us Java code isn't actually of any use.

So either fix your ODBC configuration to select a database, or (a better option) stop using ODBC and use the MySQL JDBC driver.

[Jan Cumps]

Welcome to the Ranch, Radhakrishna.

While you are learning to connect to MySQL, can I point you to the MySQL jdbc driver in stead of the odbc bridge driver, as Paul advised?

[rk sharma]

Thank you paul. for your reply.
i already created odbc DSN for MySql.
what would be the actual error,please suggest me.
and please tell me that how to use type4 MySql driver?