,   CyberForum.ru

"Attempt to re-open an already-closed object" SQLite - Android


Android Android http://www.cyberforum.ru/android-dev/thread1416961.html
"alien shooter" . , .
Android , - ( ), ) http://www.cyberforum.ru/android-dev/thread1416904.html
" " Android
, " " ( , -). , ??? , ! Voice Recorder ...
Android - , ,
! , , ... ! ... ! ! ? ? - . ( ). - - , . ...
Android http://www.cyberforum.ru/android-dev/thread1416836.html
. . ?? ?? () ?? 1 29 . ...
Android Debugger, ? . , Android Studio . . , . 2 : 1) . AS "Connected to the target VM, address:...

Naomis
6 / 6 / 1
: 11.03.2015
: 210
: 1
10.04.2015, 18:12  []     "Attempt to re-open an already-closed object" SQLite
.

Prolog
1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
101
102
103
104
105
106
107
108
109
110
111
112
113
114
115
116
117
118
119
120
121
122
123
124
125
126
127
128
129
130
131
132
133
134
135
136
137
138
139
140
141
142
143
144
04-10 17:49:35.929    4807-4807/com.example.kirukato.coolstdreg D/OpenGLRenderer﹕ Enabling debug mode 0
04-10 17:49:48.192    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕     
04-10 17:49:48.202    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ - 
04-10 17:49:48.202    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ Ĩ '' 
04-10 17:50:09.235    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ !
04-10 17:50:09.235    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    --- if (edtMan.getSelectedItem() != null) ---
04-10 17:50:09.235    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if    -----
04-10 17:50:09.235    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if -----   checkMan = true;
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if -----   checkMan = true;-- 
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if-----    cur = db.GetCatalogValueByName(.........);
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕  edtMan.getSelectedItem().toString()------
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ----  GetCatalogValueByName----
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ---  . select _id from man where name = ''
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ select _id from man where name = ''
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ 1
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if-----    cur = db.GetCatalogValueByName(.........);-------
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if-----    _id ---- cManID = cur.getInt(...._id")-----
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if-----    _id ---- cManID = cur.getInt(...._id")-----
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕   E  --- if (edtET.getSelectedItem() != null) ---
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ----  GetCatalogValueByName----
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ---  . select _id from event_type where name = ' '
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ select _id from event_type where name = ' '
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ 1
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    --- if (edtMeet.getSelectedItem() != null) ---
04-10 17:50:09.245    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ----  GetCatalogValueByName----
04-10 17:50:09.255    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ---  . select _id from meeting where name = ' '
04-10 17:50:09.255    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ select _id from meeting where name = ' '
04-10 17:50:09.255    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ 1
04-10 17:50:09.255    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    'TRUE'     'event' --- if(checkMan != false & checkET != false & checkMeet != false) ---
04-10 17:50:09.255    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    ---- db.addRec("event", DB.EVENT_COLUMN_MAN, cManID ); ---
04-10 17:50:09.305    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ 
04-10 17:50:09.305    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    ---- db.addRec("event", DB.EVENT_COLUMN_MEETING, cMeetID ); ---
04-10 17:50:09.305    4807-4807/com.example.kirukato.coolstdreg E/SQLiteLog﹕ (1) table event has no column named MeetingId
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg E/SQLiteDatabase﹕ Error inserting MeetingId=3
    android.database.sqlite.SQLiteException: table event has no column named MeetingId (code 1): , while compiling: INSERT INTO event(MeetingId) VALUES (?)
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
            at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
            at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
            at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
            at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1475)
            at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1347)
            at com.example.kirukato.coolstdreg.DB.addRec(DB.java:116)
            at com.example.kirukato.coolstdreg.EventActivity$1.onClick(EventActivity.java:133)
            at android.view.View.performClick(View.java:4421)
            at android.view.View$PerformClick.run(View.java:17903)
            at android.os.Handler.handleCallback(Handler.java:730)
            at android.os.Handler.dispatchMessage(Handler.java:92)
            at android.os.Looper.loop(Looper.java:213)
            at android.app.ActivityThread.main(ActivityThread.java:5225)
            at java.lang.reflect.Method.invokeNative(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:525)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
            at dalvik.system.NativeStart.main(Native Method)
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ 
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    ---- db.addRec("event", DB.EVENT_COLUMN_EVENT_TYPE, cETID ); ---
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg E/SQLiteLog﹕ (1) table event has no column named EventTypeId
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg E/SQLiteDatabase﹕ Error inserting EventTypeId=2
    android.database.sqlite.SQLiteException: table event has no column named EventTypeId (code 1): , while compiling: INSERT INTO event(EventTypeId) VALUES (?)
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
            at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
            at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
            at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
            at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1475)
            at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1347)
            at com.example.kirukato.coolstdreg.DB.addRec(DB.java:116)
            at com.example.kirukato.coolstdreg.EventActivity$1.onClick(EventActivity.java:137)
            at android.view.View.performClick(View.java:4421)
            at android.view.View$PerformClick.run(View.java:17903)
            at android.os.Handler.handleCallback(Handler.java:730)
            at android.os.Handler.dispatchMessage(Handler.java:92)
            at android.os.Looper.loop(Looper.java:213)
            at android.app.ActivityThread.main(ActivityThread.java:5225)
            at java.lang.reflect.Method.invokeNative(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:525)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
            at dalvik.system.NativeStart.main(Native Method)
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ 
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕     ---- ---
04-10 17:50:09.315    4807-4807/com.example.kirukato.coolstdreg E/SQLiteLog﹕ (1) table event has no column named Value
04-10 17:50:09.325    4807-4807/com.example.kirukato.coolstdreg E/SQLiteDatabase﹕ Error inserting Value=1
    android.database.sqlite.SQLiteException: table event has no column named Value (code 1): , while compiling: INSERT INTO event(Value) VALUES (?)
            at android.database.sqlite.SQLiteConnection.nativePrepareStatement(Native Method)
            at android.database.sqlite.SQLiteConnection.acquirePreparedStatement(SQLiteConnection.java:889)
            at android.database.sqlite.SQLiteConnection.prepare(SQLiteConnection.java:500)
            at android.database.sqlite.SQLiteSession.prepare(SQLiteSession.java:588)
            at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:58)
            at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:31)
            at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1475)
            at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1347)
            at com.example.kirukato.coolstdreg.DB.addRec(DB.java:116)
            at com.example.kirukato.coolstdreg.EventActivity$1.onClick(EventActivity.java:145)
            at android.view.View.performClick(View.java:4421)
            at android.view.View$PerformClick.run(View.java:17903)
            at android.os.Handler.handleCallback(Handler.java:730)
            at android.os.Handler.dispatchMessage(Handler.java:92)
            at android.os.Looper.loop(Looper.java:213)
            at android.app.ActivityThread.main(ActivityThread.java:5225)
            at java.lang.reflect.Method.invokeNative(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:525)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
            at dalvik.system.NativeStart.main(Native Method)
