MySql database - Java connectivity
-
Hi! How to connect Java to the MySql database? I am using Eclipse 3.1. and Mysql 5.1. Is there any Mysql driver needed to instal or is SQL driver sufficient? Plz give the link to instal Mysql driver. import java.sql.*; public class jdbc { public static void main (String[] args) { try { Class.forName("sun.jdbc.odbc.JdbcOdbcDriver"); } catch(ClassNotFoundException e) { System.out.println("Unable to load driver class"); } try { Connection dbcon=DriverManager.getConnection("jdbc:odbc:employee","","deepali"); Statement stmt=dbcon.createStatement(); ResultSet res=stmt.executeQuery("SELECT NAME FROM EMPLOYEE"); while(res.next()) { System.out.println(res.getString("NAME")); } res.close(); stmt.close(); dbcon.close(); } catch(SQLException se) { System.out.println("SQL Exception : "+se.getMessage()); se.printStackTrace(System.out); } } } Error: SQL Exception : [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. java.sql.SQLException: [Microsoft][ODBC SQL Server Driver][DBNETLIB]SQL Server does not exist or access denied. at sun.jdbc.odbc.JdbcOdbc.createSQLException(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.standardError(Unknown Source) at sun.jdbc.odbc.JdbcOdbc.SQLDriverConnect(Unknown Source) at sun.jdbc.odbc.JdbcOdbcConnection.initialize(Unknown Source) at sun.jdbc.odbc.JdbcOdbcDriver.connect(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at java.sql.DriverManager.getConnection(Unknown Source) at jdbc.main(jdbc.java:17) Plz help. Thanks in advance.