[kmangala77]

Hi,
I am a grad student and having problem with connecting to database Mysql in our University's server. I have used the following code to connect. When I run this application I am getting communication failed error.Any help will be greatly appreciated.

 
import java.sql.*;
import java.sql.DriverManager;
import java.sql.SQLException;
import java.net.*;

public class test {

	static public final String driver = "com.mysql.jdbc.Driver";
	static public final String connection =
		"jdbc:mysql://cs.metrostate.edu:3306/test" + "?autoReconnect=true" +
		"?user=ics625s916&password=4442&database=test";

	public static void main(String args[]) {

		try {
			Class.forName(driver).newInstance();
			Connection con = DriverManager.getConnection(connection);
			
			System.out.println("Jdbc Mysql Connection Url :");
			System.out.println(connection);

			if (!con.isClosed()) {
				con.close();
			}

		} catch (Exception e) {
			e.printStackTrace();
		}
	}
}

[Hary]

The URI is correct, so I guesst uni is blocking traffic from outside the building to the database server. Ay my university, I have to use a VPN connection to access those machines.