SQLite SELECT gives exception How to fix it?

Question

I am developing an android application (using Eclipse and 5554 emulator). When I execute the following code it seems CREATE TABLE and INSERT is working correctly but SELECT has some problem. Do you think the problem is coming from CREATE TABLE and INSERT? or Is syntax of SELECT not right? ``` public void onCreateA(SQLiteDatabase db) { System.out.println("On create works"); try { db.execSQL("DROP TABLE IF EXISTS actuator;"); db.execSQL("CREATE TABLE IF NOT EXISTS actuator ("+ "ACTUATOR_ID INT(11) NOT NULL,"+ "ACTUATOR_HW_ID int(11) DEFAULT NULL,"+ "DEVICE_NAME TEXT(45) DEFAULT NULL,"+ "DEVICE_TYPE TEXT(45) DEFAULT NULL,"+ "DEVICE_SUB_TYPE TEXT(45) DEFAULT NULL,"+ "LOCATION_ID INT(11) DEFAULT NULL,"+ "STATUES_VALUE REAL DEFAULT NULL,"+ "MAX_STATUES_VALUE REAL DEFAULT NULL,"+ "MIN_STATUES_VALUE REAL DEFAULT NULL,"+ "PRIMARY KEY (`ACTUATOR_ID`))"); System.out.println("table created now values will be added"); System.out.print("DONE!"); } catch (SQLException e) { System.out.println("table…

Accepted Answer

```
db.execSQL("SELECT * FROM actuator");
```

You can't use `execSQL` method for statements which return data. Exactly from docs

Execute a single SQL statement that is NOT a SELECT or any other SQL statement that returns data.

You have to use rawQuery() or query() method.

So for your case, you can use following snippet of code for getting data from database:

```
String query = "SELECT * FROM actuator";
Cursor c = db.rawQuery(query, null);
if (c != null && c.moveToFirst()) {
   // do your stuff
}
```

Actually, your code do nothing. If you want to retrieve data from db, you need to assign them to Cursor via methods mentioned above.

SQLite SELECT gives exception How to fix it?

Solution

Problem