How can I emulate an onUpgrade call for my SQLiteOpenHelper class? I have tried changing the version number in my SQLiteOpenHelper class and versionCode in manifest but onUpgrade is not called. Any idea? I need to check my onUpgrade code before upload it to the market, I don't want my app's users get a buggy upgrade.
View 10 Replies
I get a SQLiteException if I try to issue an alter statement in the onUpgrade method of SQLiteOpenHelper subclass:
Can't upgrade read-only database from version X to Y: /path/to/db
That makes no sense at all! Where did I go wrong?
I am doing my first app with a database and I am having a little trouble understanding the onUpgrade function. My database has a table with an items and a favorite column so that the user can favorite an item. Most implementations I see simply drop the table and reconstruct it but I don't want to do this. I want to be able to add more items to the table.
When the app is upgraded through the android marketplace does the database know its version number? So could I increment the version number in the code and then export it to the marketplace and when the user boots up the upgraded version for the first time then onUpgrade will be called?
If this is the case my onUpgrade would simply pull from a file and add the database items in. Is this a standard way of doing things or is there a better way of handling this in Android. I am trying to stay as standard as possible.
Every time i increase my database version and push the upgraded app to the users, something weird happens.. For some it works perfectly fine, and some report crashes (including through the Market's reporting system) caused by the lack of table columns i just added in onUpgrade.
If you want to see the method:
http://code.google.com/p/tag-todo-list/source/browse/trunk/Donut/src/com/android/todo/data/ToDoDB.java#136
I can't spot any exceptions that appear in onUpgrade. What i'm currently doing to bypass these problems is intercepting the exceptions where the new fields are invoked for the first time and then calling onUpgrade 'manually', which is kind of dirty.
Also, the app sometimes generates a 'no such table' SQLiteException when accessing the main table (again, only for some users) which is incredibly strange... Does someone know why these things happen? Or can you spot something wrong in my code?
How can i call the onUpgrade Method of the database? Background of my question: I do a backup on the sdcard of the full database. And the user can restore this database. But if in the meantime (between backup and restore) an app update has made changes to the database i get a problem on restoring. The new columns are not there after restoring. So i want to call the onUpgrade method to add all new/changed columns. Or is there a better way for this?
View 1 Replies View RelatedIs the onUpgrade method of SQLiteOpenHelper ever called? If so, when is it called and by what? Or if it is not called by developers, then why is it there? What should be done in the method I have seen examples where it drops all the tables, but then a comment says that dropping all the tables is NOT what you should do.
View 1 Replies View RelatedDo I need an instance of my SQLiteOpenHelper class for each Activity I have? I have 1 currently that all activities access, but started getting an exception
"illegal state exception SQLiteDatabase created and never closed "
on simple a simple query and I can't seem to figure out why this is happening. I read online about this, and wanted to try to understand why the SQLiteOpenHelper was dependent on an Activity.
Is there a way to just have open SQLiteDatabase object without the Helper and have it just exist within all activities?
I would like to know if it is possible to have several DbOpenHelper in the same app Android but to use them to write and read in the same database? because I'm trying to create tables from 2 different OpenHelper (with different names) and only the first one seems to create. when I try to run the 2nd one, i get an error...
View 1 Replies View RelatedI have a SQLite database, and several tables within that datbase. I am developing a DBAdapter for each table within the database. (reference Reto Meier's Professional Android 2 Application Development, Listing 7.1).
I am using the adb shell to interface with the database from the command line and see that the database is being populated as I expect. Occasionally, I want to drop a table so that I can ensure it's being built properly, from scratch.
The problem is that SQLiteOpenHelper only checks to see if the database exists. Is there a typical solution to writing a helper to also see that the table(s) exists? Basically once I drop a table, the helper checks to see that the database exists and assumes all is well.
Also, the CREATE_DATABASE string used in the reference above only creates the one table. Should I consider using the DBAdapter for an adapter to ALL of my tables? That doesn't seem as clean to me.
The documentation does not make the interation between onUpgrade() and onCreate() clear.
When implementing onCreate() should this create the database at version 1, assuming that onUpgrade will apply all of the patches to bring it up to version x (lets say version 5 for example)? Or should onCreate build the latest version of the database, and onUpgrade is only used to upgrade legacy clients.
I kind of prefer the first, because it effectively means that the same SQL is executed for everybody. Whereas the second options means that there is a potential for onCreate to build something slightly different to the succession of patches built by onUpgrade.
I can always make onCreate call into onUpgrade, however, this is the kind of implementation detail that should go into the javadocs...
If you extend SQLiteOpenHelper, for the Constructor you have to use a Context. I am wondering if there is a way to leave this out, and be able to work with database tables without a Context.
Or at least be least restrictive, I mean a way of project/class structure that will make history the several context passings I have to do now.
As it is my application has several level of classes, chained in each other, and there are a few that connects to the database, but have no whatsoever influence on the interface, so they don't actually need the Context.
Are you creating your classes in the way that you pass each time a Context to them?
If not, how you do, how you reuse a Context in a short class?
The documentation describes the class as a helper object to create, open, and/or manage a database. Having that in mind wouldn't you say that the name is a little misleading?
View 2 Replies View RelatedI have an existing SQLite database file from another project.
Where do I include the database file into my Eclipse project to have it deploy with the app.
Do I need to indicate that the database file is writable? (In the iPhone world you need to copy the database file from the app's bundle to a writable folder on the iPhone proper before first use.)
Once I have the database file on the phone, how do I tell SQLiteOpenHelper to use it? (I extend SQLiteOpenHelper in a custom class.
I'm trying to implement a database in my application. I'm following a tutorial about writing my own ContentProvider, but I'm confused about SQLiteOpenHelper::getType. We're supposed to write it and, essentially, write a switch that returns the MIME type corresponding to the type of data we're dealing with.
I don't fully understand it. I'm not sure, even though I have an example, what is precisely supposed to be conveyed here. How do I determine the MIME type of my different tables of data?
I have two classes, one MainClass and one DataBaseHelper class, which extends SQLiteOpenHelper.
From my MainClass I call a method in the DataBaseHelper class to open a data base. Before opening the data base I want to check the users data base version (this is important as soon as I want to update the data base and push it to the Android market). So from the DataBaseHelper class I call the following method, which is in the MainClass.
CODE:..........
I call the checkCurrentDbVersion() method from the DataBaseHelper class like so:
CODE:.....................
As soon as the debugger runs the following line, it stops.
CODE:...........
I have no constructor defined. Could that be the failure?
I've had fine luck using SQLite with straight, direct SQL in Android, but this is the first time I'm wrapping a DB in a ContentProvider. I keep getting a null pointer exception when calling getWritableDatabase() or getReadableDatabase().
Is this just a stupid mistake I've made with initializations in my code or is there a bigger issue?
CODE:.........
But here's LogCat showing the exception:
I like title bar style in android preference category. In my activity (no preferenceactivity) I want to use same style, how I can do?
View 1 Replies View RelatedI program and test using the Droid Incredible. The other day my friend downloaded my alpha version, which works flawlessly on the Incredible, but crashed on his Moto Droid. I just updated my app to use 2.1 api's instead of 1.6; maybe this will make a difference? I upped my min version requirements to 7. My question is how can you make sure your app works on all phones and not just the phone your are building and testing on? Is there a way to emulate a particular device?
View 3 Replies View RelatedI want emulate my current android system of my phone.I want have full duplicate system of my current phone (i mean filesprogramms etc) at PC with possible to use it (things like 2-step auth of google, and others).I think the way to do it is restore image of system that can do ClockWorkMod. But i dosnt know how use it on emulator on my Win7.
View 3 Replies View RelatedI made my simple, custom rows and listviews. Right now, only clicking on the text of the row is valid selection area. I want the entire row, even the no-text area to be selectable. Where do I modify? Am I looking for focusing or selecting?...................
View 5 Replies View RelatedMy home security system allows me to view the cameras from a browser. But, it only works from an internet explorer browser. (Even on my pc, I have to use IE for this, it won't work with fire fox or chrome). None of the ip camera apps available so far work with my q-see camera system. Is there any way to "emulate" internet explorer on the android?. I don't anticipate microsoft will be making an android-version anytime soon.
View 11 Replies View RelatedI want to get longitude and latitude in android emulator for testing.
Can any one guide me how to achieve this?
How do I set the location of the emulator to a test position?
I am having few android rom backup's from my old Xperia Arc S, Wilfire, Galaxy S. All were rooted and saved their nandroid backup.The need of hour is to retrieve some data out of the Roms. But I am not having any device at the moment.So the thing I wished to do is to emulate those roms and run them on PC.
View 5 Replies View RelatedI want to decrypt this xml file:
23.239.111.10 / videoChannel.xml
i don't know if it is encrypted or compressed. i know that i have an apk that does the decryption of the file.
I am trying to use the android dev emulator to create a virtual phone with the same spec as the droid. I am using the WVGA 854 profile, High density (240) and scaling the emulator screen to 3.7 inch on launch. Problem is it seems to be emulating it like it has WVGA 854 resolution but with a medium or low density screen, as the icons are teeny tiny and the whole thing looks wrong. I'm sure the droid does have teeny tiny icons and apps, can anyone tell me where i am going wrong?
View 1 Replies View RelatedIs it possible to emulate Linux on android, then install wine on it and run Windows programs?
View 2 Replies View RelatedIs there any way to emulate an android froyo with normal kernel and everything a normal android phone has? Including a market and recovery mode. I want this mainly because I feel terrified by the thought that I might brick my phone flashing a custom rom and I am a beginner so I never tried anything complicated with it. So before I try anything over my phone I want to try this on an emulated phone.
View 9 Replies View RelatedI have a TabActivity with several tabs. Each tab corresponds to a specific view, and those views may further switch to other views. For example, one of my tabs displays RSS feed list, after user clicks one of the RSS feed, it will switch to a view displaying a list of articles, and after user clicks one of the titles, a full article view will be displayed.I'm going to add support for "back" button in my application. For instance, in a full article view, after user presses the "back" button, it should switch back to the article list view. And if user presses it the "back" button again, my application should switch back to the feed list view.My idea is to maintain a Stack<View> during navigation, and every time user presses the "back" button, the program will pop a View out of the stack, and set it as the current view. But I would like to know how to set current view in TabHost.
View 1 Replies View RelatedI looked around and although there are many related questions I didn't see one that answers my exact question:
I would like to create an app that runs in the background that provides the exact same functionality as the hard coded 'Back' button in all cases.
The reason? I (for example) have a Droid X, and it is BIG. it makes it extremely hard to use one-handed and having a swipe gesture function as a back button (like in Palm Pre for example) would greatly increase the ease of use.
as far as I'm concerned the app could just be one simple class that contains:
1) a listener for the 'back' swipe
2) a call to the physical hard button itself
Is this possible? are there built in APIs for the hard coded buttons that would allow me to call them without actually pressing them?
Again - I'm not interested in overriding the button, I'm interested in making a software call to it - or failing that, in emulating it's behavior in any and all states and other apps!
Please forgive the naivete of this post. I am a very novice programmer and really I just want to know whether this is possible before I start to devote myself to trying to build it.
How to emulate a custom ROM on SDK FOR testing ROM
Galaxy Nexus