Advertisement
Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- import java.sql.*;
- public class JdbcOverInternet {
- public static void main(String[] args) throws Exception {
- Class.forName("com.mysql.jdbc.Driver");
- Connection con = DriverManager.getConnection("jdbc:mysql://110.32.144.14:3306/mydb", "mysql", "mysql");
- Statement st = con.createStatement();
- ResultSet rs = st.executeQuery("select * from USER");
- while(rs.next()) {
- System.out.println(rs.getString(1));
- }
- rs.close();
- st.close();
- con.close();
- }
- }
- Exception in thread "main" com.mysql.jdbc.exceptions.jdbc4.CommunicationsException: Communications link failure
- The last packet sent successfully to the server was 0 milliseconds ago. The driver has not received any packets from the server.
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
- at com.mysql.jdbc.SQLError.createCommunicationsException(SQLError.java:989)
- at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:341)
- at com.mysql.jdbc.ConnectionImpl.coreConnect(ConnectionImpl.java:2192)
- at com.mysql.jdbc.ConnectionImpl.connectOneTryOnly(ConnectionImpl.java:2225)
- at com.mysql.jdbc.ConnectionImpl.createNewIO(ConnectionImpl.java:2024)
- at com.mysql.jdbc.ConnectionImpl.<init>(ConnectionImpl.java:779)
- at com.mysql.jdbc.JDBC4Connection.<init>(JDBC4Connection.java:47)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance0(Native Method)
- at sun.reflect.NativeConstructorAccessorImpl.newInstance(NativeConstructorAccessorImpl.java:62)
- at sun.reflect.DelegatingConstructorAccessorImpl.newInstance(DelegatingConstructorAccessorImpl.java:45)
- at java.lang.reflect.Constructor.newInstance(Constructor.java:423)
- at com.mysql.jdbc.Util.handleNewInstance(Util.java:425)
- at com.mysql.jdbc.ConnectionImpl.getInstance(ConnectionImpl.java:389)
- at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:330)
- at java.sql.DriverManager.getConnection(DriverManager.java:664)
- at java.sql.DriverManager.getConnection(DriverManager.java:247)
- at JdbcOverInternet.main(JdbcOverInternet.java:8)
- Caused by: java.net.ConnectException: Connection refused (Connection refused)
- at java.net.PlainSocketImpl.socketConnect(Native Method)
- at java.net.AbstractPlainSocketImpl.doConnect(AbstractPlainSocketImpl.java:350)
- at java.net.AbstractPlainSocketImpl.connectToAddress(AbstractPlainSocketImpl.java:206)
- at java.net.AbstractPlainSocketImpl.connect(AbstractPlainSocketImpl.java:188)
- at java.net.SocksSocketImpl.connect(SocksSocketImpl.java:392)
- at java.net.Socket.connect(Socket.java:589)
- at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:211)
- at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:300)
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement