Advertisement
Guest User

Untitled

a guest
Jun 18th, 2016
139
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 5.21 KB | None | 0 0
  1. import java.sql.DriverManager;
  2. import java.sql.ResultSet;
  3. import java.sql.SQLException;
  4.  
  5. public class Connect2 {
  6. // JDBC URL, username and password of MySQL server
  7. private static final String url = "jdbc:mysql://50.23.230.134:3307/dfa9c073ea5c544bdb3c0cd87754ee1ff";
  8. private static final String user = "login";
  9. private static final String password = "pZGi1B4Q9ITF4";
  10.  
  11. // JDBC variables for opening and managing connection
  12. private static java.sql.Connection con;
  13. private static java.sql.Statement stmt;
  14. private static ResultSet rs;
  15.  
  16. public static void main(String args[]) {
  17. String query = "select count(*) from users";
  18.  
  19. try {
  20. // opening database connection to MySQL server
  21. Class.forName("com.mysql.jdbc.Driver").newInstance();
  22. System.out.println("Driver on");
  23. con = DriverManager.getConnection(url,user,password);
  24. // getting Statement object to execute query
  25. System.out.println("Connect");
  26. stmt = con.createStatement();
  27.  
  28. // executing SELECT query
  29. rs = stmt.executeQuery(query);
  30.  
  31. int count = rs.getInt(1);
  32. System.out.println(count);
  33.  
  34. } catch (SQLException sqlEx) {
  35. sqlEx.printStackTrace();
  36. } catch (IllegalAccessException e) {
  37. e.printStackTrace();
  38. } catch (InstantiationException e) {
  39. e.printStackTrace();
  40. } catch (ClassNotFoundException e) {
  41. e.printStackTrace();
  42. } finally {
  43. //close connection ,stmt and resultset here
  44. try { con.close(); } catch(SQLException se) { /*can't do anything */ }
  45. try { stmt.close(); } catch(SQLException se) { /*can't do anything */ }
  46. try { rs.close(); } catch(SQLException se) { /*can't do anything */ }
  47. }
  48. }
  49. }
  50.  
  51. Driver on
  52. com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
  53.  
  54. The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
  55. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  56. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  57. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  58. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  59. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  60. at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:988)
  61. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
  62. at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2251)
  63. at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2284)
  64. at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2083)
  65. at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:806)
  66. at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
  67. at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
  68. at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
  69. at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
  70. at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
  71. at com.mysql.jdbc.Util.handleNewInstance(Util.java:404)
  72. at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:410)
  73. at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:328)
  74. at java.sql.DriverManager.getConnection(DriverManager.java:664)
  75. at java.sql.DriverManager.getConnection(DriverManager.java:247)
  76. at Connect2.main(Connect2.java:32)
  77. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  78. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  79. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  80. at java.lang.reflect.Method.invoke(Method.java:498)
  81. at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
  82. Caused by: java.net.ConnectException: Connection timed out: connect
  83. at java.net.DualStackPlainSocketImpl.connect0(Native Method)
  84. at java.net.DualStackPlainSocketImpl.socketConnect(DualStackPlainSocketImpl.java:79)
  85. at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
  86. at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
  87. at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
  88. at java.net.PlainSocketImpl.connect(PlainSocketImpl.java:172)
  89. at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
  90. at java.net.Socket.connect(Socket.java:589)
  91. at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
  92. at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
  93. ... 20 more
  94. Exception in thread "main" java.lang.NullPointerException
  95. at Connect2.main(Connect2.java:55)
  96. at sun.reflect.NativeMethodAccessorImpl.invoke0(Native Method)
  97. at sun.reflect.NativeMethodAccessorImpl.invoke(NativeMethodAccessorImpl.java:62)
  98. at sun.reflect.DelegatingMethodAccessorImpl.invoke(DelegatingMethodAccessorImpl.java:43)
  99. at java.lang.reflect.Method.invoke(Method.java:498)
  100. at com.intellij.rt.execution.application.AppMain.main(AppMain.java:144)
  101.  
  102. Process finished with exit code 1
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement