Exception when trying to parse JSON from a MySQL query

Question

I'm having a problem parsing the JSON response from MySQL in Java.

try {
    HttpClient httpclient = new DefaultHttpClient();
    HttpPost httppost = new HttpPost("http://parkfinder.zxq.net/default.php");
    httppost.setEntity(new UrlEncodedFormEntity(coordinatesToSend));
    HttpResponse response = httpclient.execute(httppost);
    Log.d("HTTP Client", "HTTP Request made");

    HttpEntity entity = response.getEntity();
    inputStream = entity.getContent();
    BufferedReader bufferedReader = new BufferedReader(new InputStreamReader(inputStream,
            "iso-8859-1"), 8);
    sb = new StringBuilder();
    sb.append(bufferedReader.readLine() + "\n");

    String line = "0";
    while ((line = bufferedReader.readLine()) != null) {
        sb.append(line + "\n");
    }
    inputStream.close();
    bufferedReader.close();
    result = sb.toString();
    Log.d("RESULT", result);
    JSONObject json_data = new JSONObject(result);
    Log.d("JSON","Finished");
    JSONArray nameArray = json_data.names();
    JSONArray valArray = json_data.toJSONArray(nameArray);
    for (int i = 0; i < nameArray.length(); i++) {
        Log.d("NAMES", nameArray.getString(i));
    }
    for (int i = 0; i < nameArray.length(); i++) {
        Log.d("NAMES", nameArray.getString(i));
    }

} catch (Exception e) {
    // TODO: handle exception
}

This is the MySQL Accessing and retreiving info, and parsing it afterwars. the

Log.d("RESULT", result);

line posts the correct results:

2[{"longtitude":"32.32","latitude":"33.12"}]

however the

Log.d("JSON","Finished");

Never gets called, so the problem seems to be on this line

JSONObject json_data = new JSONObject(result);

This while thing is taken from a tutorial which I saw many examples of it over the internet and on this site, some stated errors, but not this one.

Any help would be great! Thanks

EDIT: The printStackTrace() output:

0`5-14 21:38:18.639: WARN/System.err(665): org.json.JSONException: A JSONObject text must begin with '{' at character 1 of 2[{"longtitude":"32.32","latitude":"33.12"}]`

The php code:

<?php
$host = "localhost";
$user = "**MASKED**";
$password = "**MASKED**";
$database = "parkfinder_zxq_coordinates";
$connection = mysql_connect($host, $user, $password) or die("couldn't connect to server");
$db = mysql_select_db($database, $connection) or die("couldn't select database.");
//$request_parked = $_REQUEST['parked'];
$request_long = $_REQUEST['longtitude'];
$request_lat = $_REQUEST['latitude'];
//if ($request_parked == 'FIND') {
$q = mysql_query("SELECT * FROM Coordinates");
while ($e = mysql_fetch_assoc($q))
    $output[] = $e;

print (json_encode($output));
//}

mysql_close();
?>

So most likely the parse is failing, throwing an exception, and your exception handler is blank, so nothing happens... finish off that "TODO" and at least have the catch block spit out the exception error text. — Marc B
– Marc B, Commented May 23, 2012 at 14:07

wattostudios · Accepted Answer · 2012-05-23 14:27:37Z

2

Your JSON data 2[{"longtitude":"32.32","latitude":"33.12"}] isn't valid (the number 2 isn't proper JSON syntax).

Can I suggest you actually mean

[{"longtitude":"32.32","latitude":"33.12"}]`

(ie. without the 2 at the beginning)

You can use the validator at http://jsonlint.com/ to check your JSON code.

edited May 23, 2012 at 14:27

answered May 23, 2012 at 14:13

wattostudios

8,79013 gold badges45 silver badges58 bronze badges

Sign up to request clarification or add additional context in comments.

7 Comments

La bla bla Over a year ago

I added the PHP code, I havn't done any modification to the output one obtained from the mysql

wattostudios Over a year ago

Well the 2 is where your exception trace is saying the JSON code is invalid, and it definitely doesn't parse at jsonlint.com . Where is the 2 coming from - is it returned from your MySQL or is it something from your HTML connection? I will suggest maybe MySQL is correct but your HTML reading code is adding the 2 for some reason?

La bla bla Over a year ago

what i pasted, is the entire php file. it doesn't any have html interface, it only use for interaction with the device. any idea what's wrong with the php?

wattostudios Over a year ago

I don't think there's anything wrong with your PHP, I think its something wrong with your Java code.

wattostudios Over a year ago

Instead of using BufferedReader to read the HttpEntity content, why don't you try getting rid of all your manual reading code and just use String result = EntityUtils.toString(entity); - it does all the hard work of reading the content for you. It might help to remove a potential source of error. Refer to hc.apache.org/httpcomponents-core-ga/httpcore/apidocs/org/… for details of this class.

|

Collectives™ on Stack Overflow

Exception when trying to parse JSON from a MySQL query

1 Answer 1

7 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

7 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related