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.