NewLC - Database APIs which can return a value telling that that the database is locked - Comments

Re: Database APIs which can return a value telling that that the

jp4symbian — Fri, 14 Sep 2007 09:42:15 +0200

Yes, InTransaction() does return boolean which means that it just tells whether the database in transaction or not.

So from this, you can make sure that whenever you are doing any update/delete/insert operation, you should always start an explicit transaction using Begin().
Then whenever you check InTransaction() for another simultaneous database operation, you are sure that currently database is locked since you have begun an explicit transaction somewhere else in your application.

So InTransaction() returning ETrue implies that database is locked.

And also as i earlier mentioned, TRAPping the database update APIs will also give you KErrLocked error.

Re: Database APIs which can return a value telling that that the

sumitskj — Fri, 14 Sep 2007 08:02:02 +0200

Hi,
Thanks for the information. So basically if I am using SQLs to manipulate with the database then Execute() returns KErrLocked and Begin() in case of Transaction.

InTransaction() returns boolean which means that it just tells whether the database in transaction or not.

Regards,
Sumit

Re: Database APIs which can return a value telling that that the

jp4symbian — Thu, 13 Sep 2007 08:27:12 +0200

Hi Sumit,

The other database APIs that let you know if database is locked is InTransaction() . You can check out the documentation for this API in the Class RDbDatabase.

Also on performing any other database operation like update/delete using UpdateL() or DeleteL(), if the operation is enclosed withing a TRAP harness, you will get a KErrLocked error.

Further, if you perform such an update or delete operation using a view and execute an SQL query in the database using Execute() function of Class RDbDatabase, it will return KErrLocked error if the database is locked.

Hope this helps..

Database APIs which can return a value telling that that the database is locked

sumitskj — Wed, 05 Sep 2007 08:35:30 +0200

Hi,