• After 15+ years, we've made a big change: Android Forums is now Early Bird Club. Learn more here.

Apps jdbc connection worked localhost but Not worked DEV site

krishnaveni

Well-Known Member
am successfully finished login form in android using mysql connection via jdbc in java...its successfully worked in my localhost...but development site its not worked...the following error is displyed.
Code:
java.sql.SQLException: Unable to connect to any hosts due to exception: java.net.SocketException: java.net.ConnectException: Connection timed out: connect

** BEGIN NESTED EXCEPTION ** 

java.net.SocketException
MESSAGE: java.net.ConnectException: Connection timed out: connect

STACKTRACE:

java.net.SocketException: java.net.ConnectException: Connection timed out: connect
    at com.mysql.jdbc.StandardSocketFactory.connect(StandardSocketFactory.java:143)
    at com.mysql.jdbc.MysqlIO.<init>(MysqlIO.java:225)
    at com.mysql.jdbc.Connection.createNewIO(Connection.java:1805)
    at com.mysql.jdbc.Connection.<init>(Connection.java:452)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.retrieve.retrieve.main(retrieve.java:15)


** END NESTED EXCEPTION **


    at com.mysql.jdbc.Connection.createNewIO(Connection.java:1875)
    at com.mysql.jdbc.Connection.<init>(Connection.java:452)
    at com.mysql.jdbc.NonRegisteringDriver.connect(NonRegisteringDriver.java:411)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at java.sql.DriverManager.getConnection(Unknown Source)
    at com.retrieve.retrieve.main(retrieve.java:15)
why dis error is occurred.give me some solutions. if am running localhost means my sql query is
Code:
String user = name.getText();
          String strpass = pass.getText();
          try {
            Class.forName("com.mysql.jdbc.Driver");
          } catch (ClassNotFoundException ex) {
              Logger.getLogger(jdbclogin.class.getName()).log(Level.SEVERE, null, ex);
          }
          try {
              Connection con = DriverManager.getConnection("jdbc:mysql://localhost:3306/login", "root", "");
              Statement st = con.createStatement();
              String query = "SELECT password FROM customers where login='"+user+"'";
              System.out.println(query);
              ResultSet rs = st.executeQuery(query);
if am running development site means my query is:
Code:
String user = name.getText();
          String strpass = pass.getText();
          try {
             Class.forName("com.mysql.jdbc.Driver");
          } catch (ClassNotFoundException ex) {
              Logger.getLogger(jdbclogin.class.getName()).log(Level.SEVERE, null, ex);
          }
          try {
              Connection con = DriverManager.getConnection("jdbc:mysql://dev.sasas.com:3306/login", "asas", "sass");
              Statement st = con.createStatement();
              String query = "SELECT password FROM xcart_customers where login='"+user+"'";
              System.out.println(query);
              ResultSet rs = st.executeQuery(query);
dis development site username,password,database name and url all r correct only...then why dis error is occured....give me solutions...
 
Back
Top Bottom