cannot connect to my MySQL db using HttpClient

[Dov Ezra]

Hello all,

I'm new to android and I'm trying to write a code that access a MySQL database.

I tried to follow the tutorial from HelloAndroid.com

I have a wamp server on my windows machine, and a MySQL database on it. and here is my code:

Code: Select all
    HttpClient client = new DefaultHttpClient();
                HttpPost httppost = new HttpPost("http://10.0.2.2/myscript.php");
                HttpResponse response = client.execute(httppost);
                HttpEntity entity = response.getEntity();

but all I get is the error "java.net.SocketException.permission denide".
I tried to change he post's url to "http://www.google.com" I get a java.net.UnknowenHostException
http://www.google.com.

I tried to access my php script using the android web browser, using the address http://10.0.2.2/myscript.php.
I get to the page and it run perfectly. so there is no firewall or server problems. I think.
It is something with my application. any hits, please?

[Misha van Tol]

Did you give the app internet permission?

<uses-permission android:name="android.permission.INTERNET"></uses-permission>

[Dov Ezra]

Yes, I put that line in the manifest.xml file.

but maybe not in the right position?

<?xml version="1.0" encoding="UTF-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
     package="org.me.hello">
    
    <application>    
         <activity android:name=".ConnectActivity" android:label="ConnectActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN"/>
                <category android:name="android.intent.category.LAUNCHER"/>
                <uses-permission android:name="android.permission.INTERNET"></uses-permission>
            </intent-filter>
        </activity>
    </application>

I get the same permission denide error, no matter if I use HttpPost or HttpGet. is that mean anything to you?

[Misha van Tol]

It should go in the <manifest> tag.

<manifest ...>
 ...
<uses-permission android:name="android.permission.INTERNET"></uses-permission>
</manifest> 

HttpPost or HttpGet should make no difference. (for the error)

[Dov Ezra]

Nope, didn't help.

the manifest file looks like this:

<?xml version="1.0" encoding="UTF-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
     package="org.me.hello">
    <uses-permission android:name="android.permission.INTERNET"></uses-permission>
    <application>    
    ...
   </application>    
</manifest>

I tried to run this code on eclipse and netbeans. the same error happends.

[Misha van Tol]

Can you post the entire code (if it's not to much) and the complete error message?

[Dov Ezra]

Ok, here goes.
Thank you so much for your time.

//Class ConnectActivity. the main class

package org.me.hello;

import android.app.Activity;
import android.os.Bundle;

public class ConnectActivity extends Activity {

    public void onCreate(Bundle icicle) {
        super.onCreate(icicle);

        setContentView(R.layout.main);
        Connect c = new Connect();
        c.quaryDB(this);
    }//onCreate
}//class

//Class connect. handle connection to database.
package org.me.hello;

import android.content.Context;
import android.widget.Toast;
import java.sql.*;
import org.apache.http.HttpEntity;
import org.apache.http.HttpResponse;
import org.apache.http.client.HttpClient;
import org.apache.http.client.methods.HttpGet;
import org.apache.http.client.methods.HttpPost;
import org.apache.http.impl.client.DefaultHttpClient;

public class Connect {
   

    Connect(){
    //stub ctor
    }

    public void quaryDB(Context context){

        Connection conn = null;
        try{
            HttpClient client = new DefaultHttpClient();
            HttpPost httppost = new HttpPost("http://10.0.2.2/family/connect.php");
            HttpResponse response = client.execute(httppost);
            HttpEntity entity = response.getEntity();

        }//try
        catch (Exception e){
            String errMsg ="Cannot connect to database server.\n"+e.toString();
            Toast.makeText(context, errMsg, Toast.LENGTH_LONG).show();
        }//catch
        finally{
            if (conn != null){
                try{
                    conn.close ();
                }
                catch (Exception e) { /* ignore close errors */ }
            }//if
        }//finally
    }//queryDB
}//class

//and here is the manifest file

<?xml version="1.0" encoding="UTF-8"?>
<manifest xmlns:android="http://schemas.android.com/apk/res/android"
     package="org.me.hello">
    <uses-permission android:name="android.permission.INTERNET"></uses-permission>
    <application>    
         <activity android:name=".ConnectActivity" android:label="ConnectActivity">
            <intent-filter>
                <action android:name="android.intent.action.MAIN"/>
                <category android:name="android.intent.category.LAUNCHER"/>
            </intent-filter>
        </activity>
    </application>
</manifest>

and that's all.

maybe its somthing with the emulator's network settings?

[Misha van Tol]

Code looks good, it's working fine over here. When I run it I get the toast message, but that's not strange since it can't connect to that IP on my system. But when I change it to www.google.com it works fine. Can you post the error message including the stacktrace so I can see the line where the error occurs?

[Dov Ezra]

I found a solution!

I defined new AVD and used it to run the program. and it works!

This AVD used android 8 with no google APi, while the old one was android 8 with the api.
Is it possible that the API was the problem?
I hope it was someting wromg with the project or AVD configuration. why should the API be a problem?

Thanks, again!

[Misha van Tol]

Weird, maybe just restarting the AVD was enough. Google or Android API should make no difference for this piece of code. I've tried it here also on a AVD with google api 8 and it worked just the same.