sqlite sous android

Bonjour je suis nouveau sous android et j'essaie d'utiliser une base de données sqlite.
dans mon fichier PlaneteDbAdapteur.java j'ai ceci

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
public class PlaneteDbAdaptateur {
    private static final int VERSION_DATABASE=1;
    private static final String NOM_DATABASE="planetes.db";
    private static final String TABLE_NAME="table_planetes";
    private static final String COLONNE_ID="id";
    private static final String COLONNE_NOM="nom";
    private static final String COLONNE_RAYON="rayon";
 
    private SQLiteDatabase maBaseDeDonnees;
    private MaBaseOpenHelper baseHelper;
    public PlaneteDbAdaptateur(Context context){
        baseHelper=new MaBaseOpenHelper(context, NOM_DATABASE, null, VERSION_DATABASE);
    }
 
    public SQLiteDatabase open(){
        return maBaseDeDonnees=baseHelper.getWritableDatabase();
    }
 
    public void close(){
        maBaseDeDonnees.close();
    }

Code:

1
2
3
4
5
6
7
8
public long insertPlanete(Planete planete){
        ContentValues valeurs=new ContentValues();
        valeurs.put("COLONNE_ID", 1);
        valeurs.put(COLONNE_NOM, planete.getNom());
        valeurs.put(COLONNE_RAYON, planete.getRayon());
        return maBaseDeDonnees.insert(TABLE_NAME, null, valeurs);
 
    }

Tjours dans le meme package j'ai créé un fichier MaBaseOpenHelper.java

Code:

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
public class MaBaseOpenHelper extends SQLiteOpenHelper{
 
    private static final String TABLE_NAME="table_planetes";
    private static final String COLONNE_ID="id";
    private static final String COLONNE_NOM="nom";
    private static final String COLONNE_RAYON="rayon";
    private static final String REQUETE_CREATION_BDD="CREATE TABLE "+TABLE_NAME+
    "("+ COLONNE_ID+" INTEGER PRIMARY KEY AUTOINCREMENT,"+ COLONNE_NOM+" TEXT NOT NULL, "+ COLONNE_RAYON+" FLOAT NOT NULL);";
    private static final String SUPPRIME_BDD="DROP TABLE IF EXISTS "+TABLE_NAME+";";
    public MaBaseOpenHelper(Context context, String name, CursorFactory factory, int version) {
        super(context, name, factory, version);
        // TODO Auto-generated constructor stub
    }
 
    @Override
    public void onCreate(SQLiteDatabase db) {
        // TODO Auto-generated method stub
        db.execSQL(REQUETE_CREATION_BDD);
    }
 
    @Override
    public void onUpgrade(SQLiteDatabase db, int oldVersion, int newVersion) {
        // TODO Auto-generated method stub
        db.execSQL(SUPPRIME_BDD);
        onCreate(db);
    }
 
}

il y'a aussi le fichier Planete.java

Code:

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
public class Planete {
    private int id;
    private String nom;
    private float rayon;
 
    public Planete(){
 
    }
 
    public Planete(String nom, float rayon){
        this.nom=nom;
        this.rayon=rayon;
    }
    public int getId() {
        return id;
    }
 
    public void setId(int id) {
        this.id = id;
    }
 
    public String getNom() {
        return nom;
    }
 
    public void setNom(String nom) {
        this.nom = nom;
    }
 
    public float getRayon() {
        return rayon;
    }
 
