I'm trying to connect to a mysql database through localhost, and i'm getting a strange problem. The server is running just fine, because it's accessable through php and command line, but when i try to use this code:

import java.sql.DriverManager; import java.sql.Connection; import java.sql.SQLException;

public class TestDatabase {

public static void main( String[] args ) { try { Connection conn = null; Class.forName( "org.gjt.mm.mysql.Driver" ).newInstance(); System.out.println ( "Instance created" ); conn = DriverManager.getConnection( "jdbc:mysql://localhost/database", "username", "password" ); System.out.println ( "Connection created" ); conn.close(); System.out.println ( "Connection closed" ); } catch ( SQLException e ) { System.err.println ( "SQL Error #: " + e.getMessage() ); System.err.println ( e.getMessage() ); } catch ( ClassNotFoundException e ) { System.err.println ( "Class Not Found" ); System.err.println ( e.getMessage() ); } catch ( InstantiationException e ) { System.err.println ( "Instantiation Error" ); System.err.println ( e.getMessage() ); } catch ( IllegalAccessException e ) { System.err.println ( "Illegal Access" ); System.err.println ( e.getClass() ); }

System.out.println ( "Exiting" ); System.exit( 0 ); }

} // TestDatabase

All that happens is "Instance created" is printed to std out, and then the program locks up. It never even gets past the DriverManager.getConnection() line. I tried letting it time out incase the connection wasn't working but after a few minutes it was still stuck in that line. I don't even know where to begin to debug this, so I'm hoping someone on the list might know where to at least start?

On a side note, I'm running Debian Linux, and Blackdown Java 1.3.1, with 2.0.14 mm.mysql

Thanks in advance

-Tristan

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.