Connection problem
I need to connect to a database but I get an error, can someone please tell me whats going wrong.
Here is my connection code:
Connection conn =null;
try
{
//load driver
Class.forName("com.mysql.jdbc.Driver");
// Create a connection to the database
String serverName ="cosmos.ucc.ie";
String myDatabase ="TwoLarge";
String url ="jdbc:mysql://" + serverName +"/" + myDatabase;//a JDBC url
String username ="dt1";
String password ="password";
conn = DriverManager.getConnection(url, username, password);
}
catch (ClassNotFoundException cnfe)
{
System.out.println("Could not find the database driver");
cnfe.printStackTrace();
}
catch (SQLException sqle)
{
System.out.println("Could not connect to the database");
sqle.printStackTrace();
}
And here is the stack trace from the error:
Could not connect to the database
com.mysql.jdbc.CommunicationsException: Communications link failure due to underlying exception:
** BEGIN NESTED EXCEPTION **
java.net.SocketException
MESSAGE: java.net.SocketException: SOCKS: Connection not allowed by ruleset
STACKTRACE:
java.net.SocketException: java.net.SocketException: SOCKS: Connection not allowed by ruleset
at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:156)
at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:284)
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2565)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at TwoLargeManager.loginUser(TwoLargeManager.java:178)
at ConnectionManager.processMessage(ConnectionManager.java:114)
at ConnectionManager.run(ConnectionManager.java:78)
** END NESTED EXCEPTION **
Last packet sent to the server was 12 ms ago.
at com.mysql.jdbc.Connection.createNewIO(Connection.java:2631)
at com.mysql.jdbc.Connection.<init>(Connection.java:1485)
at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:266)
at java.sql.DriverManager.getConnection(DriverManager.java:525)
at java.sql.DriverManager.getConnection(DriverManager.java:171)
at TwoLargeManager.loginUser(TwoLargeManager.java:178)
at ConnectionManager.processMessage(ConnectionManager.java:114)
at ConnectionManager.run(ConnectionManager.java:78)
