Question about adding a table to a deployed solution

Classic Servoy
1

I recently had to make a change to an deployed solution. The changes involved adding a new table, a new relation and a new form.

I connected to the production repository from Developer, opened the solution, added the above items and closed the solution but left Developer running.

I then went to the Server Admin console, flushed the solution and opened up the solution in a Servoy Client session. My changes didn’t work properly. It was as if the client weren’t fully aware of the changes.

Next I tried restarting Servoy Server (but no the db server). Client still didn’t work right.

Next I tried fully quitting out of Developer, flushing again and reopening in Client, and that time it worked.

So I have two questions:

  1. What is the proper procedure for deploying changes made directly on the repository from Developer, and

  2. Do I have to do anything special if those changes involve new db tables? Should I have restarted the db server?

Thanks, and happy holidays.

2
  1. What is the proper procedure for deploying changes made directly on the repository from Developer

Don’t know if this is the proper procedure but whenever I make changes to a running production environment I close developer after using it. I then perform necessary steps like flushing etc.

  1. Do I have to do anything special if those changes involve new db tables? Should I have restarted the db server?

Not really, see the above. Although, again, I would have done that.

BTW talking about proper procedures: the proper procedure is to NOT do this on a production system but via an import.

3

basic rules in this situation

  1. changes done with developer that don’t touch the database
    (scripts, relations, calcs, gui etc) >> flush the solution on the servoy app server
  2. changes done with developer (or a db tool) directly on your db
    (renaming columns adding deleting etc…) >> ALWAYS restart the servoy app server.

If you only flush your solution after db changes , you’re likely to be in trouble because app server and db will be out of sync.