LinuxQuestions.org - gentoo +jdbc errors with sun examples?

hello all im trying to get this bloomin jdbc example from the sun website working but all i get is a load of errors, do you know what could be causing this and how to solve it? please also i am on a very tight schedule cheers.

the sun example:

Code:

package JDBC.IncertionClass;



import java.sql.*;

import java.io.*;





public class IncertionClass {



        public static void main(String[] args)  throws ClassNotFoundException,

                                                      IOException {

        try {

        /** 

        *  Load jdbc driver for MySQL 

        */

          Class.forName( "com.mysql.jdbc.Driver");

            

      //  Loads database name of a mysql database into url

      //localhost says that it is on the current machine and test says that the 

      //  name of the database is test. 

      

            String url = "jdbc:mysql://localhost/test";

      

      //  We have to establish a jdbc connection to the database



            Connection connection = DriverManager.getConnection(url);

        

            /* The insert statement will insert the record into the defined

            * table.

            */  

            int sid=126;

            String nameStudent ="Tom";

            String courseName ="cs 223";

            String letterGrade="D";

            String qs = "insert into students values ("+sid+","+"'"+nameStudent

                                +"','"+courseName+"','"+letterGrade+"')";

        

            Statement stmt = connection.createStatement();

            stmt.executeUpdate(qs);

            System.out.println("Insertion is complete");



            stmt.close();

            connection.close();

                

        } catch (SQLException sqle){ 

                        sqle.printStackTrace();

                        

                        while (sqle != null) {

                                String logMessage = "\n SQL Error: "+

                                  sqle.getMessage() + "\n\t\t"+

                                  "Error code: "+sqle.getErrorCode() + 

                                              "\n\t\t"+

                                  "SQLState: "+sqle.getSQLState()+"\n";

                        System.out.println(logMessage);

                        sqle = sqle.getNextException();

                        }

                }  

        }

}

my error:

Code:

 SQL Error: Communications link failure due to underlying exception: 



** BEGIN NESTED EXCEPTION ** 



java.net.SocketException

MESSAGE: java.net.ConnectException: Connection refused



STACKTRACE:



java.net.SocketException: java.net.ConnectException: Connection refused

        at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)

        at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:283)

        at com.mysql.jdbc.Connection.createNewIO(Connection.java:2541)

        at com.mysql.jdbc.Connection.<init>(Connection.java:1474)

        at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:264)

        at java.sql.DriverManager.getConnection(DriverManager.java:512)

        at java.sql.DriverManager.getConnection(DriverManager.java:193)

        at JDBC.IncertionClass.IncertionClass.main(IncertionClass.java:25)





** END NESTED EXCEPTION **







Last packet sent to the server was 25 ms ago.

                Error code: 0

                SQLState: 08S01

ive tried runnign as root also no success.