Don't like ads? PRO users don't see any ads ;-)
Public Pastes
Guest

Untitled

By: a guest on Aug 1st, 2012  |  syntax: None  |  size: 14.14 KB  |  hits: 9  |  expires: Never
download  |  raw  |  embed  |  report abuse  |  print
Text below is selected. Please press Ctrl+C to copy to your clipboard. (⌘+C on Mac)
  1. SQL query failure after creating
  2. public static final String TABLE_CONFERENCES = "conferences";
  3.        
  4. db.beginTransaction();
  5. ...
  6. db.execSQL(DatabaseConstants.CREATE_TABLE_CONFERENCES);
  7. ...
  8. db.endTransaction();
  9.  
  10. Log.d(TAG, "testing successful create execution");
  11. db.execSQL("SELECT * FROM " + DatabaseConstants.TABLE_CONFERENCES);
  12. Log.d(TAG, "executed create statements successfully");
  13.        
  14. values = new ContentValues();
  15.  
  16.     cal.set(2020, 1, 1, 12, 30, 0);
  17.     values.put(DatabaseConstants.CONFERENCE_START, cal.getTimeInMillis());
  18.     cal.set(2021, 6, 6, 13, 30, 0);
  19.     values.put(DatabaseConstants.CONFERENCE_END, cal.getTimeInMillis());
  20.     values.put(DatabaseConstants.CONFERENCE_CREATOR, lastInsertId);
  21.  
  22.     conferenceID = lastInsertId = db.insert(DatabaseConstants.TABLE_CONFERENCES, null, values);
  23.  
  24.     Log.d(TAG, "inserted ConferenceId: " + Long.toString(lastInsertId));
  25.  
  26.     cursor = db.query(
  27.                 DatabaseConstants.TABLE_CONFERENCES,
  28.                 new String[] { DatabaseConstants.CONFERENCE_ID },
  29.                 DatabaseConstants.CONFERENCE_ID + "=" + lastInsertId,
  30.                 null,
  31.                 null,
  32.                 null,
  33.                 null,
  34.                 null);
  35.  
  36.     Log.d(TAG, "inserted Conference successfully");
  37.  
  38.     cursor.moveToFirst();
  39.  
  40.     Log.d(TAG,
  41.             "Conference has " + DatabaseConstants.PARTICIPANT_ID + ": " +
  42.             Long.toString(cursor.getLong(cursor.getColumnIndex(DatabaseConstants.CONFERENCE_ID))));
  43.  
  44.     cursor.close();
  45.        
  46. public Conference getConference(long conferenceId) {
  47.     Log.d(TAG, "getConference with conferenceId " + conferenceId + " called");
  48.  
  49.     /*
  50.      * query(table, columns, selection, selectionArgs, groupBy, having, orderBy)
  51.      */
  52.     Cursor cursor = database.query(
  53.             DatabaseConstants.TABLE_CONFERENCES,
  54.             fields,
  55.             DatabaseConstants.CONFERENCE_ID + "=" + conferenceId,
  56.             null,
  57.             null,
  58.             null,
  59.             null);
  60.  
  61.     cursor.moveToFirst();
  62.  
  63.     Conference conference = cursorToConference(cursor);
  64.  
  65.     cursor.close();
  66.  
  67.     return conference;
  68. }
  69.        
  70. 04-20 14:39:28.669: D/ConferenceDataSource(1300): getConference with conferenceId 1 called
  71. 04-20 14:39:28.669: I/SqliteDatabaseCpp(1300): sqlite returned: error code = 1, msg = no such table: conferences, db=/data/data/com.tsystems.openconf/databases/OpenConf_App.Prototype.1.5
  72. 04-20 14:39:28.729: D/AndroidRuntime(1300): Shutting down VM
  73. 04-20 14:39:28.729: W/dalvikvm(1300): threadid=1: thread exiting with uncaught exception (group=0x409c01f8)
  74. 04-20 14:39:28.879: E/AndroidRuntime(1300): FATAL EXCEPTION: main
  75. 04-20 14:39:28.879: E/AndroidRuntime(1300): java.lang.RuntimeException: Unable to start activity ComponentInfo{com.tsystems.openconf/com.tsystems.openconf.dashboard.item.ConferenceTableActivity}: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.tsystems.openconf/com.tsystems.openconf.tab.ConferenceInfoActivity}: android.database.sqlite.SQLiteException: no such table: conferences: , while compiling: SELECT _id, startTime, endTime, creator FROM conferences WHERE _id=1
  76. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956)
  77. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
  78. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.access$600(ActivityThread.java:123)
  79. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
  80. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.os.Handler.dispatchMessage(Handler.java:99)
  81. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.os.Looper.loop(Looper.java:137)
  82. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.main(ActivityThread.java:4424)
  83. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at java.lang.reflect.Method.invokeNative(Native Method)
  84. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at java.lang.reflect.Method.invoke(Method.java:511)
  85. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
  86. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
  87. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at dalvik.system.NativeStart.main(Native Method)
  88. 04-20 14:39:28.879: E/AndroidRuntime(1300): Caused by: java.lang.RuntimeException: Unable to start activity ComponentInfo{com.tsystems.openconf/com.tsystems.openconf.tab.ConferenceInfoActivity}: android.database.sqlite.SQLiteException: no such table: conferences: , while compiling: SELECT _id, startTime, endTime, creator FROM conferences WHERE _id=1
  89. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1956)
  90. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.startActivityNow(ActivityThread.java:1797)
  91. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.LocalActivityManager.moveToState(LocalActivityManager.java:135)
  92. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.LocalActivityManager.startActivity(LocalActivityManager.java:347)
  93. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.widget.TabHost$IntentContentStrategy.getContentView(TabHost.java:682)
  94. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.widget.TabHost.setCurrentTab(TabHost.java:346)
  95. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.widget.TabHost.addTab(TabHost.java:236)
  96. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at com.tsystems.openconf.dashboard.item.ConferenceTableActivity.onCreate(ConferenceTableActivity.java:55)
  97. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.Activity.performCreate(Activity.java:4465)
  98. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
  99. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
  100. 04-20 14:39:28.879: E/AndroidRuntime(1300):     ... 11 more
  101. 04-20 14:39:28.879: E/AndroidRuntime(1300): Caused by: android.database.sqlite.SQLiteException: no such table: conferences: , while compiling: SELECT _id, startTime, endTime, creator FROM conferences WHERE _id=1
  102. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
  103. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:68)
  104. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteProgram.compileSql(SQLiteProgram.java:143)
  105. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteProgram.compileAndbindAllArgs(SQLiteProgram.java:361)
  106. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:127)
  107. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:94)
  108. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteQuery.<init>(SQLiteQuery.java:53)
  109. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:47)
  110. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1564)
  111. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteDatabase.queryWithFactory(SQLiteDatabase.java:1449)
  112. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1405)
  113. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.database.sqlite.SQLiteDatabase.query(SQLiteDatabase.java:1485)
  114. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at com.tsystems.openconf.database.dataSource.ConferenceDataSource.getConference(ConferenceDataSource.java:100)
  115. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at com.tsystems.openconf.tab.ConferenceInfoActivity.onCreate(ConferenceInfoActivity.java:34)
  116. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.Activity.performCreate(Activity.java:4465)
  117. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
  118. 04-20 14:39:28.879: E/AndroidRuntime(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
  119. 04-20 14:39:28.879: E/AndroidRuntime(1300):     ... 21 more
  120. 04-20 14:39:28.988: D/dalvikvm(1300): GC_CONCURRENT freed 215K, 3% free 9321K/9607K, paused 8ms+9ms
  121. 04-20 14:39:29.109: E/SQLiteDatabase(1300): close() was never explicitly called on database '/data/data/com.tsystems.openconf/databases/OpenConf_App.Prototype.1.5'
  122. 04-20 14:39:29.109: E/SQLiteDatabase(1300): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
  123. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1943)
  124. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:1007)
  125. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:986)
  126. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:1051)
  127. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:770)
  128. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:221)
  129. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:157)
  130. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at com.tsystems.openconf.database.dataSource.ConferenceDataSource.open(ConferenceDataSource.java:41)
  131. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at com.tsystems.openconf.tab.ConferenceInfoActivity.onCreate(ConferenceInfoActivity.java:32)
  132. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.Activity.performCreate(Activity.java:4465)
  133. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
  134. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
  135. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.startActivityNow(ActivityThread.java:1797)
  136. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.LocalActivityManager.moveToState(LocalActivityManager.java:135)
  137. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.LocalActivityManager.startActivity(LocalActivityManager.java:347)
  138. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.widget.TabHost$IntentContentStrategy.getContentView(TabHost.java:682)
  139. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.widget.TabHost.setCurrentTab(TabHost.java:346)
  140. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.widget.TabHost.addTab(TabHost.java:236)
  141. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at com.tsystems.openconf.dashboard.item.ConferenceTableActivity.onCreate(ConferenceTableActivity.java:55)
  142. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.Activity.performCreate(Activity.java:4465)
  143. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1049)
  144. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1920)
  145. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1981)
  146. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.access$600(ActivityThread.java:123)
  147. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:1147)
  148. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.os.Handler.dispatchMessage(Handler.java:99)
  149. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.os.Looper.loop(Looper.java:137)
  150. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at android.app.ActivityThread.main(ActivityThread.java:4424)
  151. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at java.lang.reflect.Method.invokeNative(Native Method)
  152. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at java.lang.reflect.Method.invoke(Method.java:511)
  153. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:784)
  154. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:551)
  155. 04-20 14:39:29.109: E/SQLiteDatabase(1300):     at dalvik.system.NativeStart.main(Native Method)
  156. 04-20 14:39:29.109: E/System(1300): Uncaught exception thrown by finalizer
  157. 04-20 14:39:29.139: E/System(1300): java.lang.IllegalStateException: Don't have database lock!
  158. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase.verifyLockOwner(SQLiteDatabase.java:2090)
  159. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2182)
  160. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase$1.entryRemoved(SQLiteDatabase.java:2178)
  161. 04-20 14:39:29.139: E/System(1300):     at android.util.LruCache.trimToSize(LruCache.java:197)
  162. 04-20 14:39:29.139: E/System(1300):     at android.util.LruCache.evictAll(LruCache.java:285)
  163. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase.deallocCachedSqlStatements(SQLiteDatabase.java:2143)
  164. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase.closeClosable(SQLiteDatabase.java:1126)
  165. 04-20 14:39:29.139: E/System(1300):     at android.database.sqlite.SQLiteDatabase.finalize(SQLiteDatabase.java:1914)
  166. 04-20 14:39:29.139: E/System(1300):     at java.lang.Daemons$FinalizerDaemon.doFinalize(Daemons.java:182)
  167. 04-20 14:39:29.139: E/System(1300):     at java.lang.Daemons$FinalizerDaemon.run(Daemons.java:168)
  168. 04-20 14:39:29.139: E/System(1300):     at java.lang.Thread.run(Thread.java:856)
create a new version of this paste RAW Paste Data