Re: [android-developers] Re: error code 5: database is locked

2010-11-02 Thread Kostya Vasilyev
William, This: http://developer.android.com/reference/android/database/sqlite/SQLiteDatabase.html#setLockingEnabled(boolean) suggests that thread-safe locking is enabled by default. Are you turning it off somewhere, perhaps? If not, I think you could try calling this method to explicitly

[android-developers] Re: error code 5: database is locked

2010-11-01 Thread William Ferguson
I'm seeing the same thing. And to answer the questions: 1 - There is no other app using my db, though it is accessed from both my Activity and an IntentService within my app. Both of which needs write access. 2 - I closed the cursor every time. I cannot see any need for the entire DB to be

[android-developers] Re: error code 5: database is locked

2010-11-01 Thread William Ferguson
I have seen some other discussions on this issue for Sqlite and the solution was to increase the busy timeout for the DB. Anyone know how that is achieved on Android? On Nov 2, 12:14 am, William Ferguson william.ferguson...@gmail.com wrote: I'm seeing the same thing. And to answer the

[android-developers] Re: error code 5: database is locked

2010-10-25 Thread gcstang
ping, anyone that can answer this? On Oct 16, 10:58 am, gcstang gcst...@gmail.com wrote: Here is the stack: android.database.sqlite.SQLiteException:errorcode5:databaseislocked         at android.database.sqlite.SQLiteStatement.native_execute(Native Method)         at

[android-developers] Re: error code 5: database is locked

2010-10-25 Thread AJ
Hi gcstang, Very basic but check the following:- 1- Is any other app using your DB? 2- Did you close the cursor every time when you opened it? Thanks, AJ On Oct 25, 5:41 pm, gcstang gcst...@gmail.com wrote: ping, anyone that can answer this? On Oct 16, 10:58 am, gcstang gcst...@gmail.com

[android-developers] Re: error code 5: database is locked

2010-10-16 Thread gcstang
Here is the stack: android.database.sqlite.SQLiteException: error code 5: database is locked at android.database.sqlite.SQLiteStatement.native_execute(Native Method) at android.database.sqlite.SQLiteStatement.execute(SQLiteStatement.java: 55) at

[android-developers] Re: error code 5: database is locked

2010-10-15 Thread DanH
Where is the error being thrown from? (You might include the exception traceback.) On Oct 15, 9:44 am, gcstang gcst...@gmail.com wrote: Has anyone encountered this and is there a solution to work around it? I'm creating a Thread and in that thread I open a database connection using the

[android-developers] Re: Error Code 5: Database is locked

2009-10-14 Thread mathias axelsson
I use synchronized(ExampleDbAdapter.class){mDb.insert/update/delete/query...} in ExampleDbAdapter to avoid this. Let me know if there's a better way. On Mon, Aug 24, 2009 at 10:58 AM, Armond Avanes armond...@yahoo.com wrote: So how can I create an in-memory database? I just took a quick look

[android-developers] Re: Error Code 5: Database is locked

2009-08-24 Thread Armond Avanes
So how can I create an in-memory database? I just took a quick look at the API and couldn't find any. Cheersss, Armond develop...@googlegroups.com] On Behalf Of Andrei Sent: Monday, August 24, 2009 7:35 AM If your write time take long i would try this I would create another in memory

[android-developers] Re: Error Code 5: Database is locked

2009-08-23 Thread Armond Avanes
I forgot to mention that this exception happens (so far) from the service I have for updating database (is executed every 24 hours). Cheersss, Armond Hi Guys, I have different background threads in my application, one doing periodical database updates, another responsible for doing long

[android-developers] Re: Error Code 5: Database is locked

2009-08-23 Thread Andrei
If your write time take long i would try this I would create another in memory database, attach it to yours. In memory database table would have same schema. You would write to in memory database and after done do insert into db1.table as select * from db2.table I did something similar but on

[android-developers] Re: Error code

2009-03-24 Thread Eric Wong (hdmp4.com)
That's a great idea. Probably doesn't work work for Google when all employee have free food to start with..(right?) Cheers Eric On Mar 22, 6:42 pm, Al Sutton a...@funkyandroid.com wrote: I used to work for a company where anyone who checked in code that broke the build and didn't fix

[android-developers] Re: Error code

2009-03-22 Thread Al Sutton
I used to work for a company where anyone who checked in code that broke the build and didn't fix it within a couple of hours had to buy a round of cakes or doughnuts for the dev team. Amazingly enough it reduced broken builds as opposed to increasing wastelines. Al. Jean-Baptiste Queru

[android-developers] Re: Error code

2009-03-21 Thread Jean-Baptiste Queru
Heh. Jason Parks is my manager at Google, he's a member of the Core Technical Team for the Android Open-Source Project, and he is responsible for the overall performance and stability of the Android platform. He broke it because, well, that's what he does ;-) JBQ On Fri, Mar 20, 2009 at 4:40