04-10 17:50:09.325    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ---1
04-10 17:51:09.359    4807-4807/com.example.kirukato.coolstdreg D/on pause﹕ /
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ !
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕    --- if (edtMan.getSelectedItem() != null) ---
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if    -----
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if -----   checkMan = true;
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if -----   checkMan = true;-- 
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕ ----if-----    cur = db.GetCatalogValueByName(.........);
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/EVENT__ACTIVITY﹕  edtMan.getSelectedItem().toString()------
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ----  GetCatalogValueByName----
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg V/DB__ACTIVITY﹕ ---  . select _id from man where name = ''
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg D/AndroidRuntime﹕ Shutting down VM
04-10 17:51:35.397    4807-4807/com.example.kirukato.coolstdreg W/dalvikvm﹕ threadid=1: thread exiting with uncaught exception (group=0x4154d8b0)
04-10 17:51:35.407    4807-4807/com.example.kirukato.coolstdreg E/AndroidRuntime﹕ FATAL EXCEPTION: main
    java.lang.IllegalStateException: attempt to re-open an already-closed object: SQLiteDatabase: /data/data/com.example.kirukato.coolstdreg/databases/Allreg
            at android.database.sqlite.SQLiteClosable.acquireReference(SQLiteClosable.java:55)
            at android.database.sqlite.SQLiteDatabase.rawQueryWithFactory(SQLiteDatabase.java:1318)
            at android.database.sqlite.SQLiteDatabase.rawQuery(SQLiteDatabase.java:1261)
            at com.example.kirukato.coolstdreg.DB.GetCatalogValueByName(DB.java:156)
            at com.example.kirukato.coolstdreg.EventActivity$1.onClick(EventActivity.java:96)
            at android.view.View.performClick(View.java:4421)
            at android.view.View$PerformClick.run(View.java:17903)
            at android.os.Handler.handleCallback(Handler.java:730)
            at android.os.Handler.dispatchMessage(Handler.java:92)
            at android.os.Looper.loop(Looper.java:213)
            at android.app.ActivityThread.main(ActivityThread.java:5225)
            at java.lang.reflect.Method.invokeNative(Native Method)
            at java.lang.reflect.Method.invoke(Method.java:525)
            at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:741)
            at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:557)
            at dalvik.system.NativeStart.main(Native Method)
04-10 17:56:35.417    4807-4807/com.example.kirukato.coolstdreg I/Process﹕ Sending signal. PID: 4807 SIG: 9
04-10 17:56:35.877    5436-5436/com.example.kirukato.coolstdreg D/libEGL﹕ loaded /vendor/lib/egl/libEGL_adreno.so
04-10 17:56:35.877    5436-5436/com.example.kirukato.coolstdreg D/libEGL﹕ loaded /vendor/lib/egl/libGLESv1_CM_adreno.so
04-10 17:56:35.897    5436-5436/com.example.kirukato.coolstdreg D/libEGL﹕ loaded /vendor/lib/egl/libGLESv2_adreno.so
04-10 17:56:35.897    5436-5436/com.example.kirukato.coolstdreg I/Adreno-EGL﹕ <qeglDrvAPI_eglInitialize:316>: EGL 1.4
, , .
"table event has no column named MeetingId", . , . Ctrl+c Ctrl+v .
 
- , ,
-
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2017, vBulletin Solutions, Inc.
@Mail.ru