    public void setRayon(float rayon) {
        this.rayon = rayon;
    }
}

et enfin mon fichier activité myActivity.java

Code:

1
2
3
4
5
6
7
8
9
10
11
12
13
14
public class myActivity extends Activity {
    /** Called when the activity is first created. */
    @Override
    public void onCreate(Bundle savedInstanceState) {
        super.onCreate(savedInstanceState);
        setContentView(R.layout.main);
        PlaneteDbAdaptateur monAdaptateur=new PlaneteDbAdaptateur(this);
        monAdaptateur.open();
        Planete planete=new Planete("terre", 200);
 
        //Planete maPlanete=monAdaptateur.getPlanete(200);
        Toast.makeText(this, " "+monAdaptateur.insertPlanete(planete), Toast.LENGTH_LONG).show();
    }
}

A chaque fois que je veux inserer un enregistrement il me renvoie -1 ce qui veut dire que c'est pas bon.
Si quelqu'un peut m'aider je lui en serai reconnaissant.
Merci

Bonjour,

Dans la méthode insert de l'adapter pas besoin de passer l'id (valeurs.put("COLONNE_ID", 1);) puisque en autoincrement. Sinon y a t'il une erreur dans le logcat ?

P.S : Le rouge ça pique les yeux pour la lecture, sinon y a une balise [code] qui permet de formater le code.

Code:

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
145
146
147
148
149
150
151
152
153
154
155
156
157
158
159
160
161
162
163
164
165
166
167
168
169
170
171
172
173
174
175
176
177
178
179
180
181
182
183
184
185
186
187
188
189
190
191
192
193
194
195
196
197
198
199
200
201
202
203
204
205
206
207
208
209
210
211
212
213
214
215
216
217
218
219
220
221
222
223
224
225
226
227
228
229
230
231
232
233
234
235
236
237
238
239
240
241
242
243
244
245
246
247
248
249
250
251
252
253
254
255
256
257
258
259
260
261
262
263
264
265
266
267
268
269
270
271
272
273
274
275
276
277
278
279
280
281
282
283
284
285
286
287
288
289
290
291
292
293
294
295
296
297
298
299
300
301
302
303
304
305
306
307
308
309
310
311
312
313
314
315
316
317
318
319
320
321
322
323
324
325
326
327
328
329
330
331
332
333
334
335
336
337
338
339
340
341
342
343
344
06-08 12:03:41.082: DEBUG/PackageParser(68): Scanning package: /data/app/vmdl-1938043945.tmp
06-08 12:03:41.211: INFO/PackageManager(68): Removing non-system package:com.testSqlite
06-08 12:03:41.211: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:03:41.281: INFO/Process(68): Sending signal. PID: 617 SIG: 9
06-08 12:03:41.312: ERROR/InputDispatcher(68): channel '406b9c88 com.testSqlite/com.testSqlite.myActivity (server)' ~ Consumer closed input channel or an error occurred.  events=0x8
06-08 12:03:41.312: ERROR/InputDispatcher(68): channel '406b9c88 com.testSqlite/com.testSqlite.myActivity (server)' ~ Channel is unrecoverably broken and will be disposed!
06-08 12:03:41.322: INFO/WindowManager(68): WIN DEATH: Window{406b9c88 com.testSqlite/com.testSqlite.myActivity paused=false}
06-08 12:03:41.462: WARN/InputManagerService(68): Got RemoteException sending setActive(false) notification to pid 617 uid 10042
06-08 12:03:42.201: DEBUG/PackageManager(68): Scanning package com.testSqlite
06-08 12:03:42.201: INFO/PackageManager(68): Package com.testSqlite codePath changed from /data/app/com.testSqlite-2.apk to /data/app/com.testSqlite-1.apk; Retaining data and using new
06-08 12:03:42.201: INFO/PackageManager(68): Unpacking native libraries for /data/app/com.testSqlite-1.apk
06-08 12:03:42.512: DEBUG/installd(35): DexInv: --- BEGIN '/data/app/com.testSqlite-1.apk' ---
06-08 12:03:43.582: DEBUG/dalvikvm(645): DexOpt: load 87ms, verify+opt 129ms
06-08 12:03:43.682: DEBUG/installd(35): DexInv: --- END '/data/app/com.testSqlite-1.apk' (success) ---
06-08 12:03:43.692: WARN/PackageManager(68): Code path for pkg : com.testSqlite changing from /data/app/com.testSqlite-2.apk to /data/app/com.testSqlite-1.apk
06-08 12:03:43.692: WARN/PackageManager(68): Resource path for pkg : com.testSqlite changing from /data/app/com.testSqlite-2.apk to /data/app/com.testSqlite-1.apk
06-08 12:03:43.692: DEBUG/PackageManager(68):   Activities: com.testSqlite.myActivity
06-08 12:03:43.712: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:03:43.942: INFO/installd(35): move /data/dalvik-cache/data@app@com.testSqlite-1.apk@classes.dex -> /data/dalvik-cache/data@app@com.testSqlite-1.apk@classes.dex
06-08 12:03:43.942: DEBUG/PackageManager(68): New package installed in /data/app/com.testSqlite-1.apk
06-08 12:03:44.122: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:03:44.312: DEBUG/dalvikvm(129): GC_EXPLICIT freed 231K, 49% free 3074K/5959K, external 5334K/6232K, paused 182ms
06-08 12:03:44.442: DEBUG/dalvikvm(68): GC_EXPLICIT freed 1288K, 50% free 4437K/8775K, external 5292K/6609K, paused 259ms
06-08 12:03:44.562: DEBUG/dalvikvm(129): GC_EXPLICIT freed 9K, 49% free 3065K/5959K, external 5204K/6232K, paused 205ms
06-08 12:03:44.782: WARN/RecognitionManagerService(68): no available voice recognition services found
06-08 12:03:45.241: DEBUG/dalvikvm(68): GC_EXPLICIT freed 257K, 51% free 4348K/8775K, external 5292K/6609K, paused 125ms
06-08 12:03:45.311: INFO/installd(35): unlink /data/dalvik-cache/data@app@com.testSqlite-2.apk@classes.dex
06-08 12:03:45.322: DEBUG/AndroidRuntime(636): Shutting down VM
06-08 12:03:45.352: DEBUG/dalvikvm(636): GC_CONCURRENT freed 101K, 72% free 295K/1024K, external 0K/0K, paused 3ms+1ms
06-08 12:03:45.352: INFO/AndroidRuntime(636): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:03:45.352: DEBUG/jdwp(636): Got wake-up signal, bailing out of select
06-08 12:03:45.352: DEBUG/dalvikvm(636): Debugger has detached; object registry had 1 entries
06-08 12:03:46.211: DEBUG/AndroidRuntime(650): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:03:46.211: DEBUG/AndroidRuntime(650): CheckJNI is ON
06-08 12:03:47.281: DEBUG/AndroidRuntime(650): Calling main entry com.android.commands.am.Am
06-08 12:03:47.342: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 650
06-08 12:03:47.652: DEBUG/AndroidRuntime(650): Shutting down VM
06-08 12:03:47.672: DEBUG/dalvikvm(650): GC_CONCURRENT freed 102K, 69% free 319K/1024K, external 0K/0K, paused 2ms+3ms
06-08 12:03:47.722: INFO/AndroidRuntime(650): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:03:47.732: INFO/ActivityManager(68): Start proc com.testSqlite for activity com.testSqlite/.myActivity: pid=659 uid=10042 gids={}
06-08 12:03:47.772: DEBUG/jdwp(650): Got wake-up signal, bailing out of select
06-08 12:03:47.772: DEBUG/dalvikvm(650): Debugger has detached; object registry had 1 entries
06-08 12:03:49.672: INFO/Database(659): sqlite returned: error code = 1, msg = table table_planetes has no column named rayon
06-08 12:03:49.692: ERROR/Database(659): Error inserting rayon=200.0 nom=terre
06-08 12:03:49.692: ERROR/Database(659): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
06-08 12:03:49.692: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.insertPlanete(PlaneteDbAdaptateur.java:85)
06-08 12:03:49.692: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:19)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:03:49.692: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:03:49.692: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:03:49.692: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:03:49.692: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:03:49.692: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:03:49.692: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:03:49.692: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:03:50.231: INFO/ActivityManager(68): Displayed com.testSqlite/.myActivity: +2s62ms
06-08 12:03:53.662: INFO/dalvikvm(68): Jit: resizing JitTable from 2048 to 4096
06-08 12:03:56.543: DEBUG/dalvikvm(576): GC_EXPLICIT freed 7K, 54% free 2542K/5511K, external 1625K/2137K, paused 65ms
06-08 12:04:02.502: WARN/KeyCharacterMap(659): No keyboard for id 0
06-08 12:04:02.502: WARN/KeyCharacterMap(659): Using default keymap: /system/usr/keychars/qwerty.kcm.bin
06-08 12:04:06.492: DEBUG/AndroidRuntime(670): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:04:06.492: DEBUG/AndroidRuntime(670): CheckJNI is ON
06-08 12:04:07.502: DEBUG/AndroidRuntime(670): Calling main entry com.android.commands.pm.Pm
06-08 12:04:07.562: DEBUG/AndroidRuntime(670): Shutting down VM
06-08 12:04:07.572: DEBUG/dalvikvm(670): GC_CONCURRENT freed 101K, 71% free 297K/1024K, external 0K/0K, paused 2ms+2ms
06-08 12:04:07.582: DEBUG/dalvikvm(670): Debugger has detached; object registry had 1 entries
06-08 12:04:07.612: INFO/AndroidRuntime(670): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:04:08.313: DEBUG/AndroidRuntime(680): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:04:08.322: DEBUG/AndroidRuntime(680): CheckJNI is ON
06-08 12:04:09.432: DEBUG/AndroidRuntime(680): Calling main entry com.android.commands.am.Am
06-08 12:04:09.502: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 680
06-08 12:04:09.742: DEBUG/AndroidRuntime(680): Shutting down VM
06-08 12:04:09.762: DEBUG/dalvikvm(680): GC_CONCURRENT freed 102K, 69% free 319K/1024K, external 0K/0K, paused 2ms+2ms
06-08 12:04:09.812: INFO/AndroidRuntime(680): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:04:09.892: DEBUG/jdwp(680): Got wake-up signal, bailing out of select
06-08 12:04:09.892: DEBUG/dalvikvm(680): Debugger has detached; object registry had 1 entries
06-08 12:04:10.452: INFO/Database(659): sqlite returned: error code = 1, msg = table table_planetes has no column named rayon
06-08 12:04:10.592: ERROR/Database(659): Error inserting rayon=200.0 nom=terre
06-08 12:04:10.592: ERROR/Database(659): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
06-08 12:04:10.592: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
06-08 12:04:10.592: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.insertPlanete(PlaneteDbAdaptateur.java:85)
06-08 12:04:10.592: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:19)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:04:10.592: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:04:10.592: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:04:10.592: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:04:10.592: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:04:10.592: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:04:10.592: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:04:10.592: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:04:10.592: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:04:11.161: INFO/ActivityManager(68): Displayed com.testSqlite/.myActivity: +1s426ms
06-08 12:04:11.572: DEBUG/dalvikvm(588): GC_EXPLICIT freed 315K, 54% free 2535K/5511K, external 1625K/2137K, paused 2985ms
06-08 12:04:16.442: DEBUG/dalvikvm(596): GC_EXPLICIT freed 479K, 55% free 2593K/5703K, external 1625K/2137K, paused 91ms
06-08 12:04:21.432: DEBUG/dalvikvm(129): GC_EXPLICIT freed 76K, 49% free 3072K/5959K, external 5082K/6232K, paused 79ms
06-08 12:06:05.302: DEBUG/AndroidRuntime(692): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:06:05.302: DEBUG/AndroidRuntime(692): CheckJNI is ON
06-08 12:06:06.232: DEBUG/AndroidRuntime(692): Calling main entry com.android.commands.pm.Pm
06-08 12:06:06.302: DEBUG/AndroidRuntime(692): Shutting down VM
06-08 12:06:06.352: INFO/AndroidRuntime(692): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:06:06.362: DEBUG/dalvikvm(692): GC_CONCURRENT freed 101K, 71% free 297K/1024K, external 0K/0K, paused 5ms+3ms
06-08 12:06:06.362: DEBUG/jdwp(692): Got wake-up signal, bailing out of select
06-08 12:06:06.362: DEBUG/dalvikvm(692): Debugger has detached; object registry had 1 entries
06-08 12:06:07.071: DEBUG/AndroidRuntime(702): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:06:07.071: DEBUG/AndroidRuntime(702): CheckJNI is ON
06-08 12:06:07.932: DEBUG/AndroidRuntime(702): Calling main entry com.android.commands.am.Am
06-08 12:06:07.992: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 702
06-08 12:06:08.011: DEBUG/AndroidRuntime(702): Shutting down VM
06-08 12:06:08.031: DEBUG/dalvikvm(702): GC_CONCURRENT freed 102K, 69% free 319K/1024K, external 0K/0K, paused 1ms+2ms
06-08 12:06:08.031: INFO/AndroidRuntime(702): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:06:08.041: DEBUG/dalvikvm(702): Debugger has detached; object registry had 1 entries
06-08 12:06:15.141: DEBUG/AndroidRuntime(712): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:06:15.141: DEBUG/AndroidRuntime(712): CheckJNI is ON
06-08 12:06:16.041: DEBUG/AndroidRuntime(712): Calling main entry com.android.commands.pm.Pm
06-08 12:06:16.091: DEBUG/AndroidRuntime(712): Shutting down VM
06-08 12:06:16.111: DEBUG/dalvikvm(712): GC_CONCURRENT freed 101K, 71% free 297K/1024K, external 0K/0K, paused 1ms+1ms
06-08 12:06:16.121: INFO/AndroidRuntime(712): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:06:16.121: DEBUG/dalvikvm(712): Debugger has detached; object registry had 1 entries
06-08 12:06:16.832: DEBUG/AndroidRuntime(722): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:06:16.832: DEBUG/AndroidRuntime(722): CheckJNI is ON
06-08 12:06:17.752: DEBUG/AndroidRuntime(722): Calling main entry com.android.commands.am.Am
06-08 12:06:17.812: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 722
06-08 12:06:17.882: DEBUG/AndroidRuntime(722): Shutting down VM
06-08 12:06:17.912: DEBUG/dalvikvm(722): GC_CONCURRENT freed 102K, 69% free 319K/1024K, external 0K/0K, paused 3ms+2ms
06-08 12:06:17.922: INFO/AndroidRuntime(722): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:06:17.932: DEBUG/dalvikvm(722): Debugger has detached; object registry had 1 entries
06-08 12:06:18.152: DEBUG/dalvikvm(659): GC_EXPLICIT freed 147K, 53% free 2578K/5379K, external 1690K/2137K, paused 1198ms
06-08 12:06:18.272: ERROR/Database(659): close() was never explicitly called on database '/data/data/com.testSqlite/databases/planetes.db' 
06-08 12:06:18.272: ERROR/Database(659): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-08 12:06:18.272: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1827)
06-08 12:06:18.272: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:820)
06-08 12:06:18.272: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:854)
06-08 12:06:18.272: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:847)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:541)
06-08 12:06:18.272: ERROR/Database(659):     at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:203)
06-08 12:06:18.272: ERROR/Database(659):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:118)
06-08 12:06:18.272: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.open(PlaneteDbAdaptateur.java:25)
06-08 12:06:18.272: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:15)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:06:18.272: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:06:18.272: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:06:18.272: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:06:18.272: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:06:18.272: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:06:18.272: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:06:18.272: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:06:18.272: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:06:18.482: ERROR/Database(659): close() was never explicitly called on database '/data/data/com.testSqlite/databases/planetes.db' 
06-08 12:06:18.482: ERROR/Database(659): android.database.sqlite.DatabaseObjectNotClosedException: Application did not close the cursor or database object that was opened here
06-08 12:06:18.482: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1827)
06-08 12:06:18.482: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:820)
06-08 12:06:18.482: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:854)
06-08 12:06:18.482: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:847)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ContextImpl.openOrCreateDatabase(ContextImpl.java:541)
06-08 12:06:18.482: ERROR/Database(659):     at android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:203)
06-08 12:06:18.482: ERROR/Database(659):     at android.database.sqlite.SQLiteOpenHelper.getWritableDatabase(SQLiteOpenHelper.java:118)
06-08 12:06:18.482: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.open(PlaneteDbAdaptateur.java:25)
06-08 12:06:18.482: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:15)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:06:18.482: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:06:18.482: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:06:18.482: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:06:18.482: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:06:18.482: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:06:18.482: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:06:18.482: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:06:18.482: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:06:19.001: INFO/Database(659): sqlite returned: error code = 1, msg = table table_planetes has no column named rayon
06-08 12:06:19.041: ERROR/Database(659): Error inserting rayon=200.0 nom=terre
06-08 12:06:19.041: ERROR/Database(659): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
06-08 12:06:19.041: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
06-08 12:06:19.041: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.insertPlanete(PlaneteDbAdaptateur.java:85)
06-08 12:06:19.041: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:19)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:06:19.041: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:06:19.041: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:06:19.041: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:06:19.041: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:06:19.041: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:06:19.041: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:06:19.041: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:06:19.041: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:06:19.442: INFO/ActivityManager(68): Displayed com.testSqlite/.myActivity: +1s584ms
06-08 12:06:20.232: DEBUG/dalvikvm(68): GC_CONCURRENT freed 1648K, 51% free 4358K/8775K, external 5292K/6609K, paused 9ms+9ms
06-08 12:06:24.722: DEBUG/dalvikvm(129): GC_EXPLICIT freed 76K, 50% free 2999K/5959K, external 5033K/6232K, paused 92ms
06-08 12:08:15.892: DEBUG/SntpClient(68): request time failed: java.net.SocketException: Address family not supported by protocol
06-08 12:10:25.372: DEBUG/AndroidRuntime(733): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:10:25.372: DEBUG/AndroidRuntime(733): CheckJNI is ON
06-08 12:10:26.282: DEBUG/AndroidRuntime(733): Calling main entry com.android.commands.pm.Pm
06-08 12:10:26.462: DEBUG/dalvikvm(576): GC_EXPLICIT freed 2K, 54% free 2544K/5511K, external 1625K/2137K, paused 73ms
06-08 12:10:26.472: WARN/ActivityManager(68): No content provider found for: 
06-08 12:10:26.502: WARN/ActivityManager(68): No content provider found for: 
06-08 12:10:26.532: DEBUG/PackageParser(68): Scanning package: /data/app/vmdl118470098.tmp
06-08 12:10:26.692: INFO/PackageManager(68): Removing non-system package:com.testSqlite
06-08 12:10:26.692: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:10:26.791: INFO/Process(68): Sending signal. PID: 659 SIG: 9
06-08 12:10:26.821: ERROR/InputDispatcher(68): channel '40858dd8 com.testSqlite/com.testSqlite.myActivity (server)' ~ Consumer closed input channel or an error occurred.  events=0x8
06-08 12:10:26.821: ERROR/InputDispatcher(68): channel '40858dd8 com.testSqlite/com.testSqlite.myActivity (server)' ~ Channel is unrecoverably broken and will be disposed!
06-08 12:10:26.851: INFO/WindowManager(68): WIN DEATH: Window{40858dd8 com.testSqlite/com.testSqlite.myActivity paused=false}
06-08 12:10:26.992: WARN/InputManagerService(68): Got RemoteException sending setActive(false) notification to pid 659 uid 10042
06-08 12:10:27.532: DEBUG/PackageManager(68): Scanning package com.testSqlite
06-08 12:10:27.532: INFO/PackageManager(68): Package com.testSqlite codePath changed from /data/app/com.testSqlite-1.apk to /data/app/com.testSqlite-2.apk; Retaining data and using new
06-08 12:10:27.552: INFO/PackageManager(68): Unpacking native libraries for /data/app/com.testSqlite-2.apk
06-08 12:10:27.572: DEBUG/installd(35): DexInv: --- BEGIN '/data/app/com.testSqlite-2.apk' ---
06-08 12:10:27.881: DEBUG/dalvikvm(742): DexOpt: load 49ms, verify+opt 45ms
06-08 12:10:27.903: DEBUG/installd(35): DexInv: --- END '/data/app/com.testSqlite-2.apk' (success) ---
06-08 12:10:27.912: WARN/PackageManager(68): Code path for pkg : com.testSqlite changing from /data/app/com.testSqlite-1.apk to /data/app/com.testSqlite-2.apk
06-08 12:10:27.912: WARN/PackageManager(68): Resource path for pkg : com.testSqlite changing from /data/app/com.testSqlite-1.apk to /data/app/com.testSqlite-2.apk
06-08 12:10:27.912: DEBUG/PackageManager(68):   Activities: com.testSqlite.myActivity
06-08 12:10:27.922: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:10:28.122: INFO/installd(35): move /data/dalvik-cache/data@app@com.testSqlite-2.apk@classes.dex -> /data/dalvik-cache/data@app@com.testSqlite-2.apk@classes.dex
06-08 12:10:28.132: DEBUG/PackageManager(68): New package installed in /data/app/com.testSqlite-2.apk
06-08 12:10:28.362: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:10:28.572: DEBUG/dalvikvm(129): GC_EXPLICIT freed 8K, 50% free 2994K/5959K, external 5033K/6232K, paused 198ms
06-08 12:10:28.632: DEBUG/dalvikvm(68): GC_EXPLICIT freed 757K, 51% free 4370K/8775K, external 5292K/6609K, paused 200ms
06-08 12:10:28.902: WARN/RecognitionManagerService(68): no available voice recognition services found
06-08 12:10:29.532: DEBUG/dalvikvm(68): GC_EXPLICIT freed 188K, 51% free 4349K/8775K, external 5292K/6609K, paused 209ms
06-08 12:10:29.582: INFO/installd(35): unlink /data/dalvik-cache/data@app@com.testSqlite-1.apk@classes.dex
06-08 12:10:29.592: DEBUG/AndroidRuntime(733): Shutting down VM
06-08 12:10:29.623: DEBUG/dalvikvm(733): GC_CONCURRENT freed 101K, 72% free 295K/1024K, external 0K/0K, paused 2ms+2ms
06-08 12:10:29.632: INFO/AndroidRuntime(733): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:10:29.642: DEBUG/jdwp(733): Got wake-up signal, bailing out of select
06-08 12:10:29.642: DEBUG/dalvikvm(733): Debugger has detached; object registry had 1 entries
06-08 12:10:30.452: DEBUG/AndroidRuntime(747): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:10:30.463: DEBUG/AndroidRuntime(747): CheckJNI is ON
06-08 12:10:31.412: DEBUG/AndroidRuntime(747): Calling main entry com.android.commands.am.Am
06-08 12:10:31.493: INFO/ActivityManager(68): Force stopping package com.testSqlite uid=10042
06-08 12:10:31.493: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 747
06-08 12:10:31.791: DEBUG/AndroidRuntime(747): Shutting down VM
06-08 12:10:31.857: INFO/ActivityManager(68): Start proc com.testSqlite for activity com.testSqlite/.myActivity: pid=756 uid=10042 gids={}
06-08 12:10:31.892: INFO/AndroidRuntime(747): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:10:32.002: DEBUG/dalvikvm(747): GC_CONCURRENT freed 102K, 69% free 321K/1024K, external 0K/0K, paused 2ms+2ms
06-08 12:10:32.052: DEBUG/jdwp(747): Got wake-up signal, bailing out of select
06-08 12:10:32.052: DEBUG/dalvikvm(747): Debugger has detached; object registry had 1 entries
06-08 12:10:33.102: WARN/ActivityThread(756): Application com.testSqlite is waiting for the debugger on port 8100...
06-08 12:10:33.182: INFO/System.out(756): Sending WAIT chunk
06-08 12:10:33.312: INFO/dalvikvm(756): Debugger is active
06-08 12:10:33.422: INFO/System.out(756): Debugger has connected
06-08 12:10:33.422: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:33.632: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:33.831: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:34.032: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:34.232: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:34.442: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:34.641: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:34.851: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:35.052: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:35.253: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:35.462: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:35.672: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:35.871: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:36.081: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:36.282: INFO/System.out(756): waiting for debugger to settle...
06-08 12:10:36.492: INFO/System.out(756): debugger has settled (1492)
06-08 12:10:37.522: INFO/Database(756): sqlite returned: error code = 1, msg = table table_planetes has no column named rayon
06-08 12:10:37.682: ERROR/Database(756): Error inserting rayon=200.0 nom=terre
06-08 12:10:37.682: ERROR/Database(756): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
06-08 12:10:37.682: ERROR/Database(756):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
06-08 12:10:37.682: ERROR/Database(756):     at com.testSqlite.PlaneteDbAdaptateur.insertPlanete(PlaneteDbAdaptateur.java:85)
06-08 12:10:37.682: ERROR/Database(756):     at com.testSqlite.myActivity.onCreate(myActivity.java:19)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:10:37.682: ERROR/Database(756):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:10:37.682: ERROR/Database(756):     at android.os.Looper.loop(Looper.java:123)
06-08 12:10:37.682: ERROR/Database(756):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:10:37.682: ERROR/Database(756):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:10:37.682: ERROR/Database(756):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:10:37.682: ERROR/Database(756):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:10:37.682: ERROR/Database(756):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:10:37.682: ERROR/Database(756):     at dalvik.system.NativeStart.main(Native Method)
06-08 12:10:38.502: INFO/ActivityManager(68): Displayed com.testSqlite/.myActivity: +6s726ms
06-08 12:10:43.962: DEBUG/dalvikvm(576): GC_EXPLICIT freed 6K, 54% free 2543K/5511K, external 1625K/2137K, paused 61ms
06-08 12:10:49.042: DEBUG/dalvikvm(588): GC_EXPLICIT freed 3K, 55% free 2534K/5511K, external 1625K/2137K, paused 115ms
06-08 12:10:54.012: DEBUG/dalvikvm(596): GC_EXPLICIT freed 9K, 55% free 2592K/5703K, external 1625K/2137K, paused 63ms
06-08 12:10:59.112: DEBUG/dalvikvm(129): GC_EXPLICIT freed 132K, 50% free 3016K/5959K, external 5082K/6232K, paused 162ms
06-08 12:11:11.382: DEBUG/AndroidRuntime(766): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:11:11.382: DEBUG/AndroidRuntime(766): CheckJNI is ON
06-08 12:11:12.392: DEBUG/AndroidRuntime(766): Calling main entry com.android.commands.pm.Pm
06-08 12:11:12.452: DEBUG/AndroidRuntime(766): Shutting down VM
06-08 12:11:12.462: DEBUG/dalvikvm(766): GC_CONCURRENT freed 101K, 71% free 297K/1024K, external 0K/0K, paused 1ms+2ms
06-08 12:11:12.472: INFO/AndroidRuntime(766): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:11:12.482: DEBUG/dalvikvm(766): Debugger has detached; object registry had 1 entries
06-08 12:11:13.192: DEBUG/AndroidRuntime(776): >>>>>> AndroidRuntime START com.android.internal.os.RuntimeInit <<<<<<
06-08 12:11:13.192: DEBUG/AndroidRuntime(776): CheckJNI is ON
06-08 12:11:14.162: DEBUG/AndroidRuntime(776): Calling main entry com.android.commands.am.Am
06-08 12:11:14.212: INFO/ActivityManager(68): Starting: Intent { act=android.intent.action.MAIN cat=[android.intent.category.LAUNCHER] flg=0x10000000 cmp=com.testSqlite/.myActivity } from pid 776
06-08 12:11:14.232: DEBUG/AndroidRuntime(776): Shutting down VM
06-08 12:11:14.252: DEBUG/dalvikvm(776): GC_CONCURRENT freed 102K, 69% free 319K/1024K, external 0K/0K, paused 2ms+3ms
06-08 12:11:14.252: INFO/AndroidRuntime(776): NOTE: attach of thread 'Binder Thread #3' failed
06-08 12:11:14.262: DEBUG/dalvikvm(776): Debugger has detached; object registry had 1 entries
06-08 12:13:15.902: DEBUG/SntpClient(68): request time failed: java.net.SocketException: Address family not supported by protocol

