Advertisement
Guest User

Untitled

a guest
Jul 1st, 2017
82
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 3.05 KB | None | 0 0
  1. import java.sql.*;
  2.  
  3. public class JdbcOverInternet {
  4.  
  5. public static void main(String[] args) throws Exception {
  6. Class.forName("com.mysql.jdbc.Driver");
  7.  
  8. Connection con = DriverManager.getConnection("jdbc:mysql://110.32.144.14:3306/mydb", "mysql", "mysql");
  9. Statement st = con.createStatement();
  10. ResultSet rs = st.executeQuery("select * from USER");
  11. while(rs.next()) {
  12. System.out.println(rs.getString(1));
  13. }
  14. rs.close();
  15. st.close();
  16. con.close();
  17.  
  18. }
  19. }
  20.  
  21. Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  22. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  23. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  24. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  25. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  26. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  27. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  28. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
  29. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
  30. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2192)
  31. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225)
  32. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
  33. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
  34. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
  35. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  36. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  37. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  38. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  39. at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
  40. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
  41. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
  42. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  43. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  44. at JdbcOverInternet.main(JdbcOverInternet.java:8)
  45. Caused by: java.net.ConnectException: Connection refused (Connection refused)
  46. at java.net.PlainSocketImpl.socketConnect(Native Method)
  47. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  48. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  49. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  50. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  51. at java.net.Socket.connect(Socket.java:589)
  52. at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
  53. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement