SQLiteOpenHelper problem

Posted by Harsha M V on Stack Overflow See other posts from Stack Overflow or by Harsha M V
Published on 2010-12-24T10:46:55Z Indexed on 2010/12/25 6:54 UTC
Read the original article Hit count: 160

Filed under:

android

|

sqlite

|

sqlite3

I have created SQLiteOpenHelper class to help me open write the database. but i am not able to invoke it from the main.java activity

I have created an Class which extends the Database Helper which is stored at

/Messaging/src/com/v3/messaging/DatabaseHelper.java

Code: http://pastebin.com/Z5qp32xu

now i have this class called Main.java which will be the first activity on the launch of the application. But how can i make the DatabaseHelper.java run just to create the database but still be at the Main.java file.

The database should be created with the tables only when the db or the tables dont exist.

Main.java code: http://pastebin.com/LVFVuhA0

Now when i run the program. the database is not being created :(

I am trying to learn Android. So please excuse me if i forgot to tell something.

© Stack Overflow or respective owner

Related posts about android

Please verify my layout: bottom button keeps coming up over keyboard

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi everyone, I have a layout which does almost what I want. There's just one bug regarding the button at the bottom. I should stay at the bottom at all times. But whenever I bring up the soft-keyboard the button will be displayed above the keyboard. This is not what I want but it should become covered… >>> More
Android programming. Application stopped unexpectedly.

as seen on Stack Overflow - Search for 'Stack Overflow'
I've just created a prototype of interface for my android app and tried to run it. Unfortunately I get an error that my app has stopped unexpectedly (my reputation doesn't allow me to post images so follow my links): screenshot of error message This is layout mode of editing. Everything looks as… >>> More
Listview Row Overlap Problem

as seen on Stack Overflow - Search for 'Stack Overflow'
I just updated my app and I am getting some odd complaints from people who update it. I am only getting complaints from people with non-stock android phones (phones that manufacturers have modified...HTC phones, cliq, pulse, etc), other phones like the Droid, Nexus work fine. My app (Photo Frame Deluxe)… >>> More
Why are some of my view not aligned correctly at the bottom of my relative layout?

as seen on Stack Overflow - Search for 'Stack Overflow'
I have problems getting some of my views aligned in a relative layout that I use inside a row of my listview. Here is a screenshot from the layout builder in Eclipse, this is what I think it should look like: The next image is from the emulator. Now the TestTestTest View is at the top and covers… >>> More
Android RatingBar weirdness: Whenever I add a RatingBar to my layout, a bunch of the generated tags,

as seen on Stack Overflow - Search for 'Stack Overflow'
Whenever I use a RatingBar view in my layout, I suddenly get all kinds of compile errors. I'm using Android 2.0, but I've also tried 2.0.1, and 2.1, without joy. I also get a message: Shader 'android.graphics.BitmapShader' is not supported in Layout Editor, and an odd warning which may or maynot be… >>> More

Related posts about sqlite

How to add SQLite (SQLite.NET) to my C# project

as seen on Stack Overflow - Search for 'Stack Overflow'
I followed the instructions in the documentation: Scenario 1: Version Independent (does not use the Global Assembly Cache) This method allows you to drop any new version of the System.Data.SQLite.DLL into your application's folder and use it without any code modifications or recompiling… >>> More
dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite

as seen on Stack Overflow - Search for 'Stack Overflow'
Which is the better choice out of dotConnect or "sqlite.phxsoftware.com" for using Entity Framework with SQLite (in C#)? >>> More
SQLite table does not exist exception for existing SQLite database (and table)

as seen on Stack Overflow - Search for 'Stack Overflow'
I've followed the instructions given here for introducing an existing SQLite database to your Android app. When I query the table "android_metadata" this is fine. But when I run a similar query on my own table "words" (which has _id for primary integer key) I get a table does not exist exception… >>> More
Android Jelly bean database is locked (code 5)

as seen on Stack Overflow - Search for 'Stack Overflow'
Im getting a database is locked (code 5) in my ListActivity the code works in the other versions of the Emulator but fails in the 4.1 version of the emulator E/SQLiteLog( 2132): (5) database is locked E/SQLiteDatabase( 2132): Failed to open database '/data/data/id.online.mydroid/databases/geo… >>> More
Android:accessing assets folder sqlite databse file with .sqlite extension

as seen on Stack Overflow - Search for 'Stack Overflow'
How to read data from the assets folder sqlite database file with .sqlite extension in my android application? Thanks >>> More