7 messages in com.mysql.lists.javaRE: Communication failure during hand...
FromSent OnAttachments
John Pedersen31 Jul 2004 00:22 
John Pedersen03 Aug 2004 13:09 
Cesar Vega04 Aug 2004 07:26 
Victor Pendleton04 Aug 2004 07:51 
John Pedersen04 Aug 2004 11:53 
Mark Matthews04 Aug 2004 12:12 
Igor Smirnov05 Aug 2004 04:20 
Subject:RE: Communication failure during handshake
From:Cesar Vega (cesv@hotmail.com)
Date:08/04/2004 07:26:15 AM
List:com.mysql.lists.java

Did you defined the mysql-connector-java-2.0.14-bin.jar in the CLASSPATH? Another solution is to copy the jar file in JAVA_HOME\jre\lib\ext

From: John Pedersen <john@gmail.com>

To: ja@lists.mysql.com Subject: Communication failure during handshake Date: Tue, 3 Aug 2004 21:09:27 +0100

Hi,

Since I have installed mysql 4.1 I am getting this error on trying to reach the db:

java.sql.SQLException: Communication failure during handshake. Is there a server running on localhost:3306?

Mysql is running OK. I can access it with the command prompt, telnet, sqlyog, but not Java.

I have tried using mysql-connector-java-2.0.14-bin.jar and mysql-connector-java-3.1.3-beta-bin.jar. I am sure that the classpath is OK, the url, user, password etc - I have had it all working with mysql 4.0 for months, no problems. I just wanted to be able to use subselects - but if I can't resolve this soon, I will have to return to 4.0

Can anyone help?

Thanks,

John Pedersen

Win2k, j2sdk1.4.2_01

From my Ant script:

<property name="db.driver" value="com.mysql.jdbc.Driver" /> <property name="db.url" value="jdbc:mysql://localhost:3306/dbName" />