Communications link failure
Hey,
This is my first time using the jdbc:mysql driver but ive used both Java and mySQL for years.
The mysql server works fine from a CLI or PHP.
Im having an issue connecting to mysql via this driver via both a Java class i made and SQuirreL SQL.
The message i get back from both is:
-----------------------------------------------
-----------------------------------------------
Communications link failure
Last packet sent to the server was 0 ms ago.
-----------------------------------------------
-----------------------------------------------
The full Exception/Stacktrace from java is:
-----------------------------------------------
---------- START JAVA EXCEPTION -------
-----------------------------------------------
SQLException: Communications link failure
Last packet sent to the server was 0 ms ago.
SQLState: 08S01
VendorError: 0
***** START STACK ******
com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
Last packet sent to the server was 0 ms ago.
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:1074)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2104)
at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:729)
at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:46)
at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:39)
at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:27)
at java.lang.reflect.Constructor.newInstance(Constructor.java:513)
at com.mysql.jdbc.Util.handleNewInstance(Util.java:406)
at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:302)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:283)
at java.sql.DriverManager.getConnection(DriverManager.java:582)
at java.sql.DriverManager.getConnection(DriverManager.java:185)
at org.red5.server.webapp.TodayTonight.mysql.Connect(mysql.java:23)
at org.red5.server.webapp.TodayTonight.mysql.main(mysql.java:85)
Caused by: java.net.ConnectException: Connection refused: connect
at java.net.PlainSocketImpl.socketConnect(Native Method)
at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:333)
at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:195)
at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:182)
at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:366)
at java.net.Socket.connect(Socket.java:519)
at java.net.Socket.connect(Socket.java:469)
at java.net.Socket.<init>(Socket.java:366)
at java.net.Socket.<init>(Socket.java:209)
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:256)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276)
at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2027)
... 13 more
***** END STACK ******
-----------------------------------------------
----------- END JAVA EXCEPTION --------
-----------------------------------------------
My java src is:
-----------------------------------------------
-------------- START JAVA SRC -----------
-----------------------------------------------
package org.red5.server.webapp.TodayTonight;
import java.sql.*;
class mysql {
public static Connection conn = null;
public static void Connect(String User, String Pass, String Host, String DB)
{
try
{
//Class.forName("org.gjt.mm.mysql.Driver").newInstance();
Class.forName ("com.mysql.jdbc.Driver");
}
catch(Exception e)
{
System.out.println("Error: " + e);
}
//String url = "jdbc:mysql://"+Host+":3306/"+DB+"?user="+User+"&password="+Pass;
String url = "jdbc:mysql://localhost:3006/"+DB;
try
{
conn = DriverManager.getConnection (url, User, Pass);
//conn = DriverManager.getConnection (url);
System.out.println ("Database connection established");
}
catch (SQLException ex)
{
System.out.println("Connection was not established");
System.out.println("SQLException: " + ex.getMessage());
System.out.println("SQLState: " + ex.getSQLState());
System.out.println("VendorError: " + ex.getErrorCode());
System.out.println("\n\n***** START STACK ******\n");
ex.printStackTrace();
System.out.println("\n***** END STACK ******");
}
}
public static void Disconnect()
{
if (conn != null)
{
try
{
conn.close ();
System.out.println ("Database connection terminated");
}
catch (Exception e) {}
}
}
public static void main (String[] args)
{
Connect("root","<password>","localhost","mysql");
}
}
-----------------------------------------------
--------------- END JAVA SRC ------------
-----------------------------------------------
Any light on this issue would be great
PS: my testing server is on the same PC running XP Pro SP2 and using MYSQL 5.0 and JAVA jdk 1.6
Subject
Written By
Posted
Communications link failure
January 16, 2008 01:14AM
February 02, 2008 08:03AM
February 25, 2008 05:54PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.