Thread: connection to a database on another computer(server)

i have been trying to establish a connection to a mysql database on another computing having the same java application running.
I keep getting a connection timeout error from java.net. I seem not to be getting anywhere, someone please help me!

Welcome to Java Programming Forums. Don't forget to read the rules.
What have you tried yet? Where actually the problem exists? Post your code here so that we could have a look over this.

I have setup a peer to peer network and tried establishing a connection to the database with the IP address of the computer with the database.

try{
Class.forName(DRIVER);
connection = DriverManager.getConnection("jdbc:mysql://localhost/db_name",root,password);

}catch(Exception ex){
JOptionPane.showMessageDialog(null, ex.getMessage(),"Unable to connect",JOptionPane.ERROR_MESSAGE);
}

this code for the client

try{
Class.forName(DRIVER);
connection = DriverManager.getConnection("jdbc:mysql://169.254.214.132",client_name,password);

}catch(Exception ex){
JOptionPane.showMessageDialog(null, ex.getMessage(),"Unable to connect",JOptionPane.ERROR_MESSAGE);
}

Class.forName(DRIVER);

What's DRIVER? Do you really think, compiler will let you pass from this statement?

connection = DriverManager.getConnection("jdbc:mysql://localhost/db_name",root,password);

I will recommend you to provide IP instead of localhost, though it's not compulsory.
And i would like to know one more thing, which server are you running?

i'm running wampserver 2.1 and the driver i'm using is "com.mysql.jdbc.Driver". And please i need your help so i would appreciate it if you stop being cold

Class.forName(DRIVER);

Pass Class.forName the actual driver, not the word driver. Is DRIVER a string? If no, then paste your driver in here and see if it can load the driver. If it gets driver loaded, try creating the connection.

DRIVER is a string. And i've tried the connection several times and it works perfectly on the host computer the problem is with using the application on another computer and connecting the database from that particular computer to the host computer. I have tried using an IP address as you suggested and i also used the port 3306. i.e 127.0.0.1:3306 on the host machine and 169.254.236.132:3306 on the computer connecting to the database. the error i keep from computer connecting remotely is java.net.ConnectException, Connection timed out:connect.

The reason is your machine can not communicate with the machine you are actually trying to. This machine do exists else there would be an error saying "Can not find host machine" or whatever like this.. So, i will recommend you to see the firewall settings, if firewall is not blocking the way or you can give a try to communicate to another port. If both of these things didn't work, let me know, how far it takes before spitting this error out. Also, in command prompt, try ping machineIP and see if it's sending and receiving data.

the port is not blocked and it takes about 20 seconds to report the error when i run it from the netbeans IDE but does not take too long to report when i run the executable jar file.

If you are using web server ,try accessing with your computer name instead of localhost or ip . If you are using only app server then start you server using your IP (IP which your trying to connect) .Normally If server is starting in localhost ,You will not be able to use IP to connect and If you start with IP then you will not be able to use Local host .

What happened when you tried the ping Mr.777 suggested? Are both these computers on your desk? The IP address you posted is a 'Link Local' IP address:

Link-local address - Wikipedia, the free encyclopedia

- so it's not routable.

the firewall had blocked the port MySQL uses in communicating (Port 3306) by default. so i had to allow through the firewall and my problem is solved now. thank you