WARNING: ConnectionID:1 Prelogin error: host 127.0.0.1 port 3306 Unexpected response type:74

Question

Right now I am trying to make a simple DBConnection using Java. I am using the Eclipse IDE for the development. ``` import java.sql.*; public class DbConnect { private static String url = "jdbc:sqlserver://127.0.0.1:3306;databaseName=personal_AkiraDatabase"; private static String user = "XXXX"; private static String password = "XXXX"; public static void main(String [] Args){ try{ Class.forName("com.microsoft.sqlserver.jdbc.SQLServerDriver"); Connection con = DriverManager.getConnection(url, user, password); if(con != null){ System.out.println("Connection was a success!"); }else{ System.out.println("Connection failed. :("); } } catch (ClassNotFoundException e) { e.printStackTrace(); System.out.println("ClassNotFoundException :("); } catch (SQLException e) { e.printStackTrace(); System.out.println("SQLException :("); } } } ``` But currently it gives me this Error Message. Jul 05, 2014 7:20:15 PM com.microsoft.sqlserver.jdbc.SQLServerConnection Prelogin WARNING: ConnectionID:1 Prelogin e…

Accepted Answer

You are using `Mysql` as DB and trying to connect to `SQLSERVER` DB in your code. That is wrong.

An example database connection between `Java` and `Mysql` looks likes below:

```
Class.forName("com.mysql.jdbc.Driver").newInstance();
String url = "jdbc:mysql://localhost:3306/personal_AkiraDatabase";
String username = "xxxx";
String password = "xxxxx"
Connection connection = null;
try {
    System.out.println("Connecting database...");
    connection = DriverManager.getConnection(url, username, password);
    System.out.println("Database connected!");
} catch (SQLException e) {
    throw new RuntimeException("Cannot connect the database!", e);
} finally {
    System.out.println("Closing the connection.");
    if (connection != null) try { connection.close(); } catch (SQLException ignore) {}
}
```

From : Connect Java to a MySQL database

WARNING: ConnectionID:1 Prelogin error: host 127.0.0.1 port 3306 Unexpected response type:74

Solution

Problem

Related problems