I'm trying to use an SQLite table with Android (and for almost the first
time, period, but I familiarized myself with it using SQLite3 /
tclsh8.4), and I've run into a bit of a problem where I can't seem to
spot the error.....
Here is the code where it's failing and force closing:
--------------------------- CUT HERE ---------------------------
// global - before start of DataBaseHelper class:
private static final String TABLE_GRAINBRANDS = "grainbrands";
// much later in DataBaseHelper
List<String> grainBrandsList = new ArrayList<String>();
String selectQuery = "SELECT * FROM " + TABLE_GRAINBRANDS;
String brand;
SQLiteDatabase db = this.getWritableDatabase();
Cursor c = db.rawQuery(selectQuery, null); // This is the line (75)
// that logcat says causes the force close
--------------------------- CUT HERE ---------------------------
Surrounding logcat code:
--------------------------- CUT HERE ---------------------------
I/ActivityManager(15152): Start proc com.jdgapps.andgtbrew2 for activity
com.jdgapps.andgtbrew2/.AndGTbrew2: pid=28296 uid=10327
gids={1015, 1028}
I/ActivityManager(15152): Displayed com.jdgapps.andgtbrew2/.AndGTbrew2: +3s183ms
E/AndroidRuntime(28296):
at
com.jdgapps.andgtbrew2.DataBaseHelper.getGrainBrands(DataBaseHelper.java:175)
E/AndroidRuntime(28296): at
com.jdgapps.andgtbrew2.AndGTbrew2$1.onClick(AndGTbrew2.java:92)
W/ActivityManager(15152): Force finishing activity
com.jdgapps.andgtbrew2/.AndGTbrew2
W/ActivityManager(15152): Activity pause timeout for
ActivityRecord{4280e468 com.jdgapps.andgtbrew2/.AndGTbrew2}
I/ActivityManager(15152): Process com.jdgapps.andgtbrew2 (pid 28296) has died.
--------------------------- CUT HERE ---------------------------
Unfortunately, this error message doesn't tell me much, and while looking
between tutorials and my code here, I can't see what's wrong with it.
I tried to check in /data/data/com.jdgapps.andgtbrew2/ to see if gtbrew2.db
was there, but /data was empty, so I gather it's hidden. Good security,
normally, but a PITA right now.....
Logcat does not show any of the errors that would be generated if the
dabase copy (from assets to the above) failed, so it should be there.
Does anyone see anything that I might have missed?
Thanks,
--jim
--
THE SCORE: ME: 2 CANCER: 0
73 DE N5IAL (/4) |
[email protected] | TeX actually recognizes several kinds of
< Running Mac OS X Lion > | infinity, some of which are ``more infinite''
ICBM / Hurricane: | than others.
30.44406N 86. 59909W | --Donald Knuth in {The TeXbook}
--
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to
[email protected]
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
---
You received this message because you are subscribed to the Google Groups
"Android Developers" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
For more options, visit https://groups.google.com/d/optout.
