Problem :
I want my database to talk to my Java programs.
I am getting following error message.
Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:48)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:36)
at java.lang.reflect.Constructor.newInstance(Constructor.java:612)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:518)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:2233)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:3351)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:999)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:56)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:40)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:30)
at java.lang.reflect.Constructor.newInstance(Constructor.java:600)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:512)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:300)
at java.sql.DriverManager.getConnection(DriverManager.java:600)
at java.sql.DriverManager.getConnection(DriverManager.java:310)
at SqlTest.main(SqlTest.java:33)
Caused by: com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
Can somebody give me the quick and easy fix for my issue?
Contents of my test file as below:
import com.mysql.jdbc.*;
import java.sql.Connection;
import java.sql.DriverManager;
import java.sql.PreparedStatement;
import java.sql.ResultSet;
import java.sql.SQLException;
import java.sql.Statement;
public class JdbcSqlTest {
public static void main(String [] args) throws Exception {
// Class.forName( "com.mysql.jdbc.Driver" ); // do this in init
// // edit the jdbc url
Connection connect = DriverManager.getConnection(
"jdbc:mysql://localhost:3310/projects?user=user1&password=123");
// Statement stat = connect.createStatement();
// ResultSet result = stat.executeQuery( "select * from table" );
System.out.println("Connected?");
}
}