Unable to retrieve data from table in apps

Question

0.00/5 (No votes)

See more:

In my android apps project after inserting rows I intend to get all data for display.
I use cursor for this. What happens is that on click of the button I get an error in the device stating that 'apps has stopped'. There is no error in the code.
The following is the code:

Java

public String getAllData() {
      SQLiteDatabase db = helper.getWritableDatabase();
        String[] columns = {helper.COLUMN_ID, helper.COLUMN_NAME};
        Cursor cursor = db.query(helper.TABLE_ACCOUNTHEADS, columns, null, null, null, null, null);
        StringBuffer buffer = new StringBuffer();

        while(cursor.moveToNext())
        {
            int cid = cursor.getInt(0);
            String accountname = cursor.getString(1);
            buffer.append(cid + " " + accountname + "\n");

        }
        return buffer.toString();

Posted 9-Mar-15 18:26pm

S.Rajendran from Coimbatore

Updated 9-Mar-15 18:45pm

Wendelius

v2

Add a Solution

Comments

Xiao Ling 10-Mar-15 2:31am

Could you please post your crash log?

S.Rajendran from Coimbatore 10-Mar-15 2:34am

is that event log?

Xiao Ling 10-Mar-15 2:40am

Check DDMS, and dump error info. For example, NullPointerException.

S.Rajendran from Coimbatore 10-Mar-15 2:48am

After running the app the event log:
12:17:31 PM Gradle build finished in 8 sec
12:17:31 PM Session 'app1': running

S.Rajendran from Coimbatore 10-Mar-15 2:49am

in ddms how to find dump error

Xiao Ling 10-Mar-15 3:07am

Do you know where LogCat is? In LogCat, click the button "verbose", and select "error". Then you will see all errors, which could be copied to your clipboard.

S.Rajendran from Coimbatore 10-Mar-15 3:38am

i did like this. In ddms in loglevel I selected 'error'. Some message like 'applying filter' is appearing at the bottom and disappears immediately.

S.Rajendran from Coimbatore 10-Mar-15 4:18am

In another new apps test project I get the same problem if use the line ' SQLiteDatabase db=vivzHelper.getWritableDatabase();' in MainActivity.java that runs with VivzHelper.java (where DB is created). If I dont use that line I dont get that error.

public class MainActivity extends ActionBarActivity {
VivzHelper vivzHelper;

@Override
protected void onCreate(Bundle savedInstanceState) {
super.onCreate(savedInstanceState);
setContentView(R.layout.activity_main);
vivzHelper=new VivzHelper(this);
SQLiteDatabase db=vivzHelper.getWritableDatabase();
}

public class VivzHelper extends SQLiteOpenHelper{

private static final String DATABASE_NAME="vivzdatabase";
private static final String TABLE_NAME="VIVZTABLE";
private static final String DATABASE_VERSION="1";
private static final String UID="_id";
private static final String NAME="name";
private static final String PASSWORD="password";
private static final String CREATE_TABLE="CREATE TABLE="+TABLE_NAME+"("+UID+" INTEGER PRIMARY KEY AUTOINCREMENT ,"+NAME+" VARCHAR(255));";
private static final String DROP_TABLE="DROP TABLE"+TABLE_NAME+"IF EXIST";
private Context context;
public VivzHelper(Context context)
{
super(context,"",null,1);
this.context=context;
Message.message(context,"constructor called");

}
@Override
public void onCreate(SQLiteDatabase db) {
try {
db.execSQL(CREATE_TABLE);
Message.message(context,"on create called");
} catch (SQLException e) {

Message.message(context,""+e);

}

}

@Override
public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
try {
db.execSQL(DROP_TABLE);
Message.message(context,"on upgrade called");
onCreate(db);
} catch (SQLException e) {

Message.message(context,""+e);
}

}

Darren_vms 11-Mar-15 6:41am

Have you looked at
http://www.codeproject.com/Articles/119293/Using-SQLite-Database-with-Android
It may answer your question

/Darren

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)