|
Home > Archive > SQL Anywhere Mobile > October 2005 > mobilink error:user 'dba' has the row in 'table_name' locked.
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
| Author |
mobilink error:user 'dba' has the row in 'table_name' locked.
|
|
|
| when i run my pocketbuilder application in my pc,synchronization is ok, but
when i deploy my application on my ipaq, sychronizaion sometimes is
ok,sometimes failed. when failed, the message in synchronization windows is:
"begin synchronization user:user1
pub names:napi
E. 10/17 21:11:02. SQL statement failed:(-210) User 'DBA' has the row in
'table_name1' locked.
end Synchronizaion error 1."
by the way,i use 'dba' to connect my adaptive server
| |
| Breck Carter [TeamSybase] 2005-10-27, 8:21 am |
| The most straightforward solution is to have your application do a
ROLLBACK or COMMIT on all open remote database connections before
starting a synchronization, then refrain from updating anything until
synchronization finishes.
Have a look at this section in the Help...
MobiLink Synchronization User's Guide
Adaptive Server Anywhere Clients
Initiating synchronization
Concurrency during synchronization
Breck
On 17 Oct 2005 06:26:09 -0700, "wayne" <huizh@webmail.nudt.edu.cn>
wrote:
>when i run my pocketbuilder application in my pc,synchronization is ok, but
>when i deploy my application on my ipaq, sychronizaion sometimes is
>ok,sometimes failed. when failed, the message in synchronization windows is:
>"begin synchronization user:user1
> pub names:napi
> E. 10/17 21:11:02. SQL statement failed:(-210) User 'DBA' has the row in
>'table_name1' locked.
> end Synchronizaion error 1."
>
>by the way,i use 'dba' to connect my adaptive server
>
--
SQL Anywhere Studio 9 Developer's Guide
Buy the book: http://www.amazon.com/exec/obidos/A...7/risingroad-20
bcarter@risingroad.com
RisingRoad SQL Anywhere and MobiLink Professional Services
www.risingroad.com
|
|
|
|
|