Anh le and all, There's no need to just repeat what has already been answered. In fact, this same question was answered by two other people including myself. Unless of course your contribution is adding something entirely different.
Again, if you feel the need to help out, you can always go through other unanswered mails and try attempting them. Good luck -- Evans http://twitter.com/javawug ----- Original Message ----- From: anh le To: java-ee-j2ee-programming-with-passion@googlegroups.com Sent: Monday, April 13, 2009 2:44 AM Subject: [java ee programming] Re: Remotely access of MYSQL server Hi Yu try to see the your connection. "Connection refused" is connection failed. You can check it as command "ping 192.168.0.100" or "telnet 192.168.0.100 3306". 2009/4/11 <star...@yahoo.com> Hi Dear Sang and All members I have problem to connect MySQL server from another client computer through an IP address of server computer. Example of JDBC is given below . it execute only mysql server with localhost ************************************************************************************* import java.sql.Connection; import java.sql.DriverManager; import java.sql.SQLException; import java.sql.Statement; import java.sql.ResultSet; public class insertmysql { public static void main(String[] args) { Statement stmt = null; ResultSet rs = null; String sqlstmt1; String cname="HONDA"; String cmodel="CIVIC"; String ccolor="BLACK"; String ctype="LUXRY"; String cweight="200KG"; try { Class.forName("com.mysql.jdbc.Driver").newInstance(); //Connection conn = DriverManager.getConnection("jdbc:mysql:// localhost/payroll?user=root&password=12345678"); Connection conn = DriverManager.getConnection("jdbc:mysql:// 192.168.0.100/payroll?user=root&password=12345678"); stmt = conn.createStatement(); sqlstmt1 = "INSERT INTO testing (fname, lname) VALUES ('"+cname +"','"+cmodel+"')"; stmt.executeUpdate(sqlstmt1); } catch (SQLException ex) { // handle any errors System.out.println("SQLException: " + ex.getMessage()); System.out.println("SQLState: " + ex.getSQLState()); System.out.println("VendorError: " + ex.getErrorCode()); } catch (Exception ex) { System.out.println("An error has occured"); } finally { // it is a good idea to release resources in a finally{} block in reverse-order of their creation if they are no-longer needed if (rs != null) { try{ rs.close(); } catch (SQLException sqlEx) { }//ignore rs = null; } if (stmt != null) { try{ stmt.close(); } catch (SQLException sqlEx) { }//ignore stmt = null; } }//finally }//main } ************************************************************************************* When I execute this file I received the error which is given below ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ SQLException: Communications link failure due to underlying exception: ** BEGIN NESTED EXCEPTION ** java.net.SocketException MESSAGE: java.net.ConnectException: Connection refused: connect STACKTRACE: java.net.SocketException: java.net.ConnectException: Connection refused: connect at com.mysql.jdbc.StandardSocketFactory.connect (StandardSocketFactory.java:156) at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:276) at com.mysql.jdbc.Connection.createNewIO(Connection.java:2641) at com.mysql.jdbc.Connection.<init>(Connection.java:1531) at com.mysql.jdbc.NonRegisteringDriver.connect (NonRegisteringDriver.java:266) at java.sql.DriverManager.getConnection(DriverManager.java: 525) at java.sql.DriverManager.getConnection(DriverManager.java: 193) at insertmysql.main(insertmysql.java:30) ** END NESTED EXCEPTION ** Last packet sent to the server was 16 ms ago. SQLState: 08S01 VendorError: 0 ^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^^ I am using O/S: Windows 2000 Advanced server IP(inwhich MySQL server installed) 192.168.0.100 MySQL version MySQL 5.0.18-nt-log via TCP/IP MySQL connector mysql- connector-java-5.0.3-bin.jar connector path C: \Program Files\Java\jdk1.5.0_07\jre\lib\ext Please help me to resolve this issue. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Java EE (J2EE) Programming with Passion!" group. To post to this group, send email to java-ee-j2ee-programming-with-passion@googlegroups.com To unsubscribe from this group, send email to java-ee-j2ee-programming-with-passion+unsubscr...@googlegroups.com For more options, visit this group at http://groups.google.com/group/java-ee-j2ee-programming-with-passion?hl=en -~----------~----~----~----~------~----~------~--~---
