|
Home > Archive > SQL Anywhere ultralite > March 2006 > Ultralite synchronization within a transaction
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 |
Ultralite synchronization within a transaction
|
|
| Madhu Siddalingaiah 2006-03-22, 9:24 am |
|
I'm running v9.0.2.3249 with Pocket PC .NET, C#
Are uncommited writes to an ultralite database sent up during
synchronization?
We want to be able to rollback some inserts to the database if
synchronization fails due to some logic on the server. The writes are
done before sync starts, so it's not part of the sync transaction. We
are toying with the idea of starting a named transaction before sync, do
the inserts, do the sync and if it fails, rollback our named transaction.
Any thoughts?
| |
| Michael Thode 2006-03-22, 11:24 am |
| In ultralite you can't synchronize with uncommitted transactions. You will
get a sql error on the call to synchronize.
Mike
"Madhu Siddalingaiah" < msiddalingaiah@bcbsa
l.org> wrote in message
news:442179c9$1@foru
ms-1-dub...
>
> I'm running v9.0.2.3249 with Pocket PC .NET, C#
>
> Are uncommited writes to an ultralite database sent up during
> synchronization?
>
> We want to be able to rollback some inserts to the database if
> synchronization fails due to some logic on the server. The writes are done
> before sync starts, so it's not part of the sync transaction. We are
> toying with the idea of starting a named transaction before sync, do the
> inserts, do the sync and if it fails, rollback our named transaction.
>
> Any thoughts?
|
|
|
|
|