go to File explorer there
data \data \package name here Databases folder in this folder databases we can see On Wed, Sep 2, 2009 at 12:55 PM, Bharath B.G. <[email protected]>wrote: > yup, its working, thank u thank u powerbyte > > hey also tell me how to wipe out the data, i mean to clear the tables etc > tell mw where exactly the database files gonna store > > Regards, > Bharath BG > > > On Wed, Sep 2, 2009 at 10:24 AM, powerbyte <[email protected]> wrote: > >> >> add moveToFirst() after >> Cursor c=db.query(DATABASE_TABLE, new String[] { COL_ID,COL_NAME}, >> null, >> null, null, null, null); >> >> c.moveToFirst(); >> >> and before closing db.close() >> also close Cursor c.close(); >> >> >> >> On Sep 2, 9:17 am, "Bharath B.G." <[email protected]> wrote: >> > *Here is the logcat, i got this when i changed the table name n hence >> > created a new table >> > also tell me how to wipe out the data from the database so that i can >> clear >> > all the tables* >> > >> > 09-02 09:41:51.778: ERROR/Database(710): Leak found >> > 09-02 09:41:51.778: ERROR/Database(710): >> java.lang.IllegalStateException: >> > /data/data/com.android/databases/myDatabse.db SQLiteDatabase created and >> > never closed >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1580) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:638) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:659) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:652) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:463) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:181) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > com.android.DatabaseWork.tryThis(DatabaseWork.java:35) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > com.android.DatabaseWork.onCreate(DatabaseWork.java:21) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1123) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.app.ActivityThread.access$1800(ActivityThread.java:112) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.os.Handler.dispatchMessage(Handler.java:99) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.os.Looper.loop(Looper.java:123) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > android.app.ActivityThread.main(ActivityThread.java:3948) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > java.lang.reflect.Method.invokeNative(Native Method) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > java.lang.reflect.Method.invoke(Method.java:521) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > >> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:782) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540) >> > 09-02 09:41:51.778: ERROR/Database(710): at >> > dalvik.system.NativeStart.main(Native Method) >> > 09-02 09:41:51.878: ERROR/Database(710): Leak found >> > 09-02 09:41:51.878: ERROR/Database(710): >> java.lang.IllegalStateException: >> > /data/data/com.android/databases/myDatabse.db SQLiteDatabase created and >> > never closed >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.database.sqlite.SQLiteDatabase.<init>(SQLiteDatabase.java:1580) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openDatabase(SQLiteDatabase.java:638) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:659) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.database.sqlite.SQLiteDatabase.openOrCreateDatabase(SQLiteDatabase.java:652) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.app.ApplicationContext.openOrCreateDatabase(ApplicationContext.java:463) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.content.ContextWrapper.openOrCreateDatabase(ContextWrapper.java:181) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > com.android.DatabaseWork.tryThis(DatabaseWork.java:35) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > com.android.DatabaseWork.onCreate(DatabaseWork.java:21) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.app.Instrumentation.callActivityOnCreate(Instrumentation.java:1123) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.app.ActivityThread.performLaunchActivity(ActivityThread.java:2231) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> android.app.ActivityThread.handleLaunchActivity(ActivityThread.java:2284) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.app.ActivityThread.access$1800(ActivityThread.java:112) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.app.ActivityThread$H.handleMessage(ActivityThread.java:1692) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.os.Handler.dispatchMessage(Handler.java:99) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.os.Looper.loop(Looper.java:123) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > android.app.ActivityThread.main(ActivityThread.java:3948) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > java.lang.reflect.Method.invokeNative(Native Method) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > java.lang.reflect.Method.invoke(Method.java:521) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > >> com.android.internal.os.ZygoteInit$MethodAndArgsCaller.run(ZygoteInit.java:782) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > com.android.internal.os.ZygoteInit.main(ZygoteInit.java:540) >> > 09-02 09:41:51.878: ERROR/Database(710): at >> > dalvik.system.NativeStart.main(Native Method) >> > >> > On Wed, Sep 2, 2009 at 9:41 AM, Bharath B.G. <[email protected] >> >wrote: >> > >> > >> > >> > >> > >> > > Hi, >> > >> > > i put the code inside the try catch block and the error is bcoz of >> > > tables(there may be other errors too but first i hav to remove this >> error) >> > > now my question is where exactly is the database files, where they get >> > > stored...? in workspace or system32 folder or where...? bcoz i couldnt >> find >> > > the files anywhere, and how can i completely delete all the tables, so >> that >> > > i can create the database from the start >> > >> > > regards >> > > Bharath BG >> > >> > > On Tue, Sep 1, 2009 at 6:01 PM, leonardo. < >> [email protected]>wrote: >> > >> > >> You can put a >> > >> try { >> > >> db.execSQL("create table myTable (id integer primary key, name text >> not >> > >> null);"); >> > >> } catch(Exception e) {} >> > >> > >> to try to see the error?? >> > >> > >> 2009/9/1 Bharath B.G. <[email protected]> >> > >> > >> Hi, I am very new to SQLite, i referred some books regarding coding >> in >> > >>> SQLite n went straight for coding >> > >> > >>> But while i run my simple code i am getting error "the application >> has >> > >>> stopped unexpectadly" (particularly in the line create table) >> > >> > >>> please tell me where exactly is the error n where i hav to modify >> the >> > >>> code >> > >> > >>> package com.android; >> > >> > >>> import android.app.Activity; >> > >>> import android.content.Context; >> > >>> import android.database.Cursor; >> > >>> import android.database.sqlite.SQLiteDatabase; >> > >>> import android.os.Bundle; >> > >>> import android.widget.EditText; >> > >> > >>> public class DatabaseWork extends Activity { >> > >> > >>> private EditText et; >> > >> > >>> public void onCreate(Bundle icicle) { >> > >>> super.onCreate(icicle); >> > >> > >>> setContentView(R.layout.main); >> > >>> et=(EditText)findViewById(R.id.EditText01); >> > >> > >>> tryThis(); >> > >>> } >> > >> > >>> public void tryThis() >> > >>> { >> > >>> final String DATABASE_NAME="myDatabse.db"; >> > >>> final String DATABASE_TABLE="myTable"; >> > >>> final int DATABASE_VERSION=1; >> > >> > >>> final String COL_NAME="name"; >> > >>> final String COL_ID="id"; >> > >> > >>> SQLiteDatabase db; >> > >> > >>> db=openOrCreateDatabase(DATABASE_NAME, 0, null); >> > >>> db.execSQL("create table myTable (id integer primary key, name text >> not >> > >>> null);"); >> > >> > >>> db.execSQL("insert into myTable values (1, \"Bharath\");"); >> > >>> db.execSQL("insert into myTable values (2, \"Abhijith\");"); >> > >> > >>> Cursor c=db.query(DATABASE_TABLE, new String[] { COL_ID,COL_NAME}, >> null, >> > >>> null, null, null, null); >> > >> > >>> int idCol=c.getColumnIndex(COL_ID); >> > >>> int nameCol=c.getColumnIndex(COL_NAME); >> > >> > >>> String s=null; >> > >> > >>> while(true) >> > >>> { >> > >>> String name=c.getString(nameCol); >> > >>> s=s+" "+name; >> > >>> if(c.isLast()) >> > >>> { >> > >>> break; >> > >>> } >> > >>> c.moveToNext(); >> > >>> } >> > >> > >>> et.setText(s); >> > >> > >>> db.close(); >> > >>> } >> > >>> } >> > >> > >>> -- >> > >>> Bharath B.G. >> > >> > >> -- >> > >> Leonardo Ribeiro >> > >> Desenvolvedor Java - iFactory Solutions >> > >> SCJP 1.5 >> > >> > > -- >> > > Bharath B.G. >> > >> > -- >> > Bharath B.G.- Hide quoted text - >> > >> > - Show quoted text - >> >> > > > -- > Bharath B.G. > > > > > -- Regards ------------------- Desu Vinod Kumar [email protected] 09176147148 --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "Android Developers" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/android-developers?hl=en -~----------~----~----~----~------~----~------~--~---
