Greetings All,

Would love some help on the following problem please :-))))

The error message I'm getting is:

SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException)

And yet I've tested MySQL and Java independently :-( I think that this problem could be something do to with the MySQL configuration - but I really don't know :-( See below for details, and let me know if I need to provide anymore information

Any help is greatly, muchly, heaps and heaps appreciated !!!!!!

Thanx, Gareth

Problem Details

Setup I'm using: JDK1.4, the lastest version of MySQL (apt-get install mysql-common, mysql-server on debian linux), with mm.mysql.jdbc-1.2c.

My set up looks good:

setenv JAVA_HOME /usr/java/j2sdk1.4.0 setenv JAKARTA_HOME /usr/java/jakarta setenv ANT_HOME $JAKARTA_HOME/jakarta-ant-1.4.1 setenv TOMCAT_HOME $JAKARTA_HOME/jakarta-tomcat.4.0.3 setenv MM_HOME /usr/java/mysql.jdbc-1.2c

setenv CLASSPATH .:./usr/java/mm.mysql.jdbc-1.2c:/usr/java/j2sdk1.4.0/bin:$CLASSPATH

setenv PATH .:./bin:/usr/local/bin:/usr/X11R6/bin:/usr/java/jakarta/jakarta-tomcat.4.0. 3 /bin:/usr/java/jakarta/jakarta-ant-1.4.1:/usr/java/j2sdk1.4.0/bin:$PATH

Test File

import java.sql.*;

// Do not import org.gjt.mm.mysql.* or you will have problems! public class test { public static void main(String[] Args) { System.out.println("Loading Driver."); try { // The newInstance() call is a work around for some // broken Java implementations

Class.forName("org.gjt.mm.mysql.Driver").newInstance(); } catch (Exception E) { System.err.println("Unable to load driver."); E.printStackTrace(); }

try {

String url="jdbc:mysql://localhost/weblearn?user=root"; //String url="jdbc:mysql://it017731.massey.ac.nz/weblearn"; System.out.println("Connecting to MySQL.");

Connection Conn = DriverManager.getConnection(url, "root", ""); System.out.println("connected!");

Statement Stmt = Conn.createStatement(); ResultSet RS = Stmt.executeQuery("SELECT Title from Quiz");

while (RS.next()) { System.out.println(RS.getString(1)); }

// Clean up after ourselves RS.close(); Stmt.close(); Conn.close(); } catch (SQLException E) { System.out.println("SQLException: " + E.getMessage()); System.out.println("SQLState: " + E.getSQLState()); System.out.println("VendorError: " + E.getErrorCode()); } }

}

Full Error Message Loading Driver. Connecting to MySQL. java.net.ConnectException: Connection refused at java.net.PlainSocketImpl.socketConnect(Native Method) at java.net.PlainSocketImpl.doConnect(PlainSocketImpl.java:295) at java.net.PlainSocketImpl.connectToAddress(PlainSocketImpl.java:161) at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:148) at java.net.Socket.connect(Socket.java:425) at java.net.Socket.connect(Socket.java:375) at java.net.Socket.<init>(Socket.java:290) at java.net.Socket.<init>(Socket.java:118) at org.gjt.mm.mysql.MysqlIO.<init>(MysqlIO.java:114) at org.gjt.mm.mysql.Connection.<init>(Connection.java:229) at org.gjt.mm.mysql.Driver.connect(Driver.java:126) at java.sql.DriverManager.getConnection(DriverManager.java:512) at java.sql.DriverManager.getConnection(DriverManager.java:171) at test.main(test.java:26) SQLException: Cannot connect to MySQL server on localhost:3306. Is there a MySQL server running on the machine/port you are trying to connect to? (java.net.ConnectException) SQLState: 08S01 VendorError: 0

To unsubscribe, send a message to the address shown in the List-Unsubscribe header of this message. If you cannot see it, e-mail java...@lists.mysql.com instead.