Android sqlite insert is not inserting

Question

i have this little gps locaton inserting code but thats not insert into the database: ``` db.setVersion(1); db.setLocale(Locale.getDefault()); db.setLockingEnabled(true); final String gps = "CREATE TABLE IF NOT EXISTS GPS_Values (" + "id INTEGER PRIMARY KEY AUTOINCREMENT, Latitude float(10, 6), Longitude float(10, 6), cur_timestamp TIMESTAMP);"; db.execSQL(gps); ``` and the inserting lines: ``` // GPS public class MyLocationListener implements LocationListener { public void onLocationChanged(Location loc) { loc.getLatitude(); loc.getLongitude(); ContentValues gps_values = new ContentValues(); gps_values.put("Latitude", loc.getLatitude()); gps_values.put("Longitutde", loc.getLongitude()); try { db.beginTransaction(); db.insert("GPS_Values", null, gps_values); db.setTransactionSuccessful(); } finally { db.endTransaction(); } String Text = "My current location is: " + "Latitude = " + loc.getLatitude() + "
Longitude = " + loc.getLongitude(); Toast.makeText(getApplicationContext(), Text,…

Accepted Answer

There a typo in the column you're inserting to:

```
    gps_values.put("Longitutde", loc.getLongitude());
```

Should be

```
    gps_values.put("Longitude", loc.getLongitude());
```

The `insert()` call returns -1 if an error occurred, but you aren't checking the return value. It's generally easier to use `insertOrThrow` instead, which throws an exception on error.

Android sqlite insert is not inserting

Solution

Problem