SQLite database problem

totw · by **totw** » Tue Mar 31, 2009 11:00 am

I'm trying to create a database for our application with class name DataBaseWork with code :

Syntax: [ Download ] [ Hide ]

Using java Syntax Highlighting

public class DataBaseWork extends ListActivity {
 
        public static final String MY_DATABASE_NAME = "ActivityLog";
 
        public static final String MY_DATABASE_TABLE = "logtable";
 
        public static SQLiteDatabase myDB = null;
 
        /** Called when the activity is first created. */
 
    DataBaseWork(){
 
         try{
 
                 this.createDatabase(MY_DATABASE_NAME, 1, MODE_PRIVATE, null);
 
                 myDB = this.openDatabase(MY_DATABASE_NAME, null);
 
                 myDB.execSQL("CREATE TABLE IF NOT EXISTS "
 
                        + MY_DATABASE_TABLE
 
                        + " (Date VARCHAR, serverIP VARCHAR ;");
 
         } catch (FileNotFoundException e) {
 
         }
 
    }
 
    public void addentry(String servIP)
 
    {
 
        Date d = new Date();
 
        String cdate = new String(d.toString());
 
        myDB.execSQL("INSERT INTO "
 
                + MY_DATABASE_TABLE
 
                + " (Date, serverIP)"
 
                + " VALUES (cdate, servIP);");
 
    }
 
}
 
Parsed in 0.034 seconds,  using GeSHi 1.0.8.4

I tried to create an object of the above class in java file main as follows :

DataBaseWork dbw;
dbw = new DataBaseWork();

I'm getting the following error :
unable to start activity ComponentInfo{tel.net.client/tel.net.client.Main}:
java.lang.RuntimeException : not supported in system context.

I am sure that this error is because of the database work because after removing that piece of code the program works fine.

PS: I'm using the very first android SDK (m3r20a) and finding it convenient to use the same rather than upgrading to the latest version.

stifry · by **stifry** » Wed Apr 01, 2009 6:10 pm

You will want to do this in the onCreate(). Android Activity classes don't use constructors to initialize. You might want to check out the Activity lifecycle:

Activity Lifecycle

onCreate() Called when the activity is first created. This is where you should do all of your normal static set up: create views, bind data to lists, etc. This method also provides you with a Bundle containing the activity's previously frozen state, if there was one.

Always followed by onStart().

WarrenFaith · by **WarrenFaith** » Thu Apr 02, 2009 12:01 pm

Well I doubt that an Activity is the place to handle SQLite... Check out the notepad tutorial for more information.
:arrow:

http://www.anddev.org/viewtopic.php?p=20070#20070
I posted the main classes to handle database access (fully inspired by notepad)

totw · by **totw** » Thu Apr 02, 2009 3:47 pm

stifry wrote:You will want to do this in the onCreate(). Android Activity classes don't use constructors to initialize. You might want to check out the Activity lifecycle:

Activity Lifecycle

onCreate() Called when the activity is first created. This is where you should do all of your normal static set up: create views, bind data to lists, etc. This method also provides you with a Bundle containing the activity's previously frozen state, if there was one.

Always followed by onStart().

Thanx a lot.
your solution worked.

SQLite database problem

SQLite database problem

Who is online