۱۳۹۴/۰۱/۱۲, ۰۱:۳۴ ب.ظ
(آخرین تغییر در ارسال: ۱۳۹۴/۰۱/۱۲, ۰۱:۵۲ ب.ظ توسط ramtin2080.)
من سعی دارم با استفاده از کد زیر که در یک کلاس از گسترش BaseAdapter قرار دارد، پایگاه دادهای را کپی و مقدار myValue را در آن جستجو کنم و معادل آن را از پایگاه داده در رشتهی ID ذخیره کنم. (مقدار myValue برای هر آیتم لیست متغییر است اما در اینجا برای نمایش دادن کد مقداری ثابت آوردهام و پایگاه داده myTable در مسیر /data/data/com.test.database/databases/ کپی میشود ):اما کد بالا تنها قادر به کپی کردن پایگاه داده در اولین اجرا است و بعد از آن برنامه بسته می شود و خطای زیر در لاگ نمایش داده میشود:
کد پیاچپی:
SQLiteDatabase database;
database db = new database(context);
SharedPreferences shared =this.context.getSharedPreferences("Prefs", Context.MODE_PRIVATE);
SharedPreferences.Editor editor = shared.edit();
boolean isFirstRun = shared.getBoolean("FIRSTRUN", true);
if (isFirstRun){
try
{
db.createDataBase();
}
catch (IOException io)
{
throw new Error("Unable to create database");
}
editor.putBoolean("FIRSTRUN", false);
editor.commit();
}
String myValue = "Reza";
database = db.getReadableDatabase();
String selectQuery = "SELECT * FROM mytable WHERE myColumn = ' " + myValue+"'";
Cursor cursor = database.rawQuery(selectQuery, null);
cursor.moveToFirst();
String ID = cursor.getString(0);
کد پیاچپی:
04-01 13:22:55.168: W/ActivityThread(12251): Application com.test.database can be debugged on port 8100...
04-01 13:22:55.178: W/ResourceType(12251): CREATING STRING CACHE OF 44 bytes
04-01 13:22:55.208: I/WifiManager(12251): Process dle.wifiscanner requested a scan
04-01 13:22:55.268: E/SQLiteLog(12251): (26) file is encrypted or is not a database
04-01 13:22:55.268: E/DefaultDatabaseErrorHandler(12251): Corruption reported by sqlite on database: /data/data/com.test.database/databases/mytable.db
04-01 13:22:55.268: E/DefaultDatabaseErrorHandler(12251): deleting the database file: /data/data/com.test.database/databases/mytable.db
04-01 13:22:55.388: E/SQLiteLog(12251): (1) no such table: oui
04-01 13:22:55.398: D/AndroidRuntime(12251): Shutting down VM
04-01 13:22:55.398: W/dalvikvm(12251): threadid=1: thread exiting with uncaught exception (group=0x415cfd88)
04-01 13:22:55.398: E/AndroidRuntime(12251): FATAL EXCEPTION: main
04-01 13:22:55.398: E/AndroidRuntime(12251): Process: com.test.database, PID: 12251
04-01 13:22:55.398: E/AndroidRuntime(12251): android.database.sqlite.SQLiteException: no such table: oui (code 1): , while compiling: SELECT * FROM myTable WHERE myColumn = 'Reza'
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteProgram.<init>cryingSQLiteProgram.java:58)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteQuery.<init>cryingSQLiteQuery.java:37)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteDirectCursorDriver.query(SQLiteDirectCursorDriver.java:44)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1314)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1253)
04-01 13:22:55.398: E/AndroidRuntime(12251): at com.test.database.ScanResultsAdapter.getView(ScanResultsAdapter.java:84)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.AbsListView.obtainView(AbsListView.java:2255)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.ListView.measureHeightOfChildren(ListView.java:1263)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.ListView.onMeasure(ListView.java:1175)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.View.measure(View.java:16628)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.LinearLayout.measureChildBeforeLayout(LinearLayout.java:1404)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.LinearLayout.measureVertical(LinearLayout.java:695)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.LinearLayout.onMeasure(LinearLayout.java:588)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.View.measure(View.java:16628)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.FrameLayout.onMeasure(FrameLayout.java:310)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.View.measure(View.java:16628)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
04-01 13:22:55.398: E/AndroidRuntime(12251): at com.android.internal.widget.ActionBarOverlayLayout.onMeasure(ActionBarOverlayLayout.java:327)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.View.measure(View.java:16628)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewGroup.measureChildWithMargins(ViewGroup.java:5125)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.widget.FrameLayout.onMeasure(FrameLayout.java:310)
04-01 13:22:55.398: E/AndroidRuntime(12251): at com.android.internal.policy.impl.PhoneWindow$DecorView.onMeasure(PhoneWindow.java:2298)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.View.measure(View.java:16628)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewRootImpl.performMeasure(ViewRootImpl.java:1916)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewRootImpl.measureHierarchy(ViewRootImpl.java:1113)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewRootImpl.performTraversals(ViewRootImpl.java:1295)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewRootImpl.doTraversal(ViewRootImpl.java:1000)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.ViewRootImpl$TraversalRunnable.run(ViewRootImpl.java:5622)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.Choreographer$CallbackRecord.run(Choreographer.java:761)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.Choreographer.doCallbacks(Choreographer.java:574)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.Choreographer.doFrame(Choreographer.java:544)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.view.Choreographer$FrameDisplayEventReceiver.run(Choreographer.java:747)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.os.Handler.handleCallback(Handler.java:733)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.os.Handler.dispatchMessage(Handler.java:95)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.os.Looper.loop(Looper.java:212)
04-01 13:22:55.398: E/AndroidRuntime(12251): at android.app.ActivityThread.main(ActivityThread.java:5135)
04-01 13:22:55.398: E/AndroidRuntime(12251): at java.lang.reflect.Method.invokeNative(Native Method)
04-01 13:22:55.398: E/AndroidRuntime(12251): at java.lang.reflect.Method.invoke(Method.java:515)
04-01 13:22:55.398: E/AndroidRuntime(12251): at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:877)
04-01 13:22:55.398: E/AndroidRuntime(12251): at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:693)
04-01 13:22:55.398: E/AndroidRuntime(12251): at dalvik.system.NativeStart.main(Native Method)