j'ai enlevé la colonne id mais ça fait la mem chose.

L'erreur semble être spécifié ici dans le logcat :

Code:

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
06-08 12:03:49.692: ERROR/Database(659): Error inserting rayon=200.0 nom=terre
06-08 12:03:49.692: ERROR/Database(659): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.native_compile(Native Method)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteCompiledSql.compile(SQLiteCompiledSql.java:92)
06-08 12:03:49.692: ERROR/Database(659): at android.database.sqlite.SQLiteCompiledSql.<init>(SQLiteCompiledSql.java:65)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteProgram.<init>(SQLiteProgram.java:83)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteStatement.<init>(SQLiteStatement.java:41)
06-08 12:03:49.692: ERROR/Database(659): at android.database.sqlite.SQLiteDatabase.compileStatement(SQLiteDatabase.java:1149)
06-08 12:03:49.692: ERROR/Database(659): at android.database.sqlite.SQLiteDatabase.insertWithOnConflict(SQLiteDatabase.java:1549)
06-08 12:03:49.692: ERROR/Database(659):     at android.database.sqlite.SQLiteDatabase.insert(SQLiteDatabase.java:1422)
06-08 12:03:49.692: ERROR/Database(659):     at com.testSqlite.PlaneteDbAdaptateur.insertPlanete(PlaneteDbAdaptateur.java:85)
06-08 12:03:49.692: ERROR/Database(659):     at com.testSqlite.myActivity.onCreate(myActivity.java:19)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1047)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.performLaunchActivity(ActivityThread.java:1586)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:1638)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.access$1500(ActivityThread.java:117)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread$H.handleMessage(ActivityThread.java:928)
06-08 12:03:49.692: ERROR/Database(659):     at android.os.Handler.dispatchMessage(Handler.java:99)
06-08 12:03:49.692: ERROR/Database(659):     at android.os.Looper.loop(Looper.java:123)
06-08 12:03:49.692: ERROR/Database(659):     at android.app.ActivityThread.main(ActivityThread.java:3647)
06-08 12:03:49.692: ERROR/Database(659):     at java.lang.reflect.Method.invokeNative(Native Method)
06-08 12:03:49.692: ERROR/Database(659):     at java.lang.reflect.Method.invoke(Method.java:507)
06-08 12:03:49.692: ERROR/Database(659):     at com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:839)
06-08 12:03:49.692: ERROR/Database(659):     at com.android.internal.os.ZygoteInit.main(ZygoteInit.java:597)
06-08 12:03:49.692: ERROR/Database(659):     at dalvik.system.NativeStart.main(Native Method)

