Getting error while connecting mysql database in java

Question

I have created a program, i need to save the content into mysql database. Could you please help me how to save it through java programming
I have set the sqljdbc.jar classpath, but its giving error

I have used the following code

import java.sql.*;

public class connectURL {

  public static void main(String[] args) {

  String connectionUrl = "jdbc:sqlserver://127.0.0.1:8888;" +
     "databaseName=norton;user=root;password=";

  Connection con = null;
  Statement stmt = null;
  ResultSet rs = null;

  try {
      Class.forName("com.mysql.jdbc.Driver");
      con = DriverManager.getConnection(connectionUrl);
      String SQL = "SELECT TOP 10 * FROM demopoll";
      stmt = con.createStatement();
      rs = stmt.executeQuery(SQL);
      while (rs.next()) {
        System.out.println(rs.getString(4) + " " + rs.getString(6));
      }
    } catch (Exception e) {
      e.printStackTrace();
    } finally {
      if (rs != null) try { rs.close(); } catch(Exception e) {}
      if (stmt != null) try { stmt.close(); } catch(Exception e) {}
      if (con != null) try { con.close(); } catch(Exception e) {}
    }
  }
}

ERROR:

java.lang.ClassNotFoundException: com.microsoft.sqlserver.jdbc.SQLServerDriver

You've tagged this as MySQL, which the jdbc string is for. But the JDBC error is for SQL Server -- a Microsoft product... — OMG Ponies
– OMG Ponies, Commented Jul 24, 2011 at 17:41
Are you using SQL Server or MySQL here? Your question is tagged mysql, and the JDBC driver class (com.mysql.jdbc.Driver) you're using is for MySQL, but sqljdbc.jar is the JAR you use to connect to SQL Server, the connection string also suggests SQL Server, and your ClassNotFoundException (which appears not to match your code) mentions the SQL Server driver. Furthermore, the SQL (SELECT TOP n ...) is valid in SQL Server but not in MySQL. — Luke Woodward
– Luke Woodward, Commented Jul 24, 2011 at 20:59

chedine · Accepted Answer · 2011-07-24 17:35:05Z

2

Your connection string jdbc:sqlserver://127.0.0.1:8888;" + "databaseName=norton;user=root;password= doesn't look like a valid connection string for a mysql database. Check this.
Aslo make sure you have mysql java connector in the build path.

answered Jul 24, 2011 at 17:35

chedine

2,3743 gold badges19 silver badges24 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

dan · Accepted Answer · 2011-07-24 17:21:14Z

0

Did you set Java Build Path to contain the sql jar?

answered Jul 24, 2011 at 17:21

dan

741 bronze badge

Collectives™ on Stack Overflow

Getting error while connecting mysql database in java

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related