Questions tagged [database-locking]
129 questions
0
votes
2 answers
Android NullPointerException and GetDatabaseLocked
Im trying to store a particular columns data in a method and call that method in another classes String [] where a spinner will access that array to display the columns rows for the user to select which will then get stored in another database.
Im…
user3408604
- 15
- 1
- 7
0
votes
2 answers
Insert dictionary in an SQLite db won't work
I'm trying to updating the SQLite db on the iPhone with a dictionary returned by my server.
sqlite3_step return sqlite_ok but the database still remain empty.
Anyway inserted a log for a possible error after sqlite3_step and this return "database…
Marco M
- 1,215
- 12
- 12
0
votes
2 answers
getting locks on table due to select queries?
we are using below select queries from long time.
But today we are receiving many locks on database.
Please help me how to resolve the locks due to select queries.
the table size is very small 300kb.
we optimized table but no luck
query info and…
user3048109
- 217
- 2
- 8
0
votes
1 answer
Neo4j - java.lang.IllegalStateException: Database locked
I am using Neo4j embedded in my project. Am running a thread which runs continuously and updates the properties of a node. When I tried to read the updated node from another thread I got java.lang.IllegalStateException: Database locked exception.…
yAsH
- 3,367
- 8
- 36
- 67
0
votes
1 answer
Process large amounts of XML how to not lock the database and best performance?
I have a database procedure which processes some XML and normalizes it into multiple tables.
I'm not a huge database guy and don't know the most about database locks, so I'm mostly just wondering if anything I am doing is completely wrong.
To start…
Kyle
- 17,317
- 32
- 140
- 246
0
votes
1 answer
SQLite 'Database Locked' weird error for specific queries
I'm working on a project in Java, where, I have to make modifications in my SQLite Database.
I connected to it and is working pretty fine, except for this weird error.
s.executeUpdate("INSERT INTO STUDENTS VALUES('S0',11)");
...
//many statements...…
Rajesh
- 79
- 2
- 3
- 9
0
votes
0 answers
What happens if you try to update a locked record in JET?
If I use JET/DAO to open a recordset on a MDB database using dbPessimistic locking, what will happen if another user tries to update a row in that recordset at that time? Will there be an error, or will JET/DAO keep trying until the row is…
CJ7
- 22,579
- 65
- 193
- 321
-1
votes
1 answer
Database getting locked while showing data in listview
Warning database has been locked for 0:00:10.000000. Make sure you always use the transaction object for database operations during a transaction.
I received this error while showing data in screen. And it takes too long so I have to reduce…
-1
votes
1 answer
Asynchronous Database Problems with Node.js
I am trying to query a database, running on a node server without express using sqlite3, to check if an element is in the database. Upon finding if this element exists, it will then go on to access a different table with this information.
var…
user122316
- 3
- 2