SQL Anywhere Mobile - DROP user in sp_hook_dbmlsync_schema

Author

DROP user in sp_hook_dbmlsync_schema_upgrade?

Breck Carter [TeamSybase]

2005-08-17, 1:24 pm

In 9.0.2.3124, is it OK to execute the following statements in an
sp_hook_dbmlsync_sch
ema_upgrade procedure?

DROP SYNCHRONIZATION SUBSCRIPTION TO p;
DROP SYNCHRONIZATION SUBSCRIPTION FOR u;
DROP SYNCHRONIZATION USER u;
CREATE SYNCHRONIZATION USER u;
CREATE SYNCHRONIZATION SUBSCRIPTION TO p FOR u;

In other words, is it OK to purge and recreate the synch user that is
currently synchronizing? I'm guessing the answer is "no".

I am looking for a place to change the synch user after an initial
sync, somewhere other than an application connection event since this
app is keeping its connections open.

Breck

--
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

David Fishburn

2005-08-17, 1:24 pm

"Breck Carter [TeamSybase]" < NOSPAM__bcarter@risi
ngroad.com> wrote in
news:kar6g1dem89r111
os909vvha26vqshhq4m@
4ax.com of
sybase.public.sqlanywhere.mobilink:

BC> In 9.0.2.3124, is it OK to execute the following statements in an
BC> sp_hook_dbmlsync_sch
ema_upgrade procedure?
BC>
BC> DROP SYNCHRONIZATION SUBSCRIPTION TO p;
BC> DROP SYNCHRONIZATION SUBSCRIPTION FOR u;
BC> DROP SYNCHRONIZATION USER u;
BC> CREATE SYNCHRONIZATION USER u;
BC> CREATE SYNCHRONIZATION SUBSCRIPTION TO p FOR u;
BC>
BC> In other words, is it OK to purge and recreate the synch user that is
BC> currently synchronizing? I'm guessing the answer is "no".
BC>
BC> I am looking for a place to change the synch user after an initial
BC> sync, somewhere other than an application connection event since this
BC> app is keeping its connections open.

Hmmm, I would do this:
Define all the sp_hook_dbmlsync stored procedures. The code should
simply do a MESSAGE of the name of the procedure.

Run dbmlsync using -v+ -e Verbose=on -ot rem.txt

Then try your test with the drops above.
I would be interested in:
1. Does dbmlsync still successfully work after you do this (you would
need at least 9.0.2 to even attempt it).
2. Which hooks get called after the schema upgrade hook.

--
David Fishburn
Certified ASA Developer Version 8
iAnywhere Solutions - Sybase
Professional Services
Please only post to the newsgroup
Please ALWAYS include version and MORE importantly BUILD number with
EACH post (dbeng9 -v).

EBFs and Maintenance Releases
http://downloads.sybase.com/swx/sdmain.stm

Developer Community / Whitepapers
http://www.ianywhere.com/developer

CaseXpress - to report bugs
http://casexpress.sybase.com

CodeXchange - Free samples
[url]http://ianywhere.codexchange.sybase.com/servlets/ ProjectDocumentList[
/url]

Sponsored Links