# loose databroadcasting after switchServer()

**URL:** <https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824>\
**Category:** Classic Servoy\
**Created:** [September 7, 2010, 4:10pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824 "2010-09-07T16:10:45Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![stefanoni](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@stefanoni](https://forum.servoy.com/u/stefanoni)\
**Post date:** [September 7, 2010, 4:10pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/1 "2010-09-07T16:10:45Z")

</div>

In this situation I loose the databroadcasting:

- switchServer() from B to A in smartclient
- change data on the same record (server A) in webclient
- no databroadcasting anymore to smartclient on server A !

after this I do (as a workarround):

- switchServer() from A to B to A in smartclient ( shaking the connection )
- databroadcasting is working correct again

Can it be, that I try to do things that servoy dont realy like, cause it is not made for ?  
How much can i trust to switchServer() ? Anyone used it really practically ?

Thanke you for your suggestion

---

<div class="post-metadata">

**Author:** ![jkipling](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jkipling](https://forum.servoy.com/u/jkipling)\
**Post date:** [September 8, 2010, 2:05pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/2 "2010-09-08T14:05:34Z")

</div>

Hi Alessandro,

I’ve observed the same problem in the past using the latest version of servoy in January 2009. Using switchServer() seemed to disrupt proper dataBroadcasting.

-Jeremy

---

<div class="post-metadata">

**Author:** ![ROCLASI](https://yyz2.discourse-cdn.com/flex010/user_avatar/forum.servoy.com/roclasi/32/4371_2.png) [@ROCLASI](https://forum.servoy.com/u/ROCLASI)\
**Post date:** [September 8, 2010, 6:15pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/3 "2010-09-08T18:15:53Z")

</div>

Hi Alessandro/Jeremy,

Are connection A end B connections to different physical databases?  
And do these 2 databases have the same datamodel (i.e. being a clone of each other)?

---

<div class="post-metadata">

**Author:** ![stefanoni](https://avatars.discourse-cdn.com/v4/letter/s/bb73d2/32.png) [@stefanoni](https://forum.servoy.com/u/stefanoni)\
**Post date:** [September 9, 2010, 6:29am UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/4 "2010-09-09T06:29:15Z")

</div>

> ROCLASI:  
> Are connection A end B connections to different physical databases?

A is localhost mysql  
B is localhost postgre  
C is www mysql

> ROCLASI:  
> And do these 2 databases have the same datamodel (i.e. being a clone of each other)?

All Databases include all necessary fields and fieldtypes compared with the servoy-datamodel.

This problem could be worked arround easy, if i had a possibillity to cut the connection completely,  
clearing all the buffers /temps after switchServer() and then establish the link again. Is this possible ?

regards

---

<div class="post-metadata">

**Author:** ![jkipling](https://avatars.discourse-cdn.com/v4/letter/j/ce73a5/32.png) [@jkipling](https://forum.servoy.com/u/jkipling)\
**Post date:** [September 9, 2010, 9:03pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/5 "2010-09-09T21:03:53Z")

</div>

In my example both servers were the standard Sybase iAnywhere databases and were identical in structure.

We were trying to use switchServer() as a means to give different clients access to their own set of data and no one elses.

---

<div class="post-metadata">

**Author:** ![rgansevles](https://avatars.discourse-cdn.com/v4/letter/r/3d9bf3/32.png) [@rgansevles](https://forum.servoy.com/u/rgansevles)\
**Post date:** [September 10, 2010, 4:37pm UTC](https://forum.servoy.com/t/loose-databroadcasting-after-switchserver/12824/6 "2010-09-10T16:37:19Z")

</div>

Alessandro,

Is this maybe the same issue as you reported in [this](http://forum.servoy.com/viewtopic.php?f=5&t=14837) thread?

Rob