Concepts for Disconnected Clients?

Discuss the Offline version of Servoy that allows you to run Servoy applications on and offline by using synchronization technology like Mobilink and SQL Remote.

Concepts for Disconnected Clients?

Postby Kahuna » Fri Sep 02, 2011 9:07 am

Hi Folks

We will be deploying hand held equipment (running win 7) pretty soon and these will be disconnected almost all of the time. Occasionally they will be connecting to sync databases.

Having looked at the Runtime Client we notice that there is the limitation of connecting to only one Db at a time. In our solution we need to attach to two Db's as a minimum - one for our admin libraries etc, and a second for user data. This model is essential for us so unlikely to be able to change that.

The alternative is a full Servoy Server install on these units (not an issue) but we are then left with a requirement for some method to update the solution remotely without a direct connection to the unit?

Is there a way to update a solution on a server through code?
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain

Re: Concepts for Disconnected Clients?

Postby mboegem » Fri Sep 02, 2011 12:43 pm

Hi Ian,

if I'm not mistaken this subject was covered on ServoyCamp 2009. I didn't go through the whole vid, but I think it might be useful to you
http://vimeo.com/8593825
_____________________
Marc Boegem
Solutiative / JBS Group, Partner
• Servoy Certified Developer
• Servoy Valued Professional
• Freelance SAN Developer

Image
User avatar
mboegem
 
Posts: 1382
Joined: Sun Oct 14, 2007 1:34 pm
Location: Hoofddorp, The Netherlands

Re: Concepts for Disconnected Clients?

Postby Kahuna » Fri Sep 02, 2011 2:27 pm

mboegem wrote:Hi Ian,

if I'm not mistaken this subject was covered on ServoyCamp 2009. I didn't go through the whole vid, but I think it might be useful to you
http://vimeo.com/8593825


Thanks Marc - I think Danny was talking about getting config and system files into the Client (reports and other config information). I'll review the whole thing because he has some good ideas on versioning of the Plugins etc which we had not thought through completely. But what I think we need to determine is if there is some way to upgrade a solution on a remote unit without the user having to go through the admin page to import it himself.

We are working on a tool for data and structure syncing - its the solution that is the concern.

Cheers
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain

Re: Concepts for Disconnected Clients?

Postby antonio » Sat Sep 24, 2011 10:25 pm

Did you solve this?
Have a look at viewtopic.php?f=3&t=7262#_thread
antonio
 
Posts: 622
Joined: Sun Apr 02, 2006 2:14 am
Location: Australia

Re: Concepts for Disconnected Clients?

Postby Kahuna » Mon Oct 03, 2011 9:09 am

antonio wrote:Did you solve this?
Have a look at viewtopic.php?f=3&t=7262#_thread


Hi Antonio - did you develop code to restart the server with the new solution on board or is that not a requirement to make the new import active?

Great idea BTW - I'll trial it this week. Thanks for the heads up.
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain

Re: Concepts for Disconnected Clients?

Postby antonio » Mon Oct 03, 2011 10:23 am

Hi Kahuna,

Not sure if you need to restart the server, though I do recall some problems when there were table changes.
Tony
Servoy Developer Version 5.2.16
Developer MAC OSX 10.8.4 Java version 1.6.0_51
Production Debian Linux Java version 1.6.0_29
antonio
 
Posts: 622
Joined: Sun Apr 02, 2006 2:14 am
Location: Australia

Re: Concepts for Disconnected Clients?

Postby Kahuna » Mon Oct 03, 2011 11:32 am

antonio wrote:Hi Kahuna,

Not sure if you need to restart the server, though I do recall some problems when there were table changes.


I'm guessing a server restart will be essential where table changes are required - I've noticed in Developer that sometime the Reload Tables does not work and a developer restart is necessary - though this may not be the case in straight server.

Anyone know of a way to automatically restart the server from code?
(Servoy Version: 6.0.7 Win XP / 7 - SQL Server 2008 R2)
Ian Cordingley (Kahuna)
Kahuna
 
Posts: 1235
Joined: Thu Oct 26, 2006 1:39 am
Location: 1/2 NE UK 1/2 Olvera Spain


Return to Servoy Offline Client

Who is online

Users browsing this forum: No registered users and 2 guests