[Problem clarified]
To update an SQL database you need write permissions on the /database
file folder that holds the database, but these permissions are set to
drwxrwx--x. If the application using the database falls in the
"other" category (i.e. not the owner application or its "group), then
it does not have write permissions and cannot update the SQL
database. This was verifed by changing the described permissions to
drwxrwxrwx which fixes the problem.
Jim
On Mar 1, 11:27 pm, gymshoe <gyms...@bresnan.net> wrote:
> 1) I am developing my app inEclipse3.4.1 with Android (ver 1.1_r1)
> plugin. My app compiles and executes without errors when using theEclipseIDE.
>
> However, when Iexportmy app (unsigned) usingEclipse(via {select
> project} >right-click>Android tools>exportunsigned application
> package), sign it, and try to run it on the Emulator, it throws a
> runtime error when I try to update my sqlite database, at which time
> the specific error created is: SQLite error#14, unable to open
> database. It is able to read from the database without problems. (I
> have also verified that the database is: open, is not readonly, is not
> locked by another thread, is not in the middle of a transaction.)
>
> I have limited experience, but this seems more like a "system" problem
> given that the app works OK inEclipseIDE but then fails as an
> exported/signed apk. Some googling of SQLite resources revealed a
> similar error on a non-Android platform which was fixed by:
> "Set your permissions correctly on /var/tmp, or whatever directory you
> are using to hold temporary files".
>
> Does Android have temporary files, and if so how does it handle
> permissions on temporary files? Is there a way to check or set these
> permissions to see if this fixes my problem here?
>
> 2) Not sure if it is related, but after I have run the exported/signed
> app which causes the runtime error, if I reboot the Emulator, and try
> to run the program using theEclipseIDE , the program fails with the
> same exact error.
> PLUS I also noticed the following error message while the program is
> installing/running:
> 03-01 22:22:29.282: ERROR/PackageManager(53): Package
> com.northwestradiology has mismatched uid: 0 on disk, 10019 in
> settings; read messages:
>
> I can restore theEclipseversion of my program to be able to execute
> without runtime errors by utilizing the -wipe-data option for the
> emulator. But note that if I run my signed APK using an emulator
> created with the -wipe-data
> option, it still throws the runtime error listed above...
>
> Does anybody have any ideas about what is going on and how to fix it?
>
> Thanks,
> Jim
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google
Groups "Android Developers" group.
To post to this group, send email to android-developers@googlegroups.com
To unsubscribe from this group, send email to
android-developers-unsubscr...@googlegroups.com
For more options, visit this group at
http://groups.google.com/group/android-developers?hl=en
-~----------~----~----~----~------~----~------~--~---