Code:

1
2
06-08 12:21:09.652: ERROR/Database(872): Error inserting rayon=200.0 nom=terre
06-08 12:21:09.652: ERROR/Database(872): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);

voila une erreur qui m'etre utile je sais pas si quelqu'un le connait

Bonjour,

C'est expliqué dans le log

Citation:

ERROR/Database(872): android.database.sqlite.SQLiteException: table table_planetes has no column named rayon: , while compiling: INSERT INTO table_planetes(rayon, nom) VALUES(?, ?);

table_planetes has no column named rayon.

Si j'ai bien compris c'est la requete de creation de la table table_planetes qui n'est pas bonne.
J'ai essayé ceci
db.execSQL("create table table_planetes(id integer primary key autoincrement, nom text not null, rayon float not null);");

mais c'est le meme resultat que ça donne.

Bizarre, la seule erreur visible c'est le valeurs.put("COLONNE_ID", 1); qui est passé en tant que chaine en plus.

Sinon le code devrait fonctionner.

Le logcat date de 12:00 normal ?

je le trouve aussi bizarre. j'ai l'impression que le logcat ne me donne pas l'heure exacte et je sais pas pourquoi.
Sinon j'ai trouvé une autre solution. aprés avoir testé que l'ouverture de la base de données est effective et que le probleme se trouvait sur la methode insert, j'ai utilisé la methode execSql pour faire l'insertion autrement dit j'ai modifié la méthode insert comme ci dessous.
Code:

