@Override
public void onCreate (SQLiteDatabase db)
{
try {
db.execSQL ("create table" + NotificationManager.getUserStatic (context) + "log (" +
KEY_TIME + "INTEGER primary key," + KEY_TEXT + "TEXT not null);");
}
catch (SQLException e) {
e.printStackTrace ();
}
}
/ **
* onOpen method called when app is opening.
* /
@Override
public void onOpen (SQLiteDatabase db)
{
try {
System.out.println ("tophere");
db.execSQL ("create table if not exists" + DATABASE_NAME + "." + NotificationManager.getUserStatic (context) + "log (" +
KEY_TIME + "INTEGER primary key," + KEY_TEXT + "TEXT not null);");
System.out.println ("downhere");
}
catch (SQLException e) {
e.printStackTrace ();
}
}
We have this code to create a database for the application. the problem is that, as far as we can tell, it does not create tables, so when we try to insert them into tables and read them, it leads to crashes. we tried everything System.out.println to see where it does not work. we get the top, but he never gets to the bottom of the magazine, so we guess that something makes him fail. we checked with DDMS that the database is in the correct folder, so the database should be there, but for some reason it cannot find it (lines 2 and 3 in the log).
Any thoughts?
This is the error log:
04-27 10: 45: 46.768: I / System.out (6441): tophere
04-27 10: 45: 46.772: I / SqliteDatabaseCpp (6441): sqlite returned: error code = 1, msg = unknown database NOPO, db = / data / data / dmri.nopo / databases / NOPO
04-27 10: 45: 46.772: W / System.err (6441): android.database.sqlite.SQLiteException: unknown database NOPO:, while compiling: create table if not exists NOPO.log (time INTEGER primary key, text TEXT not null);
04-27 10: 45: 46.792: W / System.err (6441): at android.database.sqlite.SQLiteCompiledSql.native_compile (Native Method)
04-27 10: 45: 46.792: W / System.err (6441): at android.database.sqlite.SQLiteCompiledSql. (SQLiteCompiledSql.java:68)
04-27 10: 45: 46.811: W / System.err (6441): at android.database.sqlite.SQLiteProgram.compileSql (SQLiteProgram.java:134)
04-27 10: 45: 46.811: W / System.err (6441): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs (SQLiteProgram.javahaps61)
04-27 10: 45: 46.811: W / System.err (6441): at android.database.sqlite.SQLiteStatement.acquireAndLock (SQLiteStatement.java:260)
04-27 10: 45: 46.811: W / System.err (6441): at android.database.sqlite.SQLiteStatement.executeUpdateDelete (SQLiteStatement.java:84)
04-27 10: 45: 46.811: W / System.err (6441): at android.database.sqlite.SQLiteDatabase.executeSql (SQLiteDatabase.java:1899)
04-27 10: 45: 46.823: W / System.err (6441): at android.database.sqlite.SQLiteDatabase.execSQL (SQLiteDatabase.java:1839)
04-27 10: 45: 46.823: W / System.err (6441): at dmri.nopo.DBAdapter $ DatabaseHelper.onOpen (DBAdapter.java:67)
04-27 10: 45: 46.823: W / System.err (6441): at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase (SQLiteOpenHelper.java:180)
04-27 10: 45: 46.902: W / System.err (6441): at dmri.nopo.DBAdapter.open (DBAdapter.java:86)
04-27 10: 45: 46.912: W / System.err (6441): at dmri.nopo.LogManager.readLogFile (LogManager.java:32)
04-27 10: 45: 46.912: W / System.err (6441): at dmri.nopo.LogActivity.onCreate (LogActivity.java:25)
04-27 10: 45: 46.921: W / System.err (6441): at android.app.Activity.performCreate (Activity.java:4465)
04-27 10: 45: 46.921: W / System.err (6441): at android.app.Instrumentation.callActivityOnCreate (Instrumentation.java:1049)
04-27 10: 45: 46.931: W / System.err (6441): at android.app.ActivityThread.performLaunchActivity (ActivityThread.java:1920)
04-27 10: 45: 46.931: W / System.err (6441): at android.app.ActivityThread.handleLaunchActivity (ActivityThread.java:1981)
04-27 10: 45: 46.941: W / System.err (6441): at android.app.ActivityThread.access $ 600 (ActivityThread.java:123)
04-27 10: 45: 46.941: W / System.err (6441): at android.app.ActivityThread $ H.handleMessage (ActivityThread.java:1147)
04-27 10: 45: 46.953: W / System.err (6441): at android.os.Handler.dispatchMessage (Handler.java:99)
04-27 10: 45: 46.953: W / System.err (6441): at android.os.Looper.loop (Looper.java:137)
04-27 10: 45: 46.972: W / System.err (6441): at android.app.ActivityThread.main (ActivityThread.java:4424)
04-27 10: 45: 46.972: W / System.err (6441): at java.lang.reflect.Method.invokeNative (Native Method)
04-27 10: 45: 46.972: W / System.err (6441): at java.lang.reflect.Method.invoke (Method.java∗11)
04-27 10: 45: 46.982: W / System.err (6441): at com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run (ZygoteInit.java:784)
04-27 10: 45: 46.982: W / System.err (6441): at com.android.internal.os.ZygoteInit.main (ZygoteInit.java►51)
04-27 10: 45: 46.992: W / System.err (6441): at dalvik.system.NativeStart.main (Native Method)
04-27 10: 45: 47.002: I / SqliteDatabaseCpp (6441): sqlite returned: error code = 1, msg = no such table: log, db = / data / data / dmri.nopo / databases / NOPO
04-27 10: 45: 47.012: D / AndroidRuntime (6441): Shutting down VM
04-27 10: 45: 47.012: W / dalvikvm (6441): threadid = 1: thread exiting with uncaught exception (group = 0x409c01f8)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): FATAL EXCEPTION: main
04-27 10: 45: 47.181: E / AndroidRuntime (6441): java.lang.RuntimeException: Unable to start activity ComponentInfo {dmri.nopo / dmri.nopo.LogActivity}: android.database.sqlite.SQLiteException: no such table : log:, while compiling: SELECT time, text FROM log
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread.performLaunchActivity (ActivityThread.java:1956)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread.handleLaunchActivity (ActivityThread.java:1981)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread.access $ 600 (ActivityThread.java:123)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread $ H.handleMessage (ActivityThread.java:1147)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.os.Handler.dispatchMessage (Handler.java:99)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.os.Looper.loop (Looper.java:137)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread.main (ActivityThread.java:4424)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at java.lang.reflect.Method.invokeNative (Native Method)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at java.lang.reflect.Method.invoke (Method.java∗11)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at com.android.internal.os.ZygoteInit $ MethodAndArgsCaller.run (ZygoteInit.java:784)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at com.android.internal.os.ZygoteInit.main (ZygoteInit.java►51)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at dalvik.system.NativeStart.main (Native Method)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): Caused by: android.database.sqlite.SQLiteException: no such table: log:, while compiling: SELECT time, text FROM log
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteCompiledSql.native_compile (Native Method)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteCompiledSql. (SQLiteCompiledSql.java:68)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteProgram.compileSql (SQLiteProgram.java:143)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs (SQLiteProgram.javahaps61)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteProgram. (SQLiteProgram.java:127)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteProgram. (SQLiteProgram.java:94)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteQuery. (SQLiteQuery.java:53)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteDirectCursorDriver.query (SQLiteDirectCursorDriver.java:47)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory (SQLiteDatabase.java:1564)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteDatabase.queryWithFactory (SQLiteDatabase.java:1449)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteDatabase.query (SQLiteDatabase.java:1405)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.database.sqlite.SQLiteDatabase.query (SQLiteDatabase.java:1485)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at dmri.nopo.DBAdapter.getAllSMS (DBAdapter.java:116)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at dmri.nopo.LogManager.readLogFile (LogManager.java:34)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at dmri.nopo.LogActivity.onCreate (LogActivity.java:25)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.Activity.performCreate (Activity.java:4465)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.Instrumentation.callActivityOnCreate (Instrumentation.java:1049)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): at android.app.ActivityThread.performLaunchActivity (ActivityThread.java:1920)
04-27 10: 45: 47.181: E / AndroidRuntime (6441): ... 11 more
source share