loose databroadcasting after switchServer()

Classic Servoy
1

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

2

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

3

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

4

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

5

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.

6

Alessandro,

Is this maybe the same issue as you reported in this thread?

Rob