1 2 3 4 5 6 7 8 9 10 11 12 13 public void insertPlanete(Planete planete){ // ContentValues valeurs=new ContentValues(); // valeurs.put(COLONNE_NOM, planete.getNom()); // valeurs.put(COLONNE_RAYON, planete.getRayon()); // return maBaseDeDonnees.insert(TABLE_NAME, null, valeurs); ArrayList<Planete> mesPlanetes=getAllPlanete(); Planete pl=mesPlanetes.get(mesPlanetes.size()-1); int id=pl.getId()+1; String nom=planete.getNom(); float rayon=planete.getRayon(); getMaBaseDeDonnees().execSQL("insert into table_planetes values("+id+", \""+nom+ "\", "+rayon+ ");"); }
j'ai géré moi meme l'incrementation des id. et ça marche bien.
Merci beaucoup à vous qui avez essayé de m'aider.

Le fait que ça marche pas me parraisait bizarre résultat j'ai exécuté le code du premier message en retirant "valeurs.put("COLONNE_ID", 1);" et ça marche. Donc bizarre.

Sinon la méthode utilisé dans le dernier message, c'est pas tellement propre, ça passe bien sur une petite base, mais sur une grosse, ça va faire beaucoup d'objet en mémoire pour pas grand chose (l'utilisation d'un count aurait été plus judicieuse).

Sinon autre remarques pourquoi ne pas mettre les constantes décrivant la table en public et les utiliser dans les classes nécessaires (ça évite la duplication de code et d'avoir des classes contenants des choses inutiles).

merci pour les remarques. Moi meme ça me parait bizarre que ça ne marche pas.
Mais bon si j'utilise la requete standard et que ça marche, je peux m'en contenter d'autant plus que c'est pour une